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)

Reply via email to