PARSER error while trying to create a simple table.

AMY — Thu, 23 Jul 2020 19:28:43 GMT

I tried creating a simple table , i am not sure what the error is.Can some one please help me.

CREATE TABLE stocks_eod (
> stockticker STRING,
> tradedate INT,
> openprice FLOAT,
> highprice FLOAT,
> lowprice FLOAT,
> volume BIGINT
> ) ROW FORMAT DELIMTED FIELDS TERMINATED BY ',';

NoViableAltException(232@[])
at org.apache.hadoop.hive.ql.parse.HiveParser.tableRowFormat(HiveParser.java:36025)
at org.apache.hadoop.hive.ql.parse.HiveParser.createTableStatement(HiveParser.java:6865)
at org.apache.hadoop.hive.ql.parse.HiveParser.ddlStatement(HiveParser.java:4122)
at org.apache.hadoop.hive.ql.parse.HiveParser.execStatement(HiveParser.java:1786)
at org.apache.hadoop.hive.ql.parse.HiveParser.statement(HiveParser.java:1152)
at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:211)
at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:171)
at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:447)
at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:330)
at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1233)
at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1274)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1170)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1160)
at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:217)
at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:169)
at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:380)
at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:740)
at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:685)
at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:625)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.hadoop.util.RunJar.run(RunJar.java:233)
at org.apache.hadoop.util.RunJar.main(RunJar.java:148)
FAILED: ParseException line 8:2 cannot recognize input near 'ROW' 'FORMAT' 'DELIMTED' in table row format specification

Re: PARSER error while trying to create a simple table.

aakulov — Sat, 25 Jul 2020 05:29:02 GMT

In your query you have a typo in "DELIMITED". Please double check and try again.

Re: PARSER error while trying to create a simple table.

AMY — Sun, 26 Jul 2020 03:31:10 GMT

I just could not see it!!:-( Thank you so much. 😊

question PARSER error while trying to create a simple table. in Support Questions

PARSER error while trying to create a simple table.

Re: PARSER error while trying to create a simple table.

Re: PARSER error while trying to create a simple table.