You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@dolphinscheduler.apache.org by GitBox <gi...@apache.org> on 2020/11/06 07:26:01 UTC
[GitHub] [incubator-dolphinscheduler] lil-winga opened a new issue #4033: nysqlsql 语句使用解析json函数语句报错
lil-winga opened a new issue #4033:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/4033
execute sql error
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Invalid JSON path expression. The error is around character position 1.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933)
at com.mysql.jdbc.MysqlIO.nextRowFast(MysqlIO.java:2111)
at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1985)
at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:3358)
at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:464)
at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:3070)
at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:2338)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2725)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1912)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2020)
at org.apache.dolphinscheduler.server.worker.task.sql.SqlTask.executeFuncAndSql(SqlTask.java:231)
at org.apache.dolphinscheduler.server.worker.task.sql.SqlTask.handle(SqlTask.java:139)
at org.apache.dolphinscheduler.server.worker.runner.TaskExecuteThread.run(TaskExecuteThread.java:129)
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:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
[ERROR] 2020-11-06 14:54:20.698 - [taskAppId=TASK-11-33-52]:[145] - 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:139)
at org.apache.dolphinscheduler.server.worker.runner.TaskExecuteThread.run(TaskExecuteThread.java:129)
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:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
----------------------------------------------------------------
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:
users@infra.apache.org
[GitHub] [incubator-dolphinscheduler] lil-winga commented on issue #4033: when execute mysql json function caused exception : Invalid JSON path expression
Posted by GitBox <gi...@apache.org>.
lil-winga commented on issue #4033:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/4033#issuecomment-723800231
> The query field value is in json format, that is ok, but the array format will report an error. Who wants to fix this problem
i think you can fix this problem , thx
----------------------------------------------------------------
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:
users@infra.apache.org
[GitHub] [incubator-dolphinscheduler] xingchun-chen commented on issue #4033: when execute mysql json function caused exception : Invalid JSON path expression
Posted by GitBox <gi...@apache.org>.
xingchun-chen commented on issue #4033:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/4033#issuecomment-722984230
I can't see the picture. Can your SQL statement be queried successfully in the database?
----------------------------------------------------------------
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:
users@infra.apache.org
[GitHub] [incubator-dolphinscheduler] CalvinKirs commented on issue #4033: when execute mysql json function caused exception : Invalid JSON path expression
Posted by GitBox <gi...@apache.org>.
CalvinKirs commented on issue #4033:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/4033#issuecomment-728664950
i will fix it
----------------------------------------------------------------
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:
users@infra.apache.org
[GitHub] [incubator-dolphinscheduler] xingchun-chen commented on issue #4033: mysql sql 语句使用解析json函数语句报错
Posted by GitBox <gi...@apache.org>.
xingchun-chen commented on issue #4033:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/4033#issuecomment-722975189
Is the coach and category you query the value in the json string?
----------------------------------------------------------------
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:
users@infra.apache.org
[GitHub] [incubator-dolphinscheduler] xingchun-chen commented on issue #4033: when execute mysql json function caused exception : Invalid JSON path expression
Posted by GitBox <gi...@apache.org>.
xingchun-chen commented on issue #4033:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/4033#issuecomment-723790490
The query field value is in json format, that is ok, but the array format will report an error. Who wants to fix this problem
----------------------------------------------------------------
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:
users@infra.apache.org
[GitHub] [incubator-dolphinscheduler] lil-winga commented on issue #4033: when execute mysql json function caused exception : Invalid JSON path expression
Posted by GitBox <gi...@apache.org>.
lil-winga commented on issue #4033:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/4033#issuecomment-722981774
> Is the coach and category you query the value in the json string?
thanks please help me
----------------------------------------------------------------
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:
users@infra.apache.org
[GitHub] [incubator-dolphinscheduler] lil-winga commented on issue #4033: when execute mysql json function caused exception : Invalid JSON path expression
Posted by GitBox <gi...@apache.org>.
lil-winga commented on issue #4033:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/4033#issuecomment-728668026
> i will fix it
oh yes ,thank you , expect
----------------------------------------------------------------
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:
users@infra.apache.org
[GitHub] [incubator-dolphinscheduler] lil-winga commented on issue #4033: when execute mysql json function caused exception : Invalid JSON path expression
Posted by GitBox <gi...@apache.org>.
lil-winga commented on issue #4033:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/4033#issuecomment-723735891
> You can try to query only one JSON_EXTRACT
I try only one JSON_EXTRACT is error
----
execute sql error
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Invalid JSON path expression. The error is around character position 1.
----------------------------------------------------------------
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:
users@infra.apache.org
[GitHub] [incubator-dolphinscheduler] lenboo closed issue #4033: when execute mysql json function caused exception : Invalid JSON path expression
Posted by GitBox <gi...@apache.org>.
lenboo closed issue #4033:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/4033
----------------------------------------------------------------
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:
users@infra.apache.org
[GitHub] [incubator-dolphinscheduler] xingchun-chen commented on issue #4033: mysql sql 语句使用解析json函数语句报错
Posted by GitBox <gi...@apache.org>.
xingchun-chen commented on issue #4033:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/4033#issuecomment-722960010
please update the title in English, thanks
----------------------------------------------------------------
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:
users@infra.apache.org
[GitHub] [incubator-dolphinscheduler] xingchun-chen commented on issue #4033: when execute mysql json function caused exception : Invalid JSON path expression
Posted by GitBox <gi...@apache.org>.
xingchun-chen commented on issue #4033:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/4033#issuecomment-723721581
You can try to query only one JSON_EXTRACT
----------------------------------------------------------------
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:
users@infra.apache.org
[GitHub] [incubator-dolphinscheduler] lil-winga commented on issue #4033: when execute mysql json function caused exception : Invalid JSON path expression
Posted by GitBox <gi...@apache.org>.
lil-winga commented on issue #4033:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/4033#issuecomment-723017672
> I can't see the picture. Can your SQL statement be queried successfully in the database?
yes, it is ,this sql SQL statement be queried successfully in the database
----------------------------------------------------------------
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:
users@infra.apache.org
[GitHub] [incubator-dolphinscheduler] xingchun-chen edited a comment on issue #4033: when execute mysql json function caused exception : Invalid JSON path expression
Posted by GitBox <gi...@apache.org>.
xingchun-chen edited a comment on issue #4033:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/4033#issuecomment-723790490
The query field value is in json format, that is ok, but the array format will report an error. Who wants to fix this problem
----------------------------------------------------------------
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:
users@infra.apache.org