Support INSERT in Presto Pinot Connector
- Dominant language
- Java
- Stars
- 6.1k
- Forks
- 1.5k
- Avg merge
- 2d 55m
- Merged PRs (30d)
- 182
Description
Today, the only option I know to insert immutable segments into offline tables is by using Hadoop[Map-reduce jobs] via REST APIs
But, I don't want to use Hadoop jobs to insert data..
Since Pinot is also working on integrating with Presto, I would like to insert using Presto commands like:
```SQL
INSERT INTO pinot-table SELECT * FROM hive.default.batch-table
```
Full workflow [Inserting or replacing segments with modified data] will become very easy if there is INSERT support in the pinot-presto connector...
Contributor guide
Research direction
Start by locating the Presto Pinot connector and reviewing how it handles write operations and the shown INSERT INTO ... SELECT workflow. Define completion as accepting that SQL form and inserting or replacing data in Pinot offline tables without Hadoop jobs; the issue names no specific files or tests.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, sql
- Domain
- backend-api-design, databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 25/100