[ https://issues.apache.org/jira/browse/HIVE-2189?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jakob Homan updated HIVE-2189: ------------------------------ Description: While it's possible to add comments to struct elements, it doesn't seem to be possible to then retrieve those comments. For instance: {noformat}hive> create table test_table(a STRUCT<z:string COMMENT 'comment for z',x:int> COMMENT 'comment for a'); OK Time taken: 2.565 seconds hive> describe test_table; OK a struct<z:string,x:int> comment for a Time taken: 0.139 seconds hive> describe test_table.a; OK z string from deserializer x int from deserializer Time taken: 0.096 seconds hive> describe test_table.a.z; OK z string from deserializer Time taken: 0.089 seconds hive>{noformat} In this example, even though a comment has been set to field a.z, it doesn't show up in the table or struct's description. This is due to the way MetastoreUtils treats non-struct elements while generating the table description. This was identified in HIVE-2171. was: While it's possible to add comments to struct elements, it doesn't seem to be possible to then retrieve those comments. For instance: {noformat}hive> create table test_table(a STRUCT<z:string COMMENT 'comment for z',x:int> COMMENT 'comment for a'); OK Time taken: 2.565 seconds hive> describe test_table; OK a struct<z:string,x:int> comment for a Time taken: 0.139 seconds hive> describe test_table.a; OK z string from deserializer x int from deserializer Time taken: 0.096 seconds hive> describe test_table.a.z; OK z string from deserializer Time taken: 0.089 seconds hive>{noformat} In this example, even though a comment has been set to field a.z, it doesn't show up in the table or struct's description. This is due to the way MetastoreUtils treats non-struct elements while generating the table description. This was identified in HIVE-2154. > Hive ignores comments for nested structs > ---------------------------------------- > > Key: HIVE-2189 > URL: https://issues.apache.org/jira/browse/HIVE-2189 > Project: Hive > Issue Type: Bug > Affects Versions: 0.7.0 > Reporter: Jakob Homan > Priority: Minor > > While it's possible to add comments to struct elements, it doesn't seem to be > possible to then retrieve those comments. For instance: > {noformat}hive> create table test_table(a STRUCT<z:string COMMENT 'comment > for z',x:int> COMMENT 'comment for a'); > OK > Time taken: 2.565 seconds > hive> describe test_table; > OK > a struct<z:string,x:int> comment for a > Time taken: 0.139 seconds > hive> describe test_table.a; > OK > z string from deserializer > x int from deserializer > Time taken: 0.096 seconds > hive> describe test_table.a.z; > OK > z string from deserializer > Time taken: 0.089 seconds > hive>{noformat} > In this example, even though a comment has been set to field a.z, it doesn't > show up in the table or struct's description. This is due to the way > MetastoreUtils treats non-struct elements while generating the table > description. This was identified in HIVE-2171. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira