Connecting to Hive using ODBC and running this command:
I noticed some strange behavior:
ODBC driver version 18.104.22.1682 – works fine, without additional Hive configuration
ODBC driver version 22.214.171.1246 – doesn't work, requires adding the
parameter to whitelist append list:
(80) Syntax or semantic analysis error thrown in server while executing query.
Error message from server: Error while processing statement: Cannot modify enforce.bucketing
at runtime. It is not in list of params that are allowed to be modified at
I added hive.enforce.bucketing to the whitelist and it still didn't work.
Then I noticed that the error is about enforce.bucketing - without the "hive." prefix. So I added the shorter name to whitelist - and now both "enforce.bucketing"
and "hive.enforce.bucketing" can be set via ODBC.
This is just an example, I found other parameters that changed to shorter names as well. In previous HDP versions, the long names were used.
Do you know the exact version in which this change took place and why?
And how come the old ODBC driver is working fine without adding anything to the whitelist?