Dynamic Parameters Handling in RelNode

2024-05-02 Thread Ravi Kapoor
Hello Team, Is there any way in the calcite framework to use runtime variables in Rel Node in order to get the same variable back in the translated query? Basically I want the same variable to be used back as the runtime parameter after query translation. Here I am talking specifically about using

Re: Dynamic Parameters Handling in RelNode

2024-05-02 Thread Walaa Eldin Moustafa
Hi Ravi, RelNodes depend on specific table objects with known schemas. Unless we know that table's schema there is no way to generate the RelNode in the first place. Maybe if you know the schema (data types of the table columns), it is possible to get around the lack of a name, but I do not see ho

Re: Dynamic Parameters Handling in RelNode

2024-05-02 Thread Ravi Kapoor
Hi Walaa, Adding onto the last mail: 1) I already have the value of *table_name* parameter with schema and table object to help calcite resolving it while creating RelNode. Is there any way to pass this? But In the translated query the value should be replaced with the key itself. Or Do we al

Re: Dynamic Parameters Handling in RelNode

2024-05-02 Thread Walaa Eldin Moustafa
You should be able to do it at the SqlNode stage. You can create a SqlShuttle that replaces your placeholder table name with another table name.