Hi yogesh,
I too come across this prob,give the syntax as : *load data
local inpath './xyz.txt’ into table abc;*
here yogesh when creating the hive table u have metion the file type eg
like , or tilda or pipe see below
*create table vender(vender string,supplier string,order_date
st
Yes Mohammad it worked fine,
Thank you :-)
Regards
Yogesh Kumar
__
From: Mohammad Tariq [donta...@gmail.com]
Sent: Thursday, July 12, 2012 4:34 PM
To: user@hive.apache.org
Subject: Re: hive opload shows NULL from hdfs
Did it work fine??
Regards,
Mohammad
To: user@hive.apache.org
> Subject: Re: hive opload shows NULL from hdfs
>
> Create your table using this command :
>
> create table parthp (no INT , name STRING , result STRING , class INT
> ) row format delimited fields terminated by "," ;
>
> In hive the delimi
Thanks Mohammad :-)
Regards
Yogesh Kumar
From: Mohammad Tariq [donta...@gmail.com]
Sent: Thursday, July 12, 2012 3:52 PM
To: user@hive.apache.org
Subject: Re: hive opload shows NULL from hdfs
Create your table using this command :
create table parthp (no
Create your table using this command :
create table parthp (no INT , name STRING , result STRING , class INT
) row format delimited fields terminated by "," ;
In hive the delimiters are assumed to be ^A(ctrl-a), by default.
Regards,
Mohammad Tariq
On Thu, Jul 12, 2012 at 3:46 PM, wrote:
Hi all,
I am trying to upload files from hdfs to hive table,
file in hdfs are imported by sqoop tool from mysql having table structure
**
noname result class
-
6 vishu pass7
7 hana pass6
**
