Hello Guys, I am trying to evaluate apache calcite for one of our upcoming assignment to convert SQL queries from Teradata to Spark, there are around sixty thousand queries to convert so we are thinking to use calcite SQL builder APIs to build the converted query using HIVE dialect. In this regard I see few problems with calcite SQL builder
1) How do I add "OUTER" while constructing join? I am using SqlJoin class to construct join however I didn't find any way to specify "OUTER" keyword, please suggest best method how can I achieve this. 2) CAST function does not FROMAT keyword, Calcite parser throws exception to parser for example statements which has CAST(col1 AS DATE FORMAT 'dd-mm-yyyy) Any help in this matter will be highly appreciated. Thanks & Regards Sandeep Sharma Sr. Architect | Syntel Bigdata team S 2, A wing, GDC, Talawade Pune India mobile 91-9552507386| internal dial 0203-337333 mail [email protected]<mailto:[email protected]>
