Re: Issue while working with parquet hive

2015-08-05 Thread Sergio Pena
Hi Santlal, The problem is that BIGDECIMAL is not a Hive keyword for data types. DECIMAL is the one you should use as this uses 'bigdecimal' java type internally. You can read more information on this wiki: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types#LanguageManualTypes-D

Issue while working with parquet hive

2015-08-03 Thread Santlal J Gupta
Hi, I want to use Date and BigDecimal datatype with parquet hive. Currently I am using Hive 0.12.0-cdh5.1.0 version. When I have written following query I get as given below . Query : hive (primitive_db)> create table big_date_test( dob DATE , salary BIGDECIMAL ) stored as parquet; NoViableA