zshit opened a new issue #3583:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/3583
**Which version of Dolphin Scheduler:**
- [branch: dev ; commitId:836e86dca50ac636f66e0b2a881b183b322329e8]
**Describe the bug**
serialization error when presto-jdbc resultset contains object 'PrestoArray'
ERROR] 2020-08-24 23:41:51.262 - [taskAppId=TASK-1-21-31]:[242] - execute
sql error
java.lang.IllegalArgumentException: getResultSet not supported (through
reference chain: com.facebook.presto.jdbc.PrestoArray["resultSet"])
at
com.fasterxml.jackson.databind.ObjectMapper.valueToTree(ObjectMapper.java:2802)
at
org.apache.dolphinscheduler.common.utils.JSONUtils.toJsonNode(JSONUtils.java:67)
at
org.apache.dolphinscheduler.server.worker.task.sql.SqlTask.resultProcess(SqlTask.java:265)
at
org.apache.dolphinscheduler.server.worker.task.sql.SqlTask.executeFuncAndSql(SqlTask.java:232)
at
org.apache.dolphinscheduler.server.worker.task.sql.SqlTask.handle(SqlTask.java:138)
at
org.apache.dolphinscheduler.server.worker.runner.TaskExecuteThread.run(TaskExecuteThread.java:149)
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.fasterxml.jackson.databind.JsonMappingException: getResultSet
not supported (through reference chain:
com.facebook.presto.jdbc.PrestoArray["resultSet"])
at
com.fasterxml.jackson.databind.JsonMappingException.wrapWithPath(JsonMappingException.java:394)
at
com.fasterxml.jackson.databind.JsonMappingException.wrapWithPath(JsonMappingException.java:353)
at
com.fasterxml.jackson.databind.ser.std.StdSerializer.wrapAndThrow(StdSerializer.java:316)
at
com.fasterxml.jackson.databind.ser.std.BeanSerializerBase.serializeFields(BeanSerializerBase.java:727)
at
com.fasterxml.jackson.databind.ser.BeanSerializer.serialize(BeanSerializer.java:155)
at
com.fasterxml.jackson.databind.ser.DefaultSerializerProvider._serialize(DefaultSerializerProvider.java:480)
at
com.fasterxml.jackson.databind.ser.DefaultSerializerProvider.serializeValue(DefaultSerializerProvider.java:319)
at
com.fasterxml.jackson.databind.ObjectMapper.writeValue(ObjectMapper.java:2655)
at
com.fasterxml.jackson.databind.ObjectMapper.valueToTree(ObjectMapper.java:2797)
... 10 common frames omitted
Caused by: java.sql.SQLFeatureNotSupportedException: getResultSet not
supported
at
com.facebook.presto.jdbc.PrestoArray.getResultSet(PrestoArray.java:89)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at
com.fasterxml.jackson.databind.ser.BeanPropertyWriter.serializeAsField(BeanPropertyWriter.java:688)
at
com.fasterxml.jackson.databind.ser.std.BeanSerializerBase.serializeFields(BeanSerializerBase.java:719)
... 15 common frames omitted
[ERROR] 2020-08-24 23:41:51.281 - [taskAppId=TASK-1-21-31]:[144] - sql task
error
java.lang.RuntimeException: execute sql error
at
org.apache.dolphinscheduler.server.worker.task.sql.SqlTask.executeFuncAndSql(SqlTask.java:243)
at
org.apache.dolphinscheduler.server.worker.task.sql.SqlTask.handle(SqlTask.java:138)
at
org.apache.dolphinscheduler.server.worker.runner.TaskExecuteThread.run(TaskExecuteThread.java:149)
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
**To Reproduce**
using sql node execute "select array['a','b','c']" on presto datasource
- Please describe about your requirements or improvement suggestions.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
