Hi, i need to collect information like "create table" statment: table and schema names, columns and its types, comments and so on.
So, i'm able to collect table schema and table names and its location ("TBLS"), columns ("COLUMNS_V2") and table prooperties ("TABLE_PARAMS").
But i can't get any info about PK and partitions. Tables "PARTITIONS", "PARTITION_KEYS", "IDXS", "INDEX_PARAMS" are empty. So, i don't know where can i find information about. Where's it?
Of course, i create table with partitions and primary keys.
Oh, and i should be get type of table too: parquete, textfile or kudu-table. Havn't this info too.