[GitHub] [druid] WZStephen opened a new issue #12103: SQL Metadata Connector not configured! Request Failed 500

[GitBox <gi...@apache.org>]

WZStephen opened a new issue #12103:
URL: https://github.com/apache/druid/issues/12103


   Hi,
   
   When I try to ingest the data from MySQL by submitting the JSON task down below to the server, I can always get a popout error from druid frontend UI said the 'SqlInputSource' error. The task and error messages are listed down below. I used https://github.com/apache/druid/blob/master/distribution/docker/Dockerfile.mysql to rebuild the druid docker image that suite with MySQL and I have checked the MySQL connector is correctly configured in both extensions/mysql-metadata-storage, and lib/. Can someone help me with this, please?
   ```
   {
     "type": "index_parallel",
     "spec": {
       "dataSchema": {
         "dataSource": "block_info_java_1",
         "parser": {
           "parserSpec": {
             "format": "timeAndDims",
             "dimensionsSpec": {
               "dimensions": [
                   ...........
               ]
             },
             "timestampSpec": {
               "column": "InsertTime",
               "format": "auto"
             }
           }
         },
         "granularitySpec": {
           "queryGranularity": "none",
           "rollup": false,
           "segmentGranularity": "week"
         }
       },
       "ioConfig": {
         "type": "index_parallel",
         "inputSource": {
           "type": "sql",
           "database": {
             "type": "mysql",
             "connectorConfig": {
               "connectURI": "jdbc:mysql://10.11.4.51:3306/bench",
               "user": "druid",
               "password": "123456"
             }
           },
           "sql":["SELECT * FROM block_info_java_1"]
         }
       },
       "tuningConfig": { 
         "type": "index_parallel"
       }
     }
   }
   ```
   
   ```
   Failed to submit task: Cannot construct instance of `org.apache.druid.metadata.input.SqlInputSource`, problem: `java.lang.NullPointerException` at [Source: (org.eclipse.jetty.server.HttpInputOverHTTP); line: 1, column: 2070] (through reference chain: org.apache.druid.indexing.common.task.batch.parallel.ParallelIndexSupervisorTask["spec"]->org.apache.druid.indexing.common.task.batch.parallel.ParallelIndexIngestionSpec["ioConfig"]->org.apache.druid.indexing.common.task.batch.parallel.ParallelIndexIOConfig["inputSource"])
   ```


-- 
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.

To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org