apache/pinot

Support for SHOW TABLES and DESCRIBE <tbl_name> Commands

Open

#9,200 opened on Aug 11, 2022

View on GitHub
 (9 comments) (2 reactions) (1 assignee)Java (1,234 forks)batch import
good first issue

Repository metrics

Stars
 (4,937 stars)
PR merge metrics
 (Avg merge 6d 7h) (186 merged PRs in 30d)

Description

As a user, I would like to be able to issue an equivalent of MySQL's SHOW TABLES and DESCRIBE <tbl_name> commands, to get a list of tables in my cluster and to get metadata about a particular table (such as its columns and their types) respectively.

Contributor guide

Research direction
Examine the existing SQL parser and metadata services in Pinot. Understand how tables are stored and queried. Look at similar commands like SHOW DATABASES for patterns. Then implement SHOW TABLES by iterating over tables and DESCRIBE by accessing table schema.
Tech stack
java
Domain
backenddatabaseapi
Issue type
Feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-2 days
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
JavaSQLApache Pinot basics
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
40