Nitin,
Thank you for the look.. I thought this would be as easy using regular
sql :)
I cannot run selects on my columns in the database tables as well. However if
I do a select * on the whole table get data back...
When I run: select batch_id from example1; I get the data...
I am a little concerned with the zero length files...
./hdfs dfs -ls /user/hive/warehouse
Found 4 items
drwxr-xr-x - hduser supergroup 0 2014-01-14 11:33
/user/hive/warehouse/example1
drwxr-xr-x - hduser supergroup 0 2014-01-14 09:58
/user/hive/warehouse/miidata1
drwxr-xr-x - hduser supergroup 0 2014-01-14 11:08
/user/hive/warehouse/miidata2
drwxr-xr-x - hduser supergroup 0 2014-01-12 11:42
/user/hive/warehouse/pokes
From: Nitin Pawar [mailto:[email protected]]
Sent: Tuesday, January 14, 2014 1:42 PM
To: [email protected]
Subject: Re: Select statement does not return data...
this is not complete log.
Can you paste last few lines of the console when you get hive prompt again on
cli.
Also check by running hadoop dfs -ls <table location> and see if you have got
data loaded into table
On Wed, Jan 15, 2014 at 12:07 AM, Kennedy, Sean C.
<[email protected]<mailto:[email protected]>> wrote:
My select does not return data? Any help? The example1 table is there..
hive> SELECT COUNT(1) FROM example1;
Total MapReduce jobs = 1
Launching Job 1 out of 1
Number of reduce tasks determined at compile time: 1
In order to change the average load for a reducer (in bytes):
set hive.exec.reducers.bytes.per.reducer=<number>
In order to limit the maximum number of reducers:
set hive.exec.reducers.max=<number>
In order to set a constant number of reducers:
set mapred.reduce.tasks=<number>
Notice: This e-mail message, together with any attachments, contains
information of Merck & Co., Inc. (One Merck Drive, Whitehouse Station,
New Jersey, USA 08889), and/or its affiliates Direct contact information
for affiliates is available at
http://www.merck.com/contact/contacts.html) that may be confidential,
proprietary copyrighted and/or legally privileged. It is intended solely
for the use of the individual or entity named on this message. If you are
not the intended recipient, and have received this message in error,
please notify us immediately by reply e-mail and then delete it from
your system.
--
Nitin Pawar
Notice: This e-mail message, together with any attachments, contains
information of Merck & Co., Inc. (One Merck Drive, Whitehouse Station,
New Jersey, USA 08889), and/or its affiliates Direct contact information
for affiliates is available at
http://www.merck.com/contact/contacts.html) that may be confidential,
proprietary copyrighted and/or legally privileged. It is intended solely
for the use of the individual or entity named on this message. If you are
not the intended recipient, and have received this message in error,
please notify us immediately by reply e-mail and then delete it from
your system.
