Hi All, I am trying to use calcite as a sql rewrite layer to attach some default filter conditions on the incoming SQL queries for execution. I have been able to successfully add FilterRule and modified the logicalplan to include the filter. But when the convert the query back from RelNode to SqlNode, the final query keeps * in the projection list instead of actual column references.
Even without using any filter additions, I am unable to produce the correct query back. SELECT `F`.`FACID`, `F`.`NAME`, `F`.`MONTHLYMAINTENANCE` FROM `FACILITIES` AS `F` Post Validation : SELECT `F`.`FACID`, `F`.`NAME`, `F`.`MONTHLYMAINTENANCE` FROM `FACILITIES` AS `F` Logical Plan LogicalProject(FACID=[$0], NAME=[$1], MONTHLYMAINTENANCE=[$5]) LogicalTableScan(table=[[facilities]]) Logical Plan to SQL query: SELECT * FROM "facilities" Someone please guide me what am I missing here ? LogicalProject has all the fields that i originally had in the input query, however when the query produced out of RelToSqlConverter is having generic wild card * Regards, Karthick
