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.qurai...@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 >
