@jass @OmerSl Try disabling hive.server2.tez.initialize.default.sessions. Go to CM UI > Hive on Tez > Configuration > HiveServer2 Advanced Configuration Snippet (Safety Valve) for hive-site.xml  Add: Name: hive.server2.tez.initialize.default.sessions Value: false   Save and restart the service. This should help resolve the issue.   More information on this property can be found here : https://docs.cloudera.com/cdp-private-cloud-base/7.1.7/configuring-apache-hive/topics/hive-on-tez-configurations.html ... View more

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

@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? ... View more

@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. ... View more

@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.  ... View more

@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. ... View more

@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 ... View more

@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. ... View more

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  ... View more

@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. ... View more