PARK JUHEE created NIFI-12564:
---------------------------------
Summary: Processor 'ExecuteSQL' error, when uses unsigned
mdeiumint in mysql
Key: NIFI-12564
URL: https://issues.apache.org/jira/browse/NIFI-12564
Project: Apache NiFi
Issue Type: Bug
Reporter: PARK JUHEE
* Nifi Version : NiFi 1.13.2
* Processor : ExecuteSQL
* Table schema
{code:java}
CREATE TABLE `nifi_test` (
`clm1` varchar(15) NOT NULL DEFAULT '',
`clm2` varchar(10) NOT NULL DEFAULT '',
`clm3` varchar(12) NOT NULL DEFAULT '',
`clm4` varchar(20) NOT NULL DEFAULT '',
`clm5` mediumint(20) unsigned DEFAULT '1',
PRIMARY KEY (`clm1`,`clm2`,`clm3`,`clm4`)
)
insert into nifi_test values ('1','2','3','4',1), ('11','12','13','14',100),
('21','22','23','24',0); {code}
* Error Message
{code:java}
at
org.apache.avro.generic.GenericDatumWriter.write(GenericDatumWriter.java:95)
2024-01-04 10:55:09,064 ERROR [Timer-Driven Process Thread-91]
o.a.nifi.processors.standard.ExecuteSQL
ExecuteSQL[id=ce977968-018c-1000-e472-2fba6455ce07] Unable to execute SQL
select query [SELECT * FROM nifi_test WHERE 1=1 LIMIT 100000] for
StandardFlowFileRecord[uuid=050b1e1c-85a4-440c-9dc4-27404cf1445d,claim=StandardContentClaim
[resourceClaim=StandardResourceClaim[id=1704333306508-74869,
container=default, section=117], offset=0,
length=46],offset=0,name=72fd1391-d014-4329-927b-fd037587ddbc,size=46] routing
to failure
org.apache.nifi.processor.exception.ProcessException:
java.lang.RuntimeException: Unable to resolve union for value 1 with type
java.lang.Integer while appending record {"clm1": "1", "clm2": "2", "clm3":
"3", "clm4": "4","clm5": 1}
at
org.apache.nifi.processors.standard.AbstractExecuteSQL.lambda$onTrigger$4(AbstractExecuteSQL.java:336)
at
org.apache.nifi.controller.repository.StandardProcessSession.write(StandardProcessSession.java:3129)
at
org.apache.nifi.processors.standard.AbstractExecuteSQL.onTrigger(AbstractExecuteSQL.java:332)
at
org.apache.nifi.processor.AbstractProcessor.onTrigger(AbstractProcessor.java:27)
at
org.apache.nifi.controller.StandardProcessorNode.onTrigger(StandardProcessorNode.java:1361)
at
org.apache.nifi.controller.tasks.ConnectableTask.invoke(ConnectableTask.java:247)
at
org.apache.nifi.controller.scheduling.AbstractTimeBasedSchedulingAgent.lambda$doScheduleOnce$0(AbstractTimeBasedSchedulingAgent.java:59)
at org.apache.nifi.engine.FlowEngine$2.run(FlowEngine.java:110)
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:750)
Caused by: java.lang.RuntimeException: Unable to resolve union for value 1 with
type java.lang.Integer while appending record {"clm1": "1", "clm2": "2",
"clm3": "3", "clm4": "4", "clm5": 1}
at
org.apache.nifi.util.db.JdbcCommon.convertToAvroStream(JdbcCommon.java:456)
at
org.apache.nifi.processors.standard.sql.DefaultAvroSqlWriter.writeResultSet(DefaultAvroSqlWriter.java:49)
at
org.apache.nifi.processors.standard.AbstractExecuteSQL.lambda$onTrigger$4(AbstractExecuteSQL.java:334)
... 14 common frames omitted
Caused by: org.apache.avro.file.DataFileWriter$AppendWriteException:
org.apache.avro.UnresolvedUnionException:Not in union ["null","long"]: 1
(field=clm5)
at org.apache.avro.file.DataFileWriter.append(DataFileWriter.java:317)
at
org.apache.nifi.util.db.JdbcCommon.convertToAvroStream(JdbcCommon.java:448)
... 16 common frames omitted
Caused by: org.apache.avro.UnresolvedUnionException: Not in union
["null","long"]: 1 (field=clm5)
at
org.apache.avro.generic.GenericDatumWriter.writeField(GenericDatumWriter.java:247)
at
org.apache.avro.generic.GenericDatumWriter.writeRecord(GenericDatumWriter.java:234)
at
org.apache.avro.generic.GenericDatumWriter.writeWithoutConversion(GenericDatumWriter.java:145)
at
org.apache.avro.generic.GenericDatumWriter.write(GenericDatumWriter.java:95)
at
org.apache.avro.generic.GenericDatumWriter.write(GenericDatumWriter.java:82)
at org.apache.avro.file.DataFileWriter.append(DataFileWriter.java:314)
... 17 common frames omitted
Suppressed: org.apache.avro.UnresolvedUnionException: Not in union
["null","long"]: 1
at
org.apache.avro.generic.GenericData.resolveUnion(GenericData.java:908)
at
org.apache.avro.generic.GenericDatumWriter.resolveUnion(GenericDatumWriter.java:307)
at
org.apache.avro.generic.GenericDatumWriter.writeWithoutConversion(GenericDatumWriter.java:157)
at
org.apache.avro.generic.GenericDatumWriter.write(GenericDatumWriter.java:95)
at
org.apache.avro.generic.GenericDatumWriter.writeField(GenericDatumWriter.java:245)
... 22 common frames omitted {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
