apache / apache/pinot

Support Describe Pinot table and schema

Open
#6,298 9 comments 0 reactions 1 assignee Claimed by @amarnathkarthik View on GitHub
feature help wanted
Dominant language
Java
Stars
6.1k
Forks
1.5k
Avg merge
1d 21h
Merged PRs (30d)
189

Description

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'
```

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.