Re: Re[2]: Calcite-RelNode clarifications

2019-03-08 Thread Rakesh Nair
Hello Hongze, Thanks for responding. Your suggestion worked splendidly. I've got one more clarification if its not too much trouble. The following RelNode: *RelDataType any = builder.getTypeFactory().createSqlType(SqlTypeName.ANY);* *ImmutableList constExps =

Re[2]: Calcite-RelNode clarifications

2019-03-08 Thread Hongze Zhang
Hi RamKrishna, As you said: > So, basically I need to add 2 Hours to CurrentTime. I think the generated function call "TIMESTAMPADD(HOUR, 2, CURRENT_TIMESTAMP)" already did that. If what you want is to compare it's value with a MySQL's Date (with format -xx-xx), based on Christopher's