how can i use UPSERT VALUES?

[mmaxiaolei]

i user the sentence;
"UPSERT VALUES INTO my_table(id, col1, col2) VALUES( NEXT VALUE FOR my_schema.my_sequence, 'foo', 'bar');"
from "http://phoenix.apache.org/sequences.html".
but ,it do not work,bugs:Error: ERROR 603 (42P00): Syntax error. Unexpected input. Expecting "INTO", got "VALUES" at line 1, column 8. (state=42P00,code=603)
can you tell me why?

[jtaylor-sfdc]

Phoenix moved to Apache a year ago. Please subscribe to our email address
there instead, as this one is no longer active:
http://phoenix.apache.org/mailing_list.html

On Dec 25, 2014, at 10:37 PM, mmaxiaolei [email protected] wrote:

i user the sentence;
"UPSERT VALUES INTO my_table(id, col1, col2) VALUES( NEXT VALUE FOR
my_schema.my_sequence, 'foo', 'bar');"
from "http://phoenix.apache.org/sequences.html".
but ,it do not work,bugs:Error: ERROR 603 (42P00): Syntax error. Unexpected
input. Expecting "INTO", got "VALUES" at line 1, column 8.
(state=42P00,code=603)
can you tell me why?

—
Reply to this email directly or view it on GitHub
#739.