apache / apache/pinot

Support INSERT in Presto Pinot Connector

Open
#4,809 0 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.