[ https://issues.apache.org/jira/browse/PHOENIX-3347?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Eric Lomore updated PHOENIX-3347: --------------------------------- Description: Current conformance settings do not allow SELECT statements without a FROM clause {code:title=PhoenixCalciteEmbeddedDriver.java} 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. was: Current conformance settings do not allow SELECT statements without a FROM clause {code=PhoenixCalciteEmbeddedDriver.java} 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. > 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:title=PhoenixCalciteEmbeddedDriver.java} > 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)