Try without the outermost parenthesis like this: select
"Records"."Operation", "Records"."status", "Records"."timestamp" from
"History" where "Records"."timestamp"=(SELECT MAX("Records"."timestamp")
FROM "History where "rowId" like 'xyz');Eli On Wed, Nov 19, 2014 at 1:29 AM, Ahmed Hussien <[email protected]> wrote: > 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 >
