我正在运行基于impala的centos预配置来运行hadoop架构。我使用色调自动生成表格形式.csv文件。我上传了文件 /usr/hive/warehouse . 我确保在上传之前从文件中删除列标题。
但是它给了我以下的例外 Exception communicating with Beeswax (Hive UI) Server at localhost:21000: BeeswaxException(errorCode=0, log_context='', message="com.cloudera.impala.common.AnalysisException: Syntax error at:\n\nCREATE TABLE2012_Q4\n^\n(\ncol_0string ,\ncol_1string ,\ncol_2string ,\ncol_3string ,\ncol_4string ,\ncol_5string ,\ncol_6string ,\ncol_7string ,\ncol_8string ,\ncol_9string ,\ncol_10string ,\ncol_11string ,\ncol_12string ,\ncol_13string ,\ncol_14string ,\ncol_15string ,\ncol_16string ,\ncol_17string ,\ncol_18string ,\ncol_19string ,\ncol_20string ,\ncol_21string ,\ncol_22string ,\ncol_23string ,\ncol_24string ,\ncol_25string ,\ncol_26string ,\ncol_27string ,\ncol_28string ,\ncol_29string ,\ncol_30string ,\ncol_31string ,\ncol_32string ,\ncol_33string ,\ncol_34string ,\ncol_35string ) \nROW FORMAT DELIMITED\n FIELDS TERMINATED BY ','\nEncountered: IDENTIFIER\nExpected: DESCRIBE, SELECT, SHOW, USE, INSERT\n\n\tat com.cloudera.impala.analysis.AnalysisContext.analyze(AnalysisContext.java:135)\n\tat com.cloudera.impala.service.Frontend.createExecRequest(Frontend.java:221)\n\tat com.cloudera.impala.service.JniFrontend.createExecRequest(JniFrontend.java:89)\nCaused by: java.lang.Exception: Syntax error\n\tat com.cloudera.impala.analysis.SqlParser.unrecovered_syntax_error(SqlParser.java:1369)\n\tat java_cup.runtime.lr_parser.parse(lr_parser.java:616)\n\tat com.cloudera.impala.analysis.AnalysisContext.analyze(AnalysisContext.java:125)\n\t... 2 more\n", SQLState='42000', handle=QueryHandle(log_context='', id=''))