配置单元csv serde错误

ecbunoof  于 2021-05-29  发布在  Hadoop
关注(0)|答案(0)|浏览(259)

你好。在控制台配置单元中运行以下脚本时:

add /LIBS/Java/csv-serde-1.1.2-0.11.0-all.jar;

CREATE TABLE IF NOT EXISTS database.table (
    date    string, 
    id  string
)
COMMENT 'Ejem'
row format serde 'com.bizo.hive.serde.csv.CSVSerde'
with serdeproperties ("separatorChar" = ";", "escapeChar" = "@")
TBLPROPERTIES ('serialization.null.format' = '');

错误:

MismatchedTokenException(-1!=300)
        at org.antlr.runtime.BaseRecognizer.recoverFromMismatchedToken(BaseRecognizer.java:617)
        at org.antlr.runtime.BaseRecognizer.match(BaseRecognizer.java:115)
        at org.apache.hadoop.hive.ql.parse.HiveParser.keyValueProperty(HiveParser.java:33488)
        at org.apache.hadoop.hive.ql.parse.HiveParser.tablePropertiesList(HiveParser.java:33258)
        at org.apache.hadoop.hive.ql.parse.HiveParser.tableProperties(HiveParser.java:33121)
        at org.apache.hadoop.hive.ql.parse.HiveParser.rowFormatSerde(HiveParser.java:32497)
        at org.apache.hadoop.hive.ql.parse.HiveParser.tableRowFormat(HiveParser.java:32962)
        at org.apache.hadoop.hive.ql.parse.HiveParser.createTableStatement(HiveParser.java:4916)
        at org.apache.hadoop.hive.ql.parse.HiveParser.ddlStatement(HiveParser.java:2350)
        at org.apache.hadoop.hive.ql.parse.HiveParser.execStatement(HiveParser.java:1574)
        at org.apache.hadoop.hive.ql.parse.HiveParser.statement(HiveParser.java:1052)
        at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:199)
        at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:166)
        at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:389)
        at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:303)
        at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1067)
        at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1129)
        at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1004)
        at org.apache.hadoop.hive.ql.Driver.run(Driver.java:994)
        at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:247)
        at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:199)
        at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:410)
        at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:345)
        at org.apache.hadoop.hive.cli.CliDriver.processReader(CliDriver.java:443)
        at org.apache.hadoop.hive.cli.CliDriver.processFile(CliDriver.java:459)
        at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:739)
        at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:677)
        at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:616)
        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.run(RunJar.java:221)
        at org.apache.hadoop.util.RunJar.main(RunJar.java:136)
FAILED: ParseException line 33:41 mismatched input '<EOF>' expecting StringLiteral near '=' in specifying key/value property

此错误不会出现在hue中,只运行:-f hive scritp.hql info:hue 2.6.1-2041 2 hdp 2.2.0 hadoop 2.6.0 pig 0.14.0 hive hcatalog 0.14.0 oozie 4.1.0 ambari 1.7-169 hbase 0.98.4 knox 0.5.0 traductor de google paraempresas:google translator toolkittraductor de sitios网站全球市场搜寻器

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题