Support Questions

Find answers, ask questions, and share your expertise
Announcements
Now Live: Explore expert insights and technical deep dives on the new Cloudera Community BlogsRead the Announcement

ExecuteSQL Unsupported field: YearOfEra

avatar
Explorer

Hello!

NiFi version - 2.5.0

Java - 21

When trying to run ExecuteSQL processor i'm getting error:

blackboks_0-1765382662743.png

What does it mean and where is this unsupported field located? 

Log:

blackboks_1-1765382745262.png

It's something wrong with java or nifi or whole system?

Please, help me to figure it out

 

1 REPLY 1

avatar
Expert Contributor

Hello @blackboks

Thanks for being part of our community. 

That error you're facing looks like it's from Java side, not from NiFi. 
This appears when no timezone information is provided during the request. 

Maybe these two forums can help you find where in your query is missing that: 
https://java2blog.com/format-instant-to-string-java/
https://stackoverflow.com/questions/25229124/unsupportedtemporaltypeexception-when-formatting-instan... 


Regards,
Andrés Fallas
--
Was your question answered? Please take some time to click on "Accept as Solution" below this post.
If you find a reply useful, say thanks by clicking on the thumbs-up button.