apachehive=# \d "TABLE_PARAMS" Table "public.TABLE_PARAMS" Column | Type | Modifiers -------------+------------------------+----------- TBL_ID | bigint | not null PARAM_KEY | character varying(256) | not null PARAM_VALUE | text | Indexes: "TABLE_PARAMS_pkey" PRIMARY KEY, btree ("TBL_ID", "PARAM_KEY") "TABLE_PARAMS_N49" btree ("TBL_ID") Foreign-key constraints: "TABLE_PARAMS_TBL_ID_fkey" FOREIGN KEY ("TBL_ID") REFERENCES "TBLS"("TBL_ID") DEFERRABLE apachehive=# \d "SERDE_PARAMS" Table "public.SERDE_PARAMS" Column | Type | Modifiers -------------+------------------------+----------- SERDE_ID | bigint | not null PARAM_KEY | character varying(256) | not null PARAM_VALUE | text | Indexes: "SERDE_PARAMS_pkey" PRIMARY KEY, btree ("SERDE_ID", "PARAM_KEY") "SERDE_PARAMS_N49" btree ("SERDE_ID") Foreign-key constraints: "SERDE_PARAMS_SERDE_ID_fkey" FOREIGN KEY ("SERDE_ID") REFERENCES "SERDES"("SERDE_ID") DEFERRABLE apachehive=# \d "SD_PARAMS" Table "public.SD_PARAMS" Column | Type | Modifiers -------------+------------------------+----------- SD_ID | bigint | not null PARAM_KEY | character varying(256) | not null PARAM_VALUE | text | Indexes: "SD_PARAMS_pkey" PRIMARY KEY, btree ("SD_ID", "PARAM_KEY") "SD_PARAMS_N49" btree ("SD_ID") Foreign-key constraints: "SD_PARAMS_SD_ID_fkey" FOREIGN KEY ("SD_ID") REFERENCES "SDS"("SD_ID") DEFERRABLE apachehive=# select * from "TBLS"; TBL_ID | CREATE_TIME | DB_ID | LAST_ACCESS_TIME | OWNER | RETENTION | SD_ID | TBL_NAME | TBL_TYPE | VIEW_EXPANDED_TEXT | VIEW_ORIGINAL_TEXT | IS_REWRITE_ENABLED --------+-------------+-------+------------------+---------+-----------+-------+------------------+----------------+--------------------+--------------------+-------------------- 1 | 1495055598 | 1 | 0 | ngangam | 0 | 1 | srcpart | MANAGED_TABLE | | | f 2 | 1495055786 | 1 | 0 | ngangam | 0 | 3 | largeserdeparams | EXTERNAL_TABLE | | | f 3 | 1495055859 | 1 | 0 | ngangam | 0 | 4 | largetblparams | EXTERNAL_TABLE | | | f (3 rows) apachehive=# select * from "TABLE_PARAMS" where "TBL_ID"=2; TBL_ID | PARAM_KEY | PARAM_VALUE --------+-----------------------+------------- 2 | EXTERNAL | 24881 2 | transient_lastDdlTime | 24880 (2 rows) apachehive=# select * from "TABLE_PARAMS" where "TBL_ID"=3; TBL_ID | PARAM_KEY | PARAM_VALUE --------+-----------------------+------------- 3 | transient_lastDdlTime | 24887 3 | EXTERNAL | 24886 3 | comment | 24885 (3 rows)