[ https://issues.apache.org/jira/browse/HIVE-10622?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14533750#comment-14533750 ]
Lefty Leverenz commented on HIVE-10622: --------------------------------------- Good catch! Thanks [~anneyu]. > Hive doc error: 'from' is a keyword, when use it as a column name throw error. > ------------------------------------------------------------------------------ > > Key: HIVE-10622 > URL: https://issues.apache.org/jira/browse/HIVE-10622 > Project: Hive > Issue Type: Bug > Components: Documentation > Affects Versions: 1.1.1 > Reporter: Anne Yu > Fix For: 1.1.1 > > > https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML, Use > "from" as a column name in create table, throw error. > {code} > CREATE TABLE pageviews (userid VARCHAR(64), link STRING, from STRING) > PARTITIONED BY (datestamp STRING) CLUSTERED BY (userid) INTO 256 BUCKETS > STORED AS ORC; > Error: Error while compiling statement: FAILED: ParseException line 1:57 > cannot recognize input near 'from' 'STRING' ')' in column specification > (state=42000,code=40000) > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)