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
string,quantity int) row format delimited fields terminated by ', ' stored
as textfile;
*
this syntax above is the comma separated file .try it out it will be help
i guess.
Regards
shaik.
On Thu, Jul 12, 2012 at 3:46 PM, <yogesh.kuma...@wipro.com> 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
>
> ******************************************
>
> no name result class
> ---------------------------------
> 6 vishu pass 7
> 7 hana pass 6
>
> ******************************************
>
> in hdfs it shows there records as
>
> hadoop dfs -cat /try/part/part-m-00003
> 6,vishu,pass,7
> 7,hana,pass,6
>
> now I have created table in hive ( using same datatype as were in mysql)
>
> create table parthp (no INT , name STRING , result STRING , class INT ) ;
>
> and used this command to upload data into hive table
>
> hive> load data inpath 'hdfs://localhost:9000/try/part/part-m-00003' into
> table parthp ;
>
> and it results.
>
> hive> load data inpath 'hdfs://localhost:9000/try/part/part-m-00003' into
> table parthp ;
> Loading data to table default.parthp
> OK
> Time taken: 0.145 seconds
>
> now if i do
>
> hive> select * from parthp;
> it results
>
> hive> select * from
> parthp;
> OK
> NULL NULL NULL NULL
> NULL NULL NULL NULL
> Time taken: 0.056 seconds
>
> why is it showing null, I have used the same data types as were in MySql,
>
> (no INT(11) --> no INT, name VARCHAR(45) ---> name STRING , result
> VARCHAR(45) ----> result STRING , class INT(11) ---> class INT)
>
> Please suggest and help
>
> Thanks & Regards
> Yogesh Kumar
>
>
>
> *Please do not print this email unless it is absolutely necessary. *****
>
> The information contained in this electronic message and any attachments
> to this message are intended for the exclusive use of the addressee(s) and
> may contain proprietary, confidential or privileged information. If you are
> not the intended recipient, you should not disseminate, distribute or copy
> this e-mail. Please notify the sender immediately and destroy all copies of
> this message and any attachments.
>
> WARNING: Computer viruses can be transmitted via email. The recipient
> should check this email and any attachments for the presence of viruses.
> The company accepts no liability for any damage caused by any virus
> transmitted by this email.
>
> www.wipro.com
>
