Please, don’t put “URGENT HELP” in capitals in the subject line. All of our users would like their questions answered in a timely fashion.
It would be more helpful if you actually described the subject of your question. Then someone will be able to find your question in the mail archives. I have other more urgent things to do today before I answer your question. While you are waiting for me (or someone else) to respond to your question, please read “How to ask questions the smart way”. http://www.catb.org/esr/faqs/smart-questions.html <http://www.catb.org/esr/faqs/smart-questions.html> Julian > On Jan 25, 2016, at 2:00 AM, Sharma, Sandeep <[email protected]> > wrote: > > 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]> >
