sql—在配置单元上创建表

8cdiaqws  于 2021-06-02  发布在  Hadoop
关注(0)|答案(1)|浏览(409)
CREATE TABLE DowJones (quarter int, stock string, StockDate date, open double, high double, low double, close double, volume double, percent_change_price double, percent_change_volume_over_last_wk double, previous_weeks_volume double, next_weeks_open double,  next_weeks_close double, percent_change_next_weeks_price double, days_to_next_dividend int, percent_return_next_dividend double) row format delimited fields terminated by ‘,’;

我得到的错误:

Error while compiling statement: FAILED: ParseException line 1:431 mismatched input ',' expecting StringLiteral near 'by' in table row format's field separator [ERROR_STATUS]

对sql还不熟悉,所以如果这是一个非常明显的修复,请提前道歉。

qvtsj1bj

qvtsj1bj1#

像这样试试。。。

row format delimited fields terminated by '\;'

让我们知道

相关问题