Support Questions
Find answers, ask questions, and share your expertise

Can I use REGEXP embedded in SQL in NiFi? (In a QueryRecord Processor)

Highlighted

Can I use REGEXP embedded in SQL in NiFi? (In a QueryRecord Processor)

Explorer

I'm after trying to use a query similar to the one below to try and use the QueryRecord Processor to use REGEXP to pull out a part of the line in the syslog log file within a SQL query - is this even possible in NiFi?

 

SELECT *
FROM FLOWFILE
WHERE (
`date` REGEXP '(\w{3}\s+\d{1,2}\s+\d{4}\s+[0-9:]{2}\[0-9:]{2}\[0-9:]{2})'
)