Re: why syntax Error LPAREN?

[Ahmed Hussien]

The same problem!!

On 19 نوف, 2014 م 06:55, Eli Levine wrote:

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 <aahussi...@gmail.com> 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