hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Santlal J Gupta <Santlal.Gu...@bitwiseglobal.com>
Subject Issue while working with parquet hive
Date Tue, 04 Aug 2015 05:26:47 GMT
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. ********************************************************************************************

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message