Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

Solved Go to solution
Highlighted

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

New Contributor

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!

1 ACCEPTED SOLUTION

Accepted Solutions

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

New Contributor

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'

1 REPLY 1

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

New Contributor

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'

Don't have an account?
Coming from Hortonworks? Activate your account here