Eric Lomore created PHOENIX-3347:
------------------------------------

             Summary: Change conformance or remove SELECT statements without 
FROM clauses
                 Key: PHOENIX-3347
                 URL: https://issues.apache.org/jira/browse/PHOENIX-3347
             Project: Phoenix
          Issue Type: Sub-task
            Reporter: Eric Lomore


Current conformance settings do not allow SELECT statements without a FROM 
clause

{code}        setPropertyIfNotSpecified(
                info2,
                CalciteConnectionProperty.CONFORMANCE.camelName(),
                SqlConformance.ORACLE_10.toString());{code}

Note that the actual failure occurs when the SqlValidator rejects the statement
{{Caused by: org.apache.calcite.sql.validate.SqlValidatorException: SELECT must 
have a FROM clause}}

Either need to change conformance or stop supporting SELECT without FROM as 
Phoenix currently does.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to