Hi I am using ExecuteSQL processor downstream of GenerateTableFetch to pull data from a table. However when I run the flow I get error below. I tried a couple of different tables and it is always fails with the same on integer column.
I have executed the SQL directly against the source and the SQL works fine. I am hoping someone can help me. I am using NiFi 1.11.4 Error: Unable to execute SQL select query SELECT * FROM basin_countries WHERE 1=1 LIMIT 10000 for StandardFlowFileRecord[uuid=6887eade-45a7-45da-b19f-47465b895885,claim=StandardContentClaim [resourceClaim=StandardResourceClaim[id=1588733601463-1, container=default, section=1], offset=20643, length=51],offset=0,name=81c3e41a-88c4-4e4c-a3fb-4603fbd176aa,size=51] due to java.lang.RuntimeException: Unable to resolve union for value 1 with type java.lang.Integer while appending record Thanks Trevor ________________________________ This e-mail, including accompanying communications and attachments, is strictly confidential and only for the intended recipient. Any retention, use or disclosure not expressly authorised by IHSMarkit is prohibited. This email is subject to all waivers and other terms at the following link: https://ihsmarkit.com/Legal/EmailDisclaimer.html Please visit www.ihsmarkit.com/about/contact-us.html for contact information on our offices worldwide.
