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;
NoViableAltException(26@[])
at
org.apache.hadoop.hive.ql.parse.HiveParser.type(HiveParser.java:31711)
at
org.apache.hadoop.hive.ql.parse.HiveParser.colType(HiveParser.java:31476)
at
org.apache.hadoop.hive.ql.parse.HiveParser.columnNameType(HiveParser.java:31176)
at
org.apache.hadoop.hive.ql.parse.HiveParser.columnNameTypeList(HiveParser.java:29401)
at
org.apache.hadoop.hive.ql.parse.HiveParser.createTableStatement(HiveParser.java:4439)
at
org.apache.hadoop.hive.ql.parse.HiveParser.ddlStatement(HiveParser.java:2084)
at
org.apache.hadoop.hive.ql.parse.HiveParser.execStatement(HiveParser.java:1344)
at
org.apache.hadoop.hive.ql.parse.HiveParser.statement(HiveParser.java:983)
at
org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:190)
at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:434)
at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:352)
at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:995)
at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1038)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:931)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:921)
at
org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:268)
at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:220)
at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:422)
at
org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:790)
at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:684)
at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:623)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.apache.hadoop.util.RunJar.main(RunJar.java:212)
FAILED: ParseException line 1:46 cannot recognize input near 'bigdecimal' ')'
'stored' in column type
Please guide me, which version should I use so that I am able to use these
datatypes.
Thanks
Santlal
**************************************Disclaimer******************************************
This e-mail message and any attachments may contain confidential information
and is for the sole use of the intended recipient(s) only. Any views or
opinions presented or implied are solely those of the author and do not
necessarily represent the views of BitWise. If you are not the intended
recipient(s), you are hereby notified that disclosure, printing, copying,
forwarding, distribution, or the taking of any action whatsoever in reliance on
the contents of this electronic information is strictly prohibited. If you have
received this e-mail message in error, please immediately notify the sender and
delete the electronic message and any attachments.BitWise does not accept
liability for any virus introduced by this e-mail or any attachments.
********************************************************************************************
