Trevor, What does your table look like and what DB are you using?
On Wed, May 6, 2020 at 1:26 PM Trevor Dunn <[email protected]> wrote: > > 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.
