[CALCITE-492] Support UPSERT statement in parser

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.0.0-incubating
• Labels: phoenix
• Assignee: Julian Hyde
• Reporter: James R. Taylor
• Created: 30/Nov/14 20:04
• Updated: 08/Feb/15 08:56
• Resolved: 05/Jan/15 09:11

Description

Support an UPSERT VALUES and UPSERT SELECT statement in Calcite. These have the same syntax as INSERT VALUES and INSERT SELECT, but they insert the row if it doesn't already exist and update it otherwise. This is a pretty common pattern for big data applications that want to have an option to write without reading first. See http://phoenix.apache.org/language/index.html#upsert_values and http://phoenix.apache.org/language/index.html#upsert_select for syntax.