[GitHub] [druid] MoushmiDas commented on issue #9365: Fix compatibility issues with SqlFirehose

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

MoushmiDas commented on issue #9365: Fix compatibility issues with SqlFirehose
URL: https://github.com/apache/druid/pull/9365#issuecomment-591823095
 
 
   
   Hi Team,
   
   I am trying to Load the data from Postgresql to Apache Druid(apache-druid-0.17.0) , but I am getting below error:
   
   "SQL firehose error with org.apache.druid.segment.realtime.firehose.SqlFirehoseFactory cannot be cast to org.apache.druid.data.input.FiniteFirehoseFactory."
   
   seems the issue is already resolve in the below  Ticket request:
   
   *SQL firehose error #9359
   *Fix compatibility issues with SqlFirehose #9365
   
   Could you please help me to get the new io-configuration for the postgresql.
   
   Currently we are using below io-config for which we are getting above error:
       "ioConfig": {
         "type": "index",
         "firehose": {
           "type": "sql",
           "database": {
             "type": "postgresql",
             "connectorConfig": {
              "connectURI": "jdbc:postgresql://<HostName>:<PortNo.>/<DB_Name>",
   			"user": "<UserName>",
               "password": "<Password>"
                }
           },
           "sqls": [
             "select * from Table;"
           ]
         }
       }

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


With regards,
Apache Git Services

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