Re: issure about add new columns in table ,but use hive-jdbc can not get these clumns value

2013-11-27 Thread ch huang
seems hive jdbc cache the metadata from remote metadata database,but when i test on partition table ,it's not a metadata sync problem ,the all new column value is NULL hive (default)> create external table test_alex1_part (id string,myname string) partitioned by(dt string); OK Time taken: 0.263 s

issure about add new columns in table ,but use hive-jdbc can not get these clumns value

2013-11-27 Thread ch huang
hi,maillist: i add some new columns to hive table ,but find when i use beeline, or write my own java code,i can not get these new columns value,but when i use hive shell,it's ok 0: jdbc:hive2://localhost:1> desc test_alex1; +---++--+ | col_name | da

why the command execution will stall for 1 min somthing in hive shell

2013-11-27 Thread ch huang
Time taken: 0.272 seconds hive (default)> drop table demo3; OK Time taken: 60.524 seconds hive (default)> create table demo3 like demo; OK Time taken: 0.273 seconds

Re: Error inserting data to ORC table

2013-11-27 Thread Prasanth Jayachandran
Hi Juan This seems like a bug in version 2 of RLE (Run Length Encoding) that was implemented in Hive 0.12. New version of RLE can be disabled by setting hive.exec.orc.write.format=“0.11”. This will fallback to old version RLE. The reason why changing it to string type works is that, string col

Error inserting data to ORC table

2013-11-27 Thread Juan Martin Pampliega
Hi, I am using Hive 0.12 with Hadoop 2.2 and trying to insert data in a new ORC table with an INSERT SELECT statement from a TEXT file based table and I am running into the following error (I have trimmed some of the data showed in the error): Caused by: org.apache.hadoop.hive.ql.metadata.HiveExc