[
https://issues.apache.org/jira/browse/PHOENIX-643?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gabriel Reid resolved PHOENIX-643.
----------------------------------
Resolution: Fixed
Bulk resolve of closed issues imported from GitHub. This status was reached by
first re-opening all closed imported issues and then resolving them in bulk.
> Support to enable Pentaho Mondrian dialect
> ------------------------------------------
>
> Key: PHOENIX-643
> URL: https://issues.apache.org/jira/browse/PHOENIX-643
> Project: Phoenix
> Issue Type: Task
> Reporter: bennychow
>
> Using 2.1.0, Phoenix is unable to parse this SQL:
> select "WEB_STAT"."DATE" as "c0", "WEB_STAT"."DOMAIN" as "c1",
> sum("WEB_STAT"."ACTIVE_VISITOR") as "m0" from "WEB_STAT" "WEB_STAT" where
> "WEB_STAT"."DATE" in (DATE '2013-01-01', DATE '2013-01-02', DATE
> '2013-01-03', DATE '2013-01-04', DATE '2013-01-05', DATE '2013-01-06', DATE
> '2013-01-07', DATE '2013-01-08', DATE '2013-01-09', DATE '2013-01-10', DATE
> '2013-01-11', DATE '2013-01-12', DATE '2013-01-13', DATE '2013-01-14', DATE
> '2013-01-15', DATE '2013-01-16', DATE '2013-01-17') and "WEB_STAT"."DOMAIN"
> in ('Apple.com', 'Google.com', 'Salesforce.com') group by "WEB_STAT"."DATE",
> "WEB_STAT"."DOMAIN"
> ERROR 602 (42P00): Syntax error. Missing "LPAREN" at line 1, column 138.)
> I believe this used to work in 2.0.1 so this might be a regression.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
