Support Questions
Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.

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

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.

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