Member since
10-05-2022
1
Post
0
Kudos Received
0
Solutions
10-07-2022
05:11 AM
Hello @sseoju , You may get the required information in Impala as shown below: [node1:21000] default> CREATE EXTERNAL TABLE IF NOT EXISTS test_table > ( > `id` string comment 'id', > `name` string comment 'name', > `area` struct<`country`: string comment "test country", `address`:string comment 'test address'> comment 'test struct' > ); Query: CREATE EXTERNAL TABLE IF NOT EXISTS test_table ( `id` string comment 'id', `name` string comment 'name', `area` struct<`country`: string comment "test country", `address`:string comment 'test address'> comment 'test struct' ) +-------------------------+ | summary | +-------------------------+ | Table has been created. | +-------------------------+ Fetched 1 row(s) in 0.26s [node1:21000] default> desc test_table; Query: describe test_table +------+------------------------------------------+-------------+ | name | type | comment | +------+------------------------------------------+-------------+ | id | string | id | | name | string | name | | area | struct< | test struct | | | country:string comment 'test country', | | | | address:string comment 'test address' | | | | > | | +------+------------------------------------------+-------------+ Fetched 3 row(s) in 0.28s This is also mentioned here https://impala.apache.org/docs/build/html/topics/impala_describe.html Let me know if this helps. Cheers!
... View more