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

[#1]

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!

[#2 · Accepted solution]

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'