mhamedbenjmaa commented on issue #6907:
URL: https://github.com/apache/hop/issues/6907#issuecomment-4193188343

   Are we allowed to brainstorm here ? if yes , I agree with @hansva there is 
no need to switch to python or use it, java is more than enough specially that 
all connector and stuff are ready, just read the XML of the pipeline and 
generate SQL 
   
   Apache calcite, is already there and ready to take standard SQL and adapt it 
for any vendo, 
   
   only thing left to do are 
   
   1) validate that the pipeline is ELT ready ( no funny stuff , no multiple 
sources , no CSV destination , there is no unsupported functions etc...)
   2) Generate standard SQL 
   3) adapted to destination vendor (using calsite , or any other ready to use 
java stuff)
   4) push it to destination 
   
   we can start simple 
   
   let say we only support simple pipe like select from , join , copy, 
merge(union) insert into ,  and add more stuff later step by step 
   
   how about that ?


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to