@anjel Are we saying we are able to see the column comments but table comment missing? Could you please try adding table comment as follows, instead of setting it in table properties? CREATE TABLE name(column1 string comment 'column comment') COMMENT "table comment")   ... View more

@anjel Power BI does not have a native Hive connector. I guess you could only connect using an ODBC connector. I just tried listing a table using DbVisualizer, and and it shows the column comments as REMARKS.  So, I would say it is specific to the Hive client(Power BI) ... View more

@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

@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 @Former Member 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

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