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)