Databases
StackOverflow2013
Postsdbo
POHue beeswax create table error
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHue beeswax create table error
    text
    copied!<p>I am running Impala based Cent OS pre-configure to run Hadoop architecture. I am using Hue to auto generate table form .csv file. I uploaded file in <code>/usr/hive/warehouse</code>. I make sure that I remove column headers from the file before uploading.</p> <p>However it gives me following exception <code> 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 TABLE `2012_Q4`\n^\n(\n `col_0` string ,\n `col_1` string ,\n `col_2` string ,\n `col_3` string ,\n `col_4` string ,\n `col_5` string ,\n `col_6` string ,\n `col_7` string ,\n `col_8` string ,\n `col_9` string ,\n `col_10` string ,\n `col_11` string ,\n `col_12` string ,\n `col_13` string ,\n `col_14` string ,\n `col_15` string ,\n `col_16` string ,\n `col_17` string ,\n `col_18` string ,\n `col_19` string ,\n `col_20` string ,\n `col_21` string ,\n `col_22` string ,\n `col_23` string ,\n `col_24` string ,\n `col_25` string ,\n `col_26` string ,\n `col_27` string ,\n `col_28` string ,\n `col_29` string ,\n `col_30` string ,\n `col_31` string ,\n `col_32` string ,\n `col_33` string ,\n `col_34` string ,\n `col_35` string ) \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='')) </code></p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload