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)