[
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=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=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)
