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
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
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
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
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
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
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
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
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
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
10 matches
Mail list logo