[jira] [Created] (HIVE-7124) Query Parser sensitive to placement of options when creating a table

["Rémy SAISSY (JIRA)" <ji...@apache.org>]

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)