sql - HIVE SQL 创建语句

Question

CREATE TABLE IF NOT EXISTS user.name_visits(
    date1 TIMESTAMP,
    MV String,
    visits_by_MV int
)
COMMENT ‘visits_at_MV’
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ‘\t’
LINES TERMINATED BY ‘\n’
;

BY附近报错

Answer 1

下面的查询对我有用..

如果不存在则创建表 user.name_visits(
日期1时间戳，
MV 字符串，
visits_by_MV INT
)
评论'visits_at_MV'
行格式分隔
由'\t'终止的字段
由'\n'终止的行
;

Error you are seeing could be because of the editor you are using.
If you look at your Quotation marks.. they're LEFT SINGLE QUOTATION MARK and RIGHT SINGLE QUOTATION MARK.
Only change I made was using an APOSTROPHE.

Try this way it should work