apache / apache/arrow-adbc

c/driver/postgresql: Support bulk ingest to temporary tables

Open
#3,838 0 comments 0 reactions 0 assignees View on GitHub
Type: enhancement
Dominant language
C#
Stars
627
Forks
217
Avg merge
17h
Merged PRs (30d)
57

Description

### What feature or improvement would you like to see?

`FAILED tests/test_ingest.py::TestIngest::test_temporary[postgresql:15+] - NotImplementedError`

This test is being skipped now since the PostgreSQL driver currently throws NotImplementedError when attempting to ingest data into temporary tables. The driver should support creating and populating temporary tables so that the statement_bulk_ingest_temporary flag can be enabled and pass the test.

Contributor guide

Open the contributing guide

Research direction

Start with tests/test_ingest.py and the skipped TestIngest::test_temporary[postgresql:15+] case. Trace the PostgreSQL driver's current temporary-table ingest path and the statement_bulk_ingest_temporary flag. Done means the driver creates and populates temporary tables without NotImplementedError and the test passes.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql
Domain
databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.