apache/pinot

Support Describe Pinot table and schema

开放

#6,298 创建于 2020年11月27日

 (9 条评论) (0 个反应) (1 位负责人)Java (1,234 个派生)batch import
featurehelp wanted

仓库指标

星标
 (4,937 个星标)
PR 合并指标
 (PR 指标待抓取)

描述

Pinot table conf and schema access is from restful API only right now.

It would be good to support the built-in system tables, and we can query schema in SQL style. This will be useful for users to have a similar onboarding experience that everything can come from the query console. It's also good for Pinot integrations with other systems.

Query examples for references:

SHOW TABLES
DESCRIBE TABLE myTable
SHOW COLUMNS FROM myTable
SELECT 
    TABLE_SCHEMA,
    TABLE_NAME,
    COLUMN_NAME
FROM
    INFORMATION_SCHEMA.COLUMNS
WHERE
    TABLE_SCHEMA <> 'INFORMATION_SCHEMA'

贡献者指南