Re: Hive config problems

2010-09-06 Thread John Sichi
This is due to the recent commit of HIVE-675; if you picked it up and applied it on an existing metastore, you'll need to issue an ALTER TABLE statement explicitly (with a default value for this column) against your metastore DB. Carl will be providing the script for MySQL as part of HIVE-1427.

Re: Insert to HBase table works,but Select shows no rows

2010-09-06 Thread John Sichi
Hmmm, anything interesting in the task logs? Seems like somehow the task tracker nodes can't see the HBase table whereas the client node can, but I would expect then to see an error instead of zero rows. JVS On Sep 4, 2010, at 4:36 PM, phil young wrote: I can confirm the HBase table is popula

Re: Insert to HBase table works,but Select shows no rows

2010-09-06 Thread phil young
I assume there's some config parameter not set, because I've installed the current Hive trunk, installed HBase 0.20.3, and am using Hadoop Core 0.20.2. I'm still seeing the same behavior (i.e. the HBase table is loaded via Hive, but only select * works from it, select count(1) and other operations

Re: ODBC isql error while testing

2010-09-06 Thread Ning Zhang
It looks like isql cannot load libodbchive.so. Please make sure that all three .so files libodbchive.so, libhiveclient.so, and libthrift.so can be found in LD_LIBRARY_PATH. On Sep 4, 2010, at 1:31 PM, Ariel Leiva wrote: > Hi, i built Hive odbc driver following > http://wiki.apache.org/hadoop