About smruti

smruti · ‎11-21-2022

@lysConsulting Have you ticked Kudu checkbox under Hive configuration in Cloudera Manager UI? Refer to: https://docs.cloudera.com/documentation/enterprise/6/6.3/topics/kudu_hms.html#concept_enable_hms https://cwiki.apache.org/confluence/display/Hive/Kudu+Integration In CDP : https://docs.cloudera.com/cdp-private-cloud-base/7.1.7/kudu-hms-integration/topics/kudu-hms-enabling.html

VidyaSargur · ‎11-20-2022

@hanumanth, Have the replies helped resolve your issue? If so, can you please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future?

smruti · ‎10-18-2022

@SwaggyPPPP Is this a partitioned table? In that case you could run the ALTER TABLE command as follows: alter table my_table add columns(field4 string,field5 string) CASCADE; Let us know if this issue occurs consistently, after adding new columns, and your Cloudera product version?

smruti · ‎10-18-2022

@KPG1 We only support upgrading an existing cluster using Ambari or Cloudera Manager, instead of importing/updating the jars manually. In latest CDP Private cloud base, and our Public Cloud, we are using Hadoop version 3.1.1 at this point.

udeshmukh · ‎09-27-2022

May i know if the table was created from the data that was exported in some other format like 'txt' format or something ? if this is true then, starting from CDP 7.x versions, the default file format is parquet. So, when the table is imported, it will be created in parquet format, but its original files will in 'txt' format.

HanzalaShaikh · ‎09-08-2022

Thanks for your quick reply @smruti , really appreciated. I have gone through this approach and will surely consider it for DR strategy.

smruti · ‎08-31-2022

@mohammad_shamim Did you have Hive HA configured in CDH cluster, in that case, you need to make sure that there are equal number of HS2 instances created in the CDP cluster, because without that HA cannot be attained. Also, make sure that there is no Hiveserver2 instance created under "Hive" service in CDP. It should only be present under Hive on Tez service.

VidyaSargur · ‎08-24-2022

@ssuja, Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.

xinghx · ‎08-08-2022

I didn't notice that the property "external" is case sensitive,the step 2 should be ALTER TABLE alter_test SET TBLPROPERTIES('EXTERNAL'='false'); ,then the location would be changed in CDP7.1.1. And In CDP 7.1.7, It does not work even if I set property "TRANSLATED_TO_EXTERNAL" to true after creating table ,could you try the steps and give an attachment? thanks.

newbieone · ‎07-15-2022

Could help to explain what's the meaning of first 2 sentence? Set Hive..... What would happen if we don't have 2 sentences? How would that impact our query? Thanks.

Online	Offline
Last Visited	‎04-23-2026 11:37 PM

Member Since	‎10-28-2020 05:19 AM
Last Visited	‎04-23-2026 11:37 PM
Posts	624
Kudos received	46

Cloudera Community

Re: Assistance Required for Deploying Iceberg SerD...

Re: I have a HIVE table which contains JSON as a c...

Re: ANALYZE command not write data into hive metas...

Re: HBase stores base64 data when data is inserted...

Re: Deleting hive service on CDP Private Base and ...

Re: Error determining if Kudu's integration with t...

Re: Hive external table MSCK and DROP not working....

Re: Hive table becomes all NULLs after add new col...

Re: Hadoop Migration from Hortonworks HDP3 to Apac...

Re: has an Invalid parquet version number:017

Re: Backup and Disaster recovery alternative optio...

Re: CDP upgrade from CDH

Re: How to give access to users to create and own ...

Re: hive 执行rename后，表的location没有相应发生改变

Re: Hive partitioning