Member since
10-28-2020
533
Posts
38
Kudos Received
38
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
236 | 05-28-2024 11:06 AM | |
515 | 05-05-2024 01:27 PM | |
306 | 05-05-2024 01:09 PM | |
347 | 03-28-2024 09:51 AM | |
440 | 03-20-2024 03:54 AM |
01-03-2023
04:39 AM
@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
01-02-2023
12:35 AM
1 Kudo
@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
01-02-2023
12:01 AM
1 Kudo
@saicharan This fails with the authentication error. HTTP Response Code : 401 Verify the authentication details you are passing in the Adapter configuration
... View more
12-18-2022
11:22 PM
@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
12-01-2022
01:01 AM
@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
11-30-2022
03:49 AM
@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
11-30-2022
03:37 AM
@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
11-21-2022
12:41 PM
@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
11-15-2022
04:34 AM
@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
11-11-2022
03:10 AM
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