Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

HIVE table/column description does not display in Power BI

avatar
Explorer

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.

1 ACCEPTED SOLUTION

avatar
Explorer

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.

View solution in original post

10 REPLIES 10

avatar
Explorer

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.