Hi everyone I need a sql queries(statements) for g...
# generalj
Jithendar
09/21/2023, 10:51 AMHi everyone I need a sql queries(statements) for getting list of tables, table schema and partition details. Please help me with this
g
guru
09/21/2023, 4:56 PM@Jithendar Do you really need a query ? Are powerful controller APIs to get these details. For eg:
curl http//<PINOT CONTROLLER HOST><PORT>/tables
Will get you what you want, have you see the swagger spec ?
j
Jithendar
09/22/2023, 6:37 AM@guru Thanks for the reply, like in general relational databases, we do have partitions information/information schema queries right
for eg:SELECT
table_name,
subpartition_name,
partition_ordinal_position,
subpartition_ordinal_position,
partition_method,
subpartition_method,
partition_expression,
subpartition_expression,
table_rows
FROM
information_schema.PARTITIONS
WHERE
table_schema = 'your_database_name'
AND table_name = 'your_table_name';
g
guru
09/22/2023, 10:33 PMYes, absolutely you get all these results via the APIs, actually even more.
What is your use case ? What do you want to do with this data ?