COPY FROM '/path/to/local/file.csv' INTO tablename (columnName, columnName, ...) FORMAT CSV
I have tried simple python program without using spark. First I read whole csv into python dataframe using pandas library.
Now I want to bulk insert the whole dataframe into ignite table without looping through.
The purpose of this test is to evaluate the best way(means faster wat) to bulk load csv files into ignite.
Ignite COPY command I can not use here, because I need an option to do column mapping while import csv files.
What have you tried? As long as your command-line includes the right JAR files it seems to more-or-less just work for me:
On 22 Oct 2019, at 11:41, Muhammed Favas <email@example.com> wrote:
Is there a way to bulk load python dataframe values to ignite table?