HIVE 2.1.1 @ Cloudera 6.0.1 with Parquet

[#1]

Hello,

            we are testing HIve 2.1.1 of Cloudera 6.0.1 , but we are getting unexpected behaviours. 

In particular with some datatype we are getting error:

from org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.UnsupportedOperationException: Parquet does not support date. See HIVE-6384

By the way the issue HIVE-6384  is resolved from Hive 1.2 ( HIVE-6384 )

To replicate the problem, for example :

create table testdate (
part int ,
a date )
STORED AS PARQUET;

We try this in 2 clusters both upgraded from 5.X .

Thank you in advance

[#2 · Accepted solution]

Hi,

Hive-6384 is not included as part of any CDH5/CDH6 release, We do have an internal feature request JIRA available to track the back porting of HIVE-6384 in a future CDH releases.

Currently the workaround is to use a STRING datatype or the TIMESTAMP [1] datatype instead of the DATE datatype.

Thanks

Jerry