Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 45A75DA15 for ; Fri, 6 Jul 2012 09:18:21 +0000 (UTC) Received: (qmail 6540 invoked by uid 500); 6 Jul 2012 09:18:20 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 6498 invoked by uid 500); 6 Jul 2012 09:18:20 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 6474 invoked by uid 99); 6 Jul 2012 09:18:19 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 06 Jul 2012 09:18:19 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [203.91.198.74] (HELO wipro-blr-out01.wipro.com) (203.91.198.74) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 06 Jul 2012 09:18:12 +0000 X-AuditID: cb5bdd57-b7c6fae000006933-80-4ff6ad3b165f Received: from BLR-OUT-EDG01.wipro.com ( [203.91.193.31]) (using TLS with cipher AES128-SHA (AES128-SHA/128 bits)) (Client did not present a certificate) by wipro-blr-out01.wipro.com (Symantec Mail Security) with SMTP id 40.1C.26931.B3DA6FF4; Fri, 6 Jul 2012 14:47:47 +0530 (IST) Received: from BLR-EC-MBX8.wipro.com (10.208.51.118) by BLR-OUT-EDG01.wipro.com (203.91.193.31) with Microsoft SMTP Server (TLS) id 14.1.289.1; Fri, 6 Jul 2012 14:49:42 +0530 Received: from BLR-EC-MBX3.wipro.com ([169.254.3.167]) by BLR-EC-MBX8.wipro.com ([169.254.8.54]) with mapi id 14.01.0289.001; Fri, 6 Jul 2012 14:47:47 +0530 From: To: Subject: HIVE table showing NULL Thread-Topic: HIVE table showing NULL Thread-Index: Ac1bVn6MDU/gC3inS5WdImAI9LEFZg== Importance: high X-Priority: 1 Date: Fri, 6 Jul 2012 09:17:46 +0000 Message-ID: <2ADA1B0170E3434DA763D609DCD01EB541DB5EB0@BLR-EC-MBX3.wipro.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.203.33.76] Content-Type: multipart/alternative; boundary="_000_2ADA1B0170E3434DA763D609DCD01EB541DB5EB0BLRECMBX3wiproc_" MIME-Version: 1.0 X-Brightmail-Tracker: AAAAAQAAAZE= X-Virus-Checked: Checked by ClamAV on apache.org --_000_2ADA1B0170E3434DA763D609DCD01EB541DB5EB0BLRECMBX3wiproc_ Content-Type: text/plain; charset="iso-8859-1" content-transfer-encoding: quoted-printable 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 t= his command. LOAD DATA INPATH 'hdfs://localhost:9000/HADOOP/hadoop-0.20.2/tichh7/part-m-0= 0000' 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. =0A= =0A= 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. =0A= =0A= WARNING: Computer viruses can be transmitted via email. The recipient should= check this email and any attachments for the presence of viruses. The compa= ny accepts no liability for any damage caused by any virus transmitted by th= is email. =0A= =0A= www.wipro.com --_000_2ADA1B0170E3434DA763D609DCD01EB541DB5EB0BLRECMBX3wiproc_ Content-Type: text/html; charset="iso-8859-1" content-transfer-encoding: quoted-printable
Hi all

I have created a table tich in Mysql, its structure is:

Num           Name
-------------------------
01            &n= bsp;  Yogesh

and imported it into HDFS by using sqoop's command

sqoop import --connect jdbc:mysql://local= host: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 STRI= NG)

now I am trying to upload that table record from HDFS to hive table I used t= his command.

LOAD DATA INPATH 'hdfs://localhost:9000/H= ADOOP/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/w= arehouse/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 unl= ess it is absolutely necessary.

=0A= =0A= =0A=

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.

=0A= =0A=

WARNING: Computer viruses can be transmitted via email. The recipient sho= uld check this email and any attachments for the presence of viruses. The co= mpany accepts no liability for any damage caused by any virus transmitted by= this email.

=0A=

=0A= www.wipro.com=0A=

--_000_2ADA1B0170E3434DA763D609DCD01EB541DB5EB0BLRECMBX3wiproc_--