Our Community is getting an upgrade! To get everything ready for the relaunch, we’ll be placing the site in read-only mode starting September 21st.
We really appreciate your understanding while we get things set up behind the scenes. Catch up on all the exciting details about the move here.
Need help or have questions? Drop us a line at [email protected]

Support Questions

Find answers, ask questions, and share your expertise
Announcements
Share your experience with Cloudera on G2 and get a $25 Amazon Gift card.
Hi, I'm CLEO! Something exciting is coming to the Community. Stay Tuned!

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.