https://community.cloudera.com/t5/Support-Questions/Comments-not-available-for-Hive-struct-type/m-p/354257#M236883 <P>Hello&nbsp;<a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/100928">@sseoju</a>&nbsp;,</P><P>You may get the required information in Impala as shown below:</P><PRE>[node1:21000] default&gt; CREATE EXTERNAL TABLE IF NOT EXISTS test_table<BR />&gt; (<BR />&gt; `id` string comment 'id',<BR />&gt; `name` string comment 'name',<BR />&gt; `area` struct&lt;`country`: string comment "test country", `address`:string comment 'test address'&gt; comment 'test struct'<BR />&gt; );<BR />Query: CREATE EXTERNAL TABLE IF NOT EXISTS test_table<BR />(<BR />`id` string comment 'id',<BR />`name` string comment 'name',<BR />`area` struct&lt;`country`: string comment "test country", `address`:string comment 'test address'&gt; comment 'test struct'<BR />)<BR />+-------------------------+<BR />| summary |<BR />+-------------------------+<BR />| Table has been created. |<BR />+-------------------------+<BR />Fetched 1 row(s) in 0.26s<BR />[node1:21000] default&gt; desc test_table;<BR />Query: describe test_table<BR />+------+------------------------------------------+-------------+<BR />| name | type | comment |<BR />+------+------------------------------------------+-------------+<BR />| id | string | id |<BR />| name | string | name |<BR />| area | struct&lt; | test struct |<BR />| | country:string comment 'test country', | |<BR />| | address:string comment 'test address' | |<BR />| | &gt; | |<BR />+------+------------------------------------------+-------------+<BR />Fetched 3 row(s) in 0.28s</PRE><P>This is also mentioned here&nbsp;<A href="https://impala.apache.org/docs/build/html/topics/impala_describe.html" target="_blank">https://impala.apache.org/docs/build/html/topics/impala_describe.html</A></P><P>Let me know if this helps.</P><P>Cheers!</P> Fri, 07 Oct 2022 12:11:36 GMT tj2007 2022-10-07T12:11:36Z