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 wrote:
> Edward,
>
> I hear t
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
Alan,
Thanks much for the info! I have written HIVE-19741 [1] to address the
doc updates.
Regards,
Matt
[1] https://issues.apache.org/jira/browse/HIVE-19741
On Wed, May 30, 2018 at 1:38 PM, Alan Gates wrote:
> It is. You can see the definitive list of keywords at
> https://github.com/apache/
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 wrote:
> It is. You can see the definitive list of keywords at
> https://github.com/apache/hive/blob/master/ql/src/java/
> org/apac
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 JIR
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=
