Created 12-15-2022 02:38 AM
Hi Community,
I'd like to know if it's possible to display a table or column description from Power BI that is connected to Hive using ODBC driver?
Issue is following: I set a comment in a Hive table and on its columns and I would expect that these are loaded and visible as "Description" fields from external tools (like Power BI).
For example:
create table mytable1(mycol1 string comment 'column description') stored as ORC TBLPROPERTIES('comment' = 'table description');
I would expect that when Power BI accesses this table, it would retrieve these comments as descriptions of the table/column, but the "Description" fields are all 'null'.
Note that these table/column descriptions are visible from HUE.
Thanks in advance for your anwsers.
Created 03-11-2023 12:25 AM
Hi and sorry for the late update,
A correction has officially been delivered within version 2.6.15 of the Cloudera ODBC Hive Driver; excerpt from the Release Notes :
[00416069] [HAR-1323] The REMARKS column of the tables metadata does not
populate with comments.
Created 03-11-2023 12:25 AM
Hi and sorry for the late update,
A correction has officially been delivered within version 2.6.15 of the Cloudera ODBC Hive Driver; excerpt from the Release Notes :
[00416069] [HAR-1323] The REMARKS column of the tables metadata does not
populate with comments.