Hi,

I have a plain sql string and using Planner i convert it to RelNode just fine. 
then i am trying to generate sql string from builder using: 
new RelToSqlConverter(dialect).visitChild(0, 
relNode).asQuery.toSqlString(dialect).getSql and got exception.

It fails with: java.lang.UnsupportedOperationException: class 
org.apache.calcite.sql.SqlSyntax$6: SPECIAL. After debugging i found that i 
have a problem with following expression: EXTRACT(EPOCH FROM timestamp). Any 
ideas how to fix it? I am considering to add timestamp to operand type checker.

Reply via email to