AnsweredAssumed Answered

AEL and Table Input Step?

Question asked by Jithin dev on Apr 11, 2019

Hi all
I am exploring Pentaho AEL features for a new assignment.I was able to read and process text files and hadoop input files using spark engine(AEL). But when we tried to run a job that is having oracle table as input. it is showing as  " SQL command not properly ended"  But it works fine in kettle engine,     Its a simple sql :SELECT id,name1 FROM test I am using spark on HDP. Kindly help me on this... I am able to insert and update oracle db using ael engine. Is it like AEL doesnt support reading from oracle DB? my sql statement is :  SELECT id,name FROM ravi.test2

 

Error I am getting is

Exception error : Caused by: Error : 933, Position : 51, Sql = SELECT * FROM ( SELECT id,name FROM ravi.test2   ) AS Vc9964d2b_8317_43f1_8614_8654a9cc9d31 WHERE 1=0, OriginalSql = SELECT * FROM ( SELECT id,name FROM ravi.test2   ) AS Vc9964d2b_8317_43f1_8614_8654a9cc9d31 WHERE 1=0, Error Msg = ORA-00933: SQL command not properly ended  .

 

 

Please help me on this

Outcomes