Charlie Meyer created NIFI-5818:
-----------------------------------
Summary: JDBCommon does not convert SQL result sets to avro when
columns have no name
Key: NIFI-5818
URL: https://issues.apache.org/jira/browse/NIFI-5818
Project: Apache NiFi
Issue Type: Bug
Components: Core Framework
Affects Versions: 1.8.0
Reporter: Charlie Meyer
I'm using executesqlrecord, but this seems to happen on any processor that
relies on JDBCommon for converting avro under the covers.
If I run a query like {{SELECT 1}} I get a stack trace:
{code:java}
{ "cause": { "cause": null, "stackTrace": [ { "methodName": "validateName",
"fileName": "Schema.java", "lineNumber": 1144, "className":
"org.apache.avro.Schema", "nativeMethod": false }, { "methodName":
"access$200", "fileName": "Schema.java", "lineNumber": 81, "className":
"org.apache.avro.Schema", "nativeMethod": false }, { "methodName": "<init>",
"fileName": "Schema.java", "lineNumber": 403, "className":
"org.apache.avro.Schema$Field", "nativeMethod": false }, { "methodName":
"completeField", "fileName": "SchemaBuilder.java", "lineNumber": 2124,
"className": "org.apache.avro.SchemaBuilder$FieldBuilder", "nativeMethod":
false }, { "methodName": "completeField", "fileName": "SchemaBuilder.java",
"lineNumber": 2120, "className": "org.apache.avro.SchemaBuilder$FieldBuilder",
"nativeMethod": false }, { "methodName": "access$5200", "fileName":
"SchemaBuilder.java", "lineNumber": 2034, "className":
"org.apache.avro.SchemaBuilder$FieldBuilder", "nativeMethod": false }, {
"methodName": "noDefault", "fileName": "SchemaBuilder.java", "lineNumber":
2146, "className": "org.apache.avro.SchemaBuilder$FieldDefault",
"nativeMethod": false }, { "methodName": "createSchema", "fileName":
"JdbcCommon.java", "lineNumber": 577, "className":
"org.apache.nifi.processors.standard.util.JdbcCommon", "nativeMethod": false },
{ "methodName": "writeResultSet", "fileName": "RecordSqlWriter.java",
"lineNumber": 68, "className":
"org.apache.nifi.processors.standard.sql.RecordSqlWriter", "nativeMethod":
false }, { "methodName": "lambda$onTrigger$1", "fileName":
"ExecuteSqlRecordWithoutSwallowingErrors.java", "lineNumber": 362, "className":
"com.civitaslearning.collect.nifi.processor.ExecuteSqlRecordWithoutSwallowingErrors",
"nativeMethod": false }, { "methodName": "write", "fileName":
"StandardProcessSession.java", "lineNumber": 2648, "className":
"org.apache.nifi.controller.repository.StandardProcessSession", "nativeMethod":
false }, { "methodName": "onTrigger", "fileName":
"ExecuteSqlRecordWithoutSwallowingErrors.java", "lineNumber": 360, "className":
"com.civitaslearning.collect.nifi.processor.ExecuteSqlRecordWithoutSwallowingErrors",
"nativeMethod": false }, { "methodName": "onTrigger", "fileName":
"AbstractProcessor.java", "lineNumber": 27, "className":
"org.apache.nifi.processor.AbstractProcessor", "nativeMethod": false }, {
"methodName": "onTrigger", "fileName": "StandardProcessorNode.java",
"lineNumber": 1165, "className":
"org.apache.nifi.controller.StandardProcessorNode", "nativeMethod": false }, {
"methodName": "invoke", "fileName": "ConnectableTask.java", "lineNumber": 203,
"className": "org.apache.nifi.controller.tasks.ConnectableTask",
"nativeMethod": false }, { "methodName": "run", "fileName":
"TimerDrivenSchedulingAgent.java", "lineNumber": 117, "className":
"org.apache.nifi.controller.scheduling.TimerDrivenSchedulingAgent$1",
"nativeMethod": false }, { "methodName": "call", "fileName": "Executors.java",
"lineNumber": 511, "className":
"java.util.concurrent.Executors$RunnableAdapter", "nativeMethod": false }, {
"methodName": "runAndReset", "fileName": "FutureTask.java", "lineNumber": 308,
"className": "java.util.concurrent.FutureTask", "nativeMethod": false }, {
"methodName": "access$301", "fileName": "ScheduledThreadPoolExecutor.java",
"lineNumber": 180, "className":
"java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask",
"nativeMethod": false }, { "methodName": "run", "fileName":
"ScheduledThreadPoolExecutor.java", "lineNumber": 294, "className":
"java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask",
"nativeMethod": false }, { "methodName": "runWorker", "fileName":
"ThreadPoolExecutor.java", "lineNumber": 1149, "className":
"java.util.concurrent.ThreadPoolExecutor", "nativeMethod": false }, {
"methodName": "run", "fileName": "ThreadPoolExecutor.java", "lineNumber": 624,
"className": "java.util.concurrent.ThreadPoolExecutor$Worker", "nativeMethod":
false }, { "methodName": "run", "fileName": "Thread.java", "lineNumber": 748,
"className": "java.lang.Thread", "nativeMethod": false } ], "message": "Empty
name", "localizedMessage": "Empty name", "suppressed": [] }, "stackTrace": [ {
"methodName": "lambda$onTrigger$1", "fileName":
"ExecuteSqlRecordWithoutSwallowingErrors.java", "lineNumber": 364, "className":
"com.civitaslearning.collect.nifi.processor.ExecuteSqlRecordWithoutSwallowingErrors",
"nativeMethod": false }, { "methodName": "write", "fileName":
"StandardProcessSession.java", "lineNumber": 2648, "className":
"org.apache.nifi.controller.repository.StandardProcessSession", "nativeMethod":
false }, { "methodName": "onTrigger", "fileName":
"ExecuteSqlRecordWithoutSwallowingErrors.java", "lineNumber": 360, "className":
"com.civitaslearning.collect.nifi.processor.ExecuteSqlRecordWithoutSwallowingErrors",
"nativeMethod": false }, { "methodName": "onTrigger", "fileName":
"AbstractProcessor.java", "lineNumber": 27, "className":
"org.apache.nifi.processor.AbstractProcessor", "nativeMethod": false }, {
"methodName": "onTrigger", "fileName": "StandardProcessorNode.java",
"lineNumber": 1165, "className":
"org.apache.nifi.controller.StandardProcessorNode", "nativeMethod": false }, {
"methodName": "invoke", "fileName": "ConnectableTask.java", "lineNumber": 203,
"className": "org.apache.nifi.controller.tasks.ConnectableTask",
"nativeMethod": false }, { "methodName": "run", "fileName":
"TimerDrivenSchedulingAgent.java", "lineNumber": 117, "className":
"org.apache.nifi.controller.scheduling.TimerDrivenSchedulingAgent$1",
"nativeMethod": false }, { "methodName": "call", "fileName": "Executors.java",
"lineNumber": 511, "className":
"java.util.concurrent.Executors$RunnableAdapter", "nativeMethod": false }, {
"methodName": "runAndReset", "fileName": "FutureTask.java", "lineNumber": 308,
"className": "java.util.concurrent.FutureTask", "nativeMethod": false }, {
"methodName": "access$301", "fileName": "ScheduledThreadPoolExecutor.java",
"lineNumber": 180, "className":
"java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask",
"nativeMethod": false }, { "methodName": "run", "fileName":
"ScheduledThreadPoolExecutor.java", "lineNumber": 294, "className":
"java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask",
"nativeMethod": false }, { "methodName": "runWorker", "fileName":
"ThreadPoolExecutor.java", "lineNumber": 1149, "className":
"java.util.concurrent.ThreadPoolExecutor", "nativeMethod": false }, {
"methodName": "run", "fileName": "ThreadPoolExecutor.java", "lineNumber": 624,
"className": "java.util.concurrent.ThreadPoolExecutor$Worker", "nativeMethod":
false }, { "methodName": "run", "fileName": "Thread.java", "lineNumber": 748,
"className": "java.lang.Thread", "nativeMethod": false } ], "message":
"org.apache.avro.SchemaParseException: Empty name", "localizedMessage":
"org.apache.avro.SchemaParseException: Empty name", "suppressed": [] }
{code}
The workaround is to modify the query to be like {{SELECT 1 as valid}} which
then assigns a name for the column.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
