Make sure to backtick all table and column names and you won’t get a problem when updating. We also try to include keywords in our automated integration tests to try to find places where we’ve missed the backticks.
/Pelle On Wed, 30 May 2018 at 20:07, Matt Burgess <mattyb...@apache.org> wrote: > 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 <edlinuxg...@gmail.com> > 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 <alanfga...@gmail.com> > 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 <mattyb...@apache.org> > 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 > > > > > -- *Per Ullberg* Datavault Tech Lead Odin (Uppsala) Klarna Bank AB (publ) Sveavägen 46, 111 34 Stockholm Tel: +46 8 120 120 00 <javascript:void(0);> Reg no: 556737-0431 klarna.com
