Rémy SAISSY created HIVE-7124:
---------------------------------
Summary: Query Parser sensitive to placement of options when
creating a table
Key: HIVE-7124
URL: https://issues.apache.org/jira/browse/HIVE-7124
Project: Hive
Issue Type: Bug
Components: Query Processor
Affects Versions: 0.13.0
Reporter: Rémy SAISSY
Priority: Minor
Hi,
the order matters when creating a table with both
ROW FORMAT DELIMITED FIELDS TERMINATED BY
and
LOCATION
More precisely, I get the following (Hive 0.13):
hive> create external table gz (month string, day string, hour string, hostname
string, process string, msg string) LOCATION '/user/remy/gz/' ROW FORMAT
DELIMITED FIELDS TERMINATED BY ' ';
FAILED: ParseException line 1:136 missing EOF at 'ROW' near ''/user/remy/gz/''
hive> create external table gz (month string, day string, hour string, hostname
string, process string, msg string) ROW FORMAT DELIMITED FIELDS TERMINATED BY '
' LOCATION '/user/remy/gz';
OK
--
This message was sent by Atlassian JIRA
(v6.2#6252)