How can I perform an UPSERT on a CSV file using Apache Calcite?

Question

I tried executing the query below

"INSERT INTO " + schema + "." + fileName+"  '(' id,name ')' VALUES (3,'abc')")

I am not sure whether Calcite supports UPSERT or not.

But I referred to the reference which shows different queries.

If it's not possible using Apache Calcite, then please let me know what other libraries I can use to perform UPSERT into a CSV file.

score 0 · Answer 1 · answered Apr 02 '20 at 18:32

0

Calcite doesn't currently support executing UPSERT statements. There has been recent discussion of this on the project mailing list so it's possible this will be supported in the future.

answered Apr 02 '20 at 18:32

Michael Mior

28,107
9
89
113

But in this doc https://calcite.apache.org/docs/reference.html they have given all the queries. – kavyansh Apr 03 '20 at 05:29
@kavyansh That documentation is for the parser. The parser can parse `UPSERT` statements. But they can't be executed. – Michael Mior Apr 04 '20 at 16:27

How can I perform an UPSERT on a CSV file using Apache Calcite?

1 Answers1