[
https://issues.apache.org/jira/browse/NIFI-10170?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
xoonx updated NIFI-10170:
-------------------------
Description:
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/[email protected]/msg13156.html
was:
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.
> 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/[email protected]/msg13156.html
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
