phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas D'Silva" <twdsi...@gmail.com>
Subject Re: Bulk Load data into Phoenix Table with Dynamic columns
Date Mon, 18 Nov 2019 04:40:00 GMT
Bulk loading with dynamic columns is not supported. You could try modeling
the data using multiple views on the same physical table.

On Tue, Nov 12, 2019 at 3:26 PM Mohammed Shoaib Quraishi <
shoaib.quraishi@outlook.com> wrote:

> Hi,
>
> I have a phoenix table created with a fixed set of columns. I have
> inserted and projected  dynamic column data using UPSERT and SELECT
> statements. I would like to bulk insert dynamic column data into this
> table. I do not see any documentation on how/whether this can be done.
> Scripting dynamic SQL with multiple UPSERT statements loads data very slow.
> It takes forever to load 500,000 records using multiple UPSERT statements.
> Also, one UPSERT statement with multiple VALUES doesn't work.
>
> Can you help me with the best method to bulk insert huge data into a
> Phoenix table with dynamic columns.
>
> Thank you,
>
> Shoaib
>

Mime
View raw message