for the following query:
select "Records"."Operation", "Records"."status", "Records"."timestamp"
from "History" where ("Records"."timestamp"=(SELECT
MAX("Records"."timestamp") FROM "History where "rowId" like 'xyz'));
I got this Error:
org.apache.phoenix.exception.PhoenixParserException: ERROR 602 (42P00):
Syntax error. Missing "LPAREN" at line 1, column 95.
at
org.apache.phoenix.exception.PhoenixParserException.newException(PhoenixParserException.java:33)
at
org.apache.phoenix.parse.SQLParser.parseStatement(SQLParser.java:111)
at
org.apache.phoenix.jdbc.PhoenixStatement$PhoenixStatementParser.parseStatement(PhoenixStatement.java:775)
at
org.apache.phoenix.jdbc.PhoenixStatement.parseStatement(PhoenixStatement.java:856)
at
org.apache.phoenix.jdbc.PhoenixPreparedStatement.<init>(PhoenixPreparedStatement.java:91)
at
org.apache.phoenix.jdbc.PhoenixConnection.prepareStatement(PhoenixConnection.java:506)
at uaCore.DBQuerys.chkClDel(DBQuerys.java:143)
at uaCore.DBQuerys.ScUpsert(DBQuerys.java:56)
at uaCore.ReadInsertDelete.insDel(ReadInsertDelete.java:41)
at uaCore.operate.main(operate.java:6)
Caused by: MissingTokenException(inserted [@-1,0:0='<missing
LPAREN>',<77>,1:94] at "Records")
at
org.apache.phoenix.parse.PhoenixSQLParser.recoverFromMismatchedToken(PhoenixSQLParser.java:299)
at org.antlr.runtime.BaseRecognizer.match(BaseRecognizer.java:115)
at
org.apache.phoenix.parse.PhoenixSQLParser.not_expression(PhoenixSQLParser.java:5509)
at
org.apache.phoenix.parse.PhoenixSQLParser.and_expression(PhoenixSQLParser.java:5329)
at
org.apache.phoenix.parse.PhoenixSQLParser.or_expression(PhoenixSQLParser.java:5266)
at
org.apache.phoenix.parse.PhoenixSQLParser.expression(PhoenixSQLParser.java:5231)
at
org.apache.phoenix.parse.PhoenixSQLParser.not_expression(PhoenixSQLParser.java:5511)
at
org.apache.phoenix.parse.PhoenixSQLParser.and_expression(PhoenixSQLParser.java:5329)
at
org.apache.phoenix.parse.PhoenixSQLParser.or_expression(PhoenixSQLParser.java:5266)
at
org.apache.phoenix.parse.PhoenixSQLParser.expression(PhoenixSQLParser.java:5231)
at
org.apache.phoenix.parse.PhoenixSQLParser.select_node(PhoenixSQLParser.java:3543)
at
org.apache.phoenix.parse.PhoenixSQLParser.hinted_select_node(PhoenixSQLParser.java:3685)
at
org.apache.phoenix.parse.PhoenixSQLParser.oneStatement(PhoenixSQLParser.java:537)
at
org.apache.phoenix.parse.PhoenixSQLParser.statement(PhoenixSQLParser.java:443)
at
org.apache.phoenix.parse.SQLParser.parseStatement(SQLParser.java:108)
... 8 more
