[jira] [Resolved] (NIFI-10170) ExecuteSQL / QueryDatabaseTable - using SQLLITE3 - Unable to resolve union for value

["Pierre Villard (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/NIFI-10170?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Pierre Villard resolved NIFI-10170.
-----------------------------------
    Resolution: Feedback Received

Apache NiFi 1.x is no longer maintained and no new release is planned on the 1.x release line. Marking as resolved as part of a cleanup operation. Please open a new one with an updated description if this is still relevant for NiFi 2.x.

> ExecuteSQL / QueryDatabaseTable - using SQLLITE3 -  Unable to resolve union for value
> -------------------------------------------------------------------------------------
>
>                 Key: NIFI-10170
>                 URL: https://issues.apache.org/jira/browse/NIFI-10170
>             Project: Apache NiFi
>          Issue Type: Bug
>    Affects Versions: 1.16.3
>         Environment: Windows 11
>            Reporter: xoonx
>            Priority: Major
>         Attachments: Test.json, union_error.png
>
>
> I tried to do a simple "select * from x" query on a SQLLITE3 database with "ExecuteSQL" and "QueryDatabaseTable".
> But always got the error "Unable to resolve union for value xxx".
> When i do the same with "ExecuteSQLRecord" with "AvroRecordSetWriter" (default settings) then it works fine.
> Also found a post about this on net: https://www.mail-archive.com/users@nifi.apache.org/msg13156.html



--
This message was sent by Atlassian Jira
(v8.20.10#820010)