sql - 在 Hive 上创建表

Question

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 的新手，如果这是一个非常明显的修复，请提前致歉。

Answer 1

像这样尝试...

row format delimited fields terminated by '\;'

让我们知道