Can I write sleep dialogs for Apache Phoenix?

Question

I would like to write sleep mode dialogs for Apache Phoenix. The huge problem is that the keyword of the insert statement is “Upsert” instead of “Insert”. This keyword is declared in org.hibernate.sql.Insert. Is it possible to write a dialect for Apache Phoenix?

Source http://phoenix.apache.org/language/index.html#upsert_values

Yours faithfully

Answer 1

I found a theoretical solution. The easiest way is to override jdbc created by apache phoenix. You must override the functions exceuteQuery () and updateQuery (). You need to replace "insert" and "update" with "upsert". What do you think? I have not tested it yet.