HIVE SQL create statement

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’
;

It is saying error near BY

Your have curly single quotes in your question. These would not be handled as single quotes by Hive. — Gordon Linoff
– Gordon Linoff, Commented Nov 9, 2015 at 12:19

hadooper · Accepted Answer · 2015-11-10 15:51:52Z

1

Below query worked for me..

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'
;

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

edited Nov 10, 2015 at 15:51

answered Nov 10, 2015 at 15:44

hadooper

7461 gold badge6 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vineet Srivastava · Accepted Answer · 2015-11-09 14:07:16Z

0

Change single quotes with double as below:

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" ;

answered Nov 9, 2015 at 14:07

Vineet Srivastava

235 bronze badges

Collectives™ on Stack Overflow

HIVE SQL create statement

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related