Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - HIVE table showing NULL


Copy link to this message
-
Re: HIVE table showing NULL
Nitin Pawar 2012-07-06, 09:26
can you do " hadoop dfs -cat <file_path>"

this will tell us wats the content of file

On Fri, Jul 6, 2012 at 2:47 PM, <[EMAIL PROTECTED]> wrote:

>  Hi all
>
> I have created a table tich in Mysql, its structure is:
>
> Num           Name
> -------------------------
> 01               Yogesh
>
> and imported it into HDFS by using sqoop's command
>
> sqoop import --connect jdbc:mysql://localhost:3306/Demo --username sqoop1
> --password SQOOP1 --table tich --target-dir /HADOOP/hadoop-0.20.2/tichh7
>
> it imported successfully
> I created a table in hive called ticchi as
>
> create table tichhi ( num INT , Name STRING)
>
> now I am trying to upload that table record from HDFS to hive table I used
> this command.
>
> LOAD DATA INPATH
> 'hdfs://localhost:9000/HADOOP/hadoop-0.20.2/tichh7/part-m-00000' OVERWRITE
> INTO TABLE tichhi ;
>
> optput is
>
> Loading data to table default.tichhi
> Deleted hdfs://localhost:9000/user/hive/warehouse/tichhi
> OK
> Time taken: 0.14 seconds
>
> Then I looked the records into hive table using and found values NULL
>
> hive> select * from tichhi;
> OK
> NULL    NULL
> Time taken: 0.051 seconds
>
> please help me and suggest why is it so
>
> 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
>

--
Nitin Pawar