Created on 10-11-2019 11:21 AM - last edited on 10-11-2019 09:31 PM by ask_bill_brooks
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!
Created 10-14-2019 07:20 AM
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'
Created 10-14-2019 07:20 AM
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'