运行配置单元时出现错误消息

hc8w905p  于 2021-06-28  发布在  Hive
关注(0)|答案(1)|浏览(357)
CREATE TABLE CCTGDB_TMP.ODS_WORLDWIDE_AR_REVENUE_R12_C3_TEMP_1 (
  ENTERED_CR DOUBLE,
  ACCOUNTED_CR DOUBLE,
  ENTERED_DR DOUBLE,
  ACCOUNTED_DR DOUBLE,
  INVOICE_CURRENCY_CODE STRING,
  CURRENCY_CODE STRING,
  CODE_COMBINATION_ID   DOUBLE,
  JE_SOURCE STRING,
  USER_JE_SOURCE_NAME STRING,
  SEGMENT1 STRING,
  SEGMENT2 STRING,
  SEGMENT3 STRING,
  SEGMENT4 STRING,
  SEGMENT5 STRING,
  SEGMENT6 STRING,
  PERIOD_NAME STRING,
  LEDGER_ID DOUBLE,
  NAME STRING,
  PERIOD_YEAR DOUBLE,
  PERIOD_NUM DOUBLE,
  END_DATE STRING,
  USER_JE_CATEGORY_NAME STRING,
  REVENUE_USD   DOUBLE
)
COMMENT 'Adjustment  Revenue'
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\n'
STORED AS PARQUET;

我得到的错误如下:

FAILED: ParseException line 8:25 cannot recognize input near ',' 'JE_SOURCE' 'STRING' in column type
cgvd09ve

cgvd09ve1#

是的,很好用。因为一些额外的字符

相关问题