RE: Related to INSERT QUERY in Hive

2012-01-17 Thread Krishnan Krishnamoorthy
Hi Aniket/Bhavesh, Actually load data inpath is used for appending file and the path refers to the HDFS path. We can use load data local inpath in case the input file to be loaded is not in HDFS but it is present in the local system. Both of these append the data. In case, you need to overwrit

Re: Related to INSERT QUERY in Hive

2012-01-17 Thread Ankit Jain
Load data inpath will append data into Hive table .. this feature is also supported in Hive-0.7.*. Ex: load data local inpath './examples/files/kv1.txt' into table test1; This commad will append data into test1 table. On Wed, Jan 18, 2012 at 10:55 AM, Aniket Mokashi wrote: > how about Load dat

Re: Related to INSERT QUERY in Hive

2012-01-17 Thread Aniket Mokashi
how about Load data inpath? On Tue, Jan 17, 2012 at 9:00 PM, Bhavesh Shah wrote: > Hello, > I am using Hive-0.7.1. I want to append the data in table. > Is hive-0.7.1 support appending feature or just support OVERWRITE feature? > When I tried for the appending, the query is not working. > > What

Re: Related to INSERT QUERY in Hive

2012-01-17 Thread Able C
Hello Bhavesh Shah: Appending feature (insert into ) not supported in hive-0.7.* three ways : 1:hadoop fs -put localfile hdfs:/.../.../table_dir/partiton_dir/ 2:use hive-0.8 3: patch your hive with https://issues.apache.org/jira/browse/HIVE-306 2012/1/18 Bhavesh Shah > Hello, > I am using

Related to INSERT QUERY in Hive

2012-01-17 Thread Bhavesh Shah
Hello, I am using Hive-0.7.1. I want to append the data in table. Is hive-0.7.1 support appending feature or just support OVERWRITE feature? When I tried for the appending, the query is not working. What should I do in such case so that I append the data in table? -- Thanks and Regards, Bhavesh

Re: Cannot create an instance of InputFormat

2012-01-17 Thread Aniket Mokashi
Everything in auxlib is added to HADOOP_CLASSPATH. But, the paths in HADOOP_CLASSPATH are added to the class path of the Job Client, but they are not added to the class path of the Task Trackers. Therefore if you put a JAR called MyJar.jar on the HADOOP_CLASSPATH and don't do anything to make it av

Re: Cannot create an instance of InputFormat

2012-01-17 Thread Edward Capriolo
I generally have to put them in my hadoop classpath or hive-0.8.0/auxlib folder. I never quite understood why buy the classpath that reads the data seems different from the classpath that processes the data. Hence the distrinction between add jar and auxlib. Edward On Tue, Jan 17, 2012 at 6:39 AM

Re: Error while starting HiveServer

2012-01-17 Thread hadoop hive
check your hosts file its should have the entry of NN . On Tue, Jan 17, 2012 at 5:36 PM, Bhavesh Shah wrote: > Hello, > While starting hive server I am getting error as: > hadoop@ubuntu:~/hive-0.7.1$ bin/hive --service hiveserver > Starting Hive Thrift Server > org.apache.thrift.transport.TTransp

Error while starting HiveServer

2012-01-17 Thread Bhavesh Shah
Hello, While starting hive server I am getting error as: hadoop@ubuntu:~/hive-0.7.1$ bin/hive --service hiveserver Starting Hive Thrift Server org.apache.thrift.transport.TTransportException: Could not create ServerSocket on address 0.0.0.0/0.0.0.0:1. at org.apache.thrift.transport.TServerS

Cannot create an instance of InputFormat

2012-01-17 Thread Bing Li
My Steps: I define a class "public class myInputFormat extends TextInputFormat implements JobConfigurable" to specify input format. hive> add jar /home/biadmin/hiveudf/myFileFormat.jar; Added /home/biadmin/hiveudf/myFileFormat.jar to class path Added resource: /home/biadmin/hiveudf/myFileFormat.ja