Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

ORA-000923:From key word not found where expected error in Apache NifI

ORA-000923:From key word not found where expected error in Apache NifI

New Contributor

Hi All,

67401-nifi1.png

67402-nifi2.png

While extracting the data from oracle source I'm trying to add oracle current_timestamp to my output in Nifi and i'm using the generate table fetch processor and them i'm connecting to execute sql processor to execute the query generated by the generate table fetch. while executing the execute sql processor i'm getting the below error.

ORA-000923:From key word not found where expected.

Attached the screenshot.

Please provide some inputs. Thanks in advance !!!


nifi1.pngnifi2.png
2 REPLIES 2

Re: ORA-000923:From key word not found where expected error in Apache NifI

Cloudera Employee

Hi,

this error is from the DB, so Nifi is running the SQL, I think you have to check the syntax. Try running the sql query on sqlclient to verify first.

Re: ORA-000923:From key word not found where expected error in Apache NifI

Mentor

@Sharath V

I think your SQL syntax is not correct

SELECT *,SYSDATE as Extract_date from XXXXX 

This should be something like

Select sysdate, a.* from tablex a

Hope that is a good pointer