Re: hive query with in statement

2014-08-13 Thread Tuong Tr.
Ilhami, You probably better off casting the arguments for a couple of benefits: select * from cdr where calldate in  (cast('2014-08-11' as date),cast('2014-05-02' as date)) 1. Comparison is done in proper type semantics, and bad argument  to IN will raise proper error as opposed to producing i

Re: Get 'TBLPROPERTIES' of a Hive table in Java

2014-07-22 Thread Tuong Tr.
Hi, You should be able to find what you need to do in the getSchema() method inside  hive/ql/src/java/org/apache/hadoop/hive/ql/io/avro/AvroGenericRecordReader.java. The table properties does not get copied into the jobconf in M/R job's passedin jobconf.  so there is some complex logic to trac