[
https://issues.apache.org/jira/browse/CALCITE-1992?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Hyde resolved CALCITE-1992.
----------------------------------
Resolution: Fixed
Fix Version/s: 1.15.0
Looks very much like a duplicate of CALCITE-1987 (MONTH is converted to
EXTRACT_DATE behind the scenes). There is a PR for that issue (not committed to
master yet). Please check that out. If it doesn't solve your problem, please
re-open.
> RelNode to Query Convergen
> --------------------------
>
> Key: CALCITE-1992
> URL: https://issues.apache.org/jira/browse/CALCITE-1992
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.12.0
> Reporter: Sanjai Verma
> Assignee: Julian Hyde
> Fix For: 1.15.0
>
>
> Hi Sir,
> I convert a query (
> select rpt_unit_num,month(acct_dt),sum(balance) as bal_year from
> transaction_bal where year(acct_dt)=2017 group by rpt_unit_num,month(acct_dt)
>
> )
> to RelNode rel:
> LogicalAggregate(group=[{0, 1}], bal_year=[SUM($2)])
> LogicalProject(rpt_unit_num=[$4], EXPR$1=[EXTRACT_DATE(FLAG(MONTH),
> Reinterpret($23))], balance=[$24])
> LogicalFilter(condition=[=(EXTRACT_DATE(FLAG(YEAR), Reinterpret($23)),
> 2017)])
> JdbcTableScan(table=[[svayam_data, transaction_bal]])
> but when I convert RelNode rel to Query again using the code:
> SqlDialect dialect = SqlDialect.DatabaseProduct.MYSQL.getDialect();
> RelToSqlConverter rlToSql=new RelToSqlConverter(dialect);
> if(rel instanceof Aggregate){
> Aggregate p=(Aggregate)rel;
> Result rs= rlToSql.visit(p);
> SqlSelect sqSelect=rs.asSelect();
> String sql= sqSelect.toSqlString(dialect).getSql();
> }
> It gives the exception:
> java.lang.UnsupportedOperationException: class
> org.apache.calcite.sql.SqlSyntax$6: SPECIAL
> at org.apache.calcite.util.Util.needToImplement(Util.java:925)
> at org.apache.calcite.sql.SqlSyntax$6.unparse(SqlSyntax.java:115)
> at org.apache.calcite.sql.SqlOperator.unparse(SqlOperator.java:332)
> at org.apache.calcite.sql.SqlCall.unparse(SqlCall.java:99)
> at org.apache.calcite.sql.SqlNodeList.commaList(SqlNodeList.java:121)
> at
> org.apache.calcite.sql.SqlOperator.unparseListClause(SqlOperator.java:349)
> at
> org.apache.calcite.sql.SqlOperator.unparseListClause(SqlOperator.java:338)
> at
> org.apache.calcite.sql.SqlSelectOperator.unparse(SqlSelectOperator.java:152)
> at org.apache.calcite.sql.SqlSelect.unparse(SqlSelect.java:234)
> at org.apache.calcite.sql.SqlNode.toSqlString(SqlNode.java:141)
> at org.apache.calcite.sql.SqlNode.toSqlString(SqlNode.java:147)
> at changeQuery.BuilRelFinal.printNodeInstance(BuilRelFinal.java:469)
>
>
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
