About smruti

smruti · ‎01-02-2023

@saicharan This fails with the authentication error. HTTP Response Code : 401 Verify the authentication details you are passing in the Adapter configuration

smruti · ‎12-18-2022

@anjel could you share the query you are running from Hue or powerbi that you expect to return column/table comments? Does describe <table> not return the column comments in powerBI? What's the JDBC/ODBC driver version you are using and is it shared by Cloudera?

smruti · ‎12-01-2022

@aleezeh I guess you could reach out to Trino support for their inputs. But it looks like we are missing a dependent elasticsearch jar in the classpath.

smruti · ‎11-30-2022

@aleezeh We seem to be missing the jar for the class org.elasticsearch.ElasticsearchStatusException Please make sure that you have elasticsearch-7.6.0.jar is present in the classpath. This jar comes bundled in ranger-${RANGER_VERSION}-admin.tar.gz.

smruti · ‎11-30-2022

@d_liu It seems like it was using a cookie based authentication(hive.server2.thrift.http.cookie.auth.enabled=true set in HS2 config), and it failed due to some error at the server end. Do you have multiple Hive servers configured with Hue, and now it is trying to connect to a different instance? As suggested by @Basim earlier, restart HS2 and Hue service, and retry.

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

smruti · ‎11-15-2022

@hanumanth Review the logs to get a better idea on what it is failing on. If we have that many partitions, do check what's the value of hive.msck.repair.batch.size and if it is set to 0 at present, you may set this to a value such as 3000 and retry.

smruti · ‎11-11-2022

Which version are you on? Is this Cloudera Hive distribution? I think UPDATE command is not working because it is not an acid(transactional) table. For update command to work, it has to be an ACID table. @roti

smruti · ‎11-11-2022

@Shawn Here is a small example on how to find out what's the percentage of NOT NULL value of column maker: select ((tot_cnt - a.null_maker)/tot_cnt)*100 as pcnt_not_null_maker from (select count(maker) as null_maker from used_cars where maker is NULL) a Left outer join (select count(*) as tot_cnt from used_cars) b You may try this for all individual columns.

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?

Online	Offline
Last Visited	‎01-20-2025 11:49 PM

Member Since	‎10-28-2020 05:19 AM
Last Visited	‎01-20-2025 11:49 PM
Posts	567
Kudos received	45

Cloudera Community

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: Not Able to run import command. it fails with ...

Re: Any alternate for org.apache.hive:hive-jdbc ma...

Re: Getting error when trying to connect to Apache...

Re: HIVE table/column description does not display...

Re: Unable to get audit logs from Apache Ranger Tr...

Re: Unable to get audit logs from Apache Ranger Tr...

Re: Hive2 working with Beeline JDBC but not throug...

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

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

Re: sub days from temp column date value

Re: drop the columns with more than 50% missing va...

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