I’m trying to import data from MySQL database into MapDB using SQL-importer by running this
java -cp /usr/local/bin/mapdjdbc-1.0-SNAPSHOT-jar-with-dependencies.jar:/usr/local/bin/mapd-1.0-SNAPSHOT-jar-with-dependencies.jar:./mysql-jdbc-driver/mysql-connector-java-5.1.38.jar com.mapd.utility.SQLImporter -t <target_tablename> -ss "select * from <src_dbname>.<src_tablename>" -c "jdbc:mysql://<src_hostname>:3306/<src_dbname>" -su root -sp ""
But I get this error
2017-05-26 19:17:30 INFO SQLImporter:executeQuery:191 - Connecting to database url :jdbc:mysql://:3306/
2017-05-26 19:17:30 ERROR SQLImporter:createMapDConnection:381 - Connection failed - org.apache.thrift.transport.TTransportException: java.net.ConnectException: Connection refused (Connection refused)
I confirmed that I’m able to connect the same MySQL database using MySQL client.
Any ideas what am I missing and how to resolve this?