Question: ERROR 601 (42P00): Syntax error. Encountered
In HBase program I am executing the insert into query, but it is giving following error:
ERROR 601 (42P00): Syntax error. Encountered "insert" at line 1, column 1.
How to solve this?
Apache phoenix does not accept the 'insert' command, you have to use the 'upsert' command.
Here is one example query of inserting data into phoenix table:
upsert into users (ID,USER_NAME) values(1,'DEEPAK');