Edward, I hear that, "application" is a bit unfortunate as a reserved word as well, I wonder how many folks have data sets with a column named "application". We have that field in provenance data in NiFi, I discovered it was a reserved word when trying to create a flow to put NiFi provenance data into Hive for analysis.
Regards, Matt On Wed, May 30, 2018 at 2:04 PM, Edward Capriolo <[email protected]> wrote: > We got bit pretty hard when "exchange partitions" was added. How many people > in ad-tech work with exchange's? everyone! > > On Wed, May 30, 2018 at 1:38 PM, Alan Gates <[email protected]> wrote: >> >> It is. You can see the definitive list of keywords at >> https://github.com/apache/hive/blob/master/ql/src/java/org/apache/hadoop/hive/ql/parse/HiveLexer.g >> (Note this is for the master branch, you can switch the branch around to >> find the list for a particular release.) It would be good to file a JIRA on >> this so we fix the documentation. >> >> Alan. >> >> On Wed, May 30, 2018 at 7:48 AM Matt Burgess <[email protected]> wrote: >>> >>> I tried the following simple statement in beeline (Hive 3.0.0): >>> >>> create table app (application STRING); >>> >>> And got the following error: >>> >>> Error: Error while compiling statement: FAILED: ParseException line >>> 1:18 cannot recognize input near 'application' 'STRING' ')' in column >>> name or constraint (state=42000,code=40000) >>> >>> I checked the Wiki [1] but didn't see 'application' on the list of >>> reserved words. However if I change the column name to anything else >>> (even 'applicatio') it works. Can someone confirm whether this is a >>> reserved word? >>> >>> Thanks in advance, >>> Matt >>> >>> [1] >>> https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-Keywords,Non-reservedKeywordsandReservedKeywords > >
