ExecuteSQL Unsupported field: YearOfEra

Question

Hello!NiFi version - 2.5.0Java - 21When trying to run ExecuteSQL processor i'm getting error:What does it mean and where is this unsupported field located? Log:It's something wrong with java or nifi or whole system?Please, help me to figure it out

blackboks · Accepted Answer

@vafs thank you for the reply, in fact the problem was in logback.xml file, not sure in what part of it exactly, but when i'm replaced is from another worked server, make changes in paths and restart Nifi the ExecuteSQL processor start to work as expected

vafs · Answer

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-instant-to-string

Sign up

Please use your Cloudera account.

Login to the community

Please use your Cloudera account.