ERROR 601 (42P00): Syntax error. Encountered

Hi,

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?

Thanks

View Answers

May 8, 2016 at 8:56 AM

Hi,

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');

Thanks