Semantic exception on executing - show partitions `database_name.tablename`; in hive cli

abhikoneru — Sat, 12 Oct 2019 04:31:29 GMT

We recently upgraded from hdp 2.6.4 to 2.6.5. After the upgrade i am not able to execute this command -

show partitions `<database_name>.<table_name>`

The command works fine with 2.6.4 version.

Any help would be appreciated. Thanks!

Re: Semantic exception on executing - show partitions `database_name.tablename`; in hive cli

abhikoneru — Mon, 14 Oct 2019 14:20:35 GMT

Just an update from my side so that someone else would benefit, if they came across this issue.

Here is the resolution we received from the Cloudera/Hortonworks support team.

Resolution:

We have created followup jira's to support tablenames with (.)dot in HIVE-21198 & HIVE-21151. This 2 jira's are still in progress, but still consider that even if jiras are fixed, `db.table` will be considered as tablename with special characters.

Workaround:

Please consider to update the scripts to split & quote dbname & tablename like `dbname`.`tablename'

question Re: Semantic exception on executing - show partitions `database_name.tablename`; in hive cli in Support Questions

Semantic exception on executing - show partitions `database_name.tablename`; in hive cli

Re: Semantic exception on executing - show partitions `database_name.tablename`; in hive cli