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