Skip to main content
abhikoneru
abhikoneru
Gold ⭐️
October 11, 2019
Solved

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

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!

abhikoneru
abhikoneruAnswer
Gold ⭐️
October 14, 2019

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'

View in thread

1 reply

abhikoneru
abhikoneruAuthorAnswer
Gold ⭐️
October 14, 2019

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'

Translate
Terms & ConditionsAccessibility statement