skip to Main Content

I am doing

$ ./launcher run

Below Error message is get generate

java.lang.IllegalArgumentException: No factory for connector 'mysql'. Available factories: [memory, kudu, blackhole, kinesis, redis, accumulo, gsheets, raptor-legacy, elasticsearch, jmx, postgresql, redshift, sqlserver, localfile, tpch, iceberg, bigquery, memsql, prometheus, mongodb, example-http, pinot, tpcds, oracle, phoenix, system, cassandra, kafka, atop, hive-hadoop2, presto-thrift]
at com.google.common.base.Preconditions.checkArgument(Preconditions.java:441)
at io.prestosql.connector.ConnectorManager.createCatalog(ConnectorManager.java:185)
at io.prestosql.metadata.StaticCatalogStore.loadCatalog(StaticCatalogStore.java:88)
at io.prestosql.metadata.StaticCatalogStore.loadCatalogs(StaticCatalogStore.java:68)
at io.prestosql.server.Server.doStart(Server.java:117)
at io.prestosql.server.Server.lambda$start$0(Server.java:72)
at io.prestosql.$gen.Presto_336____20200622_041142_1.run(Unknown Source)
at io.prestosql.server.Server.start(Server.java:72)
at io.prestosql.server.PrestoServer.main(PrestoServer.java:39)

here is my ‘mysql.properties’ file

connector.name=mysql
connection-url=jdbc:mysql://127.0.0.1:3306
connection-user=root
connection-password=onkar@77

Can any one please help.. please

3

Answers


  1. You need to add "datasource.driver" to your ‘mysql.properties’ file.

    Login or Signup to reply.
  2. The mysql plugin is definitely part of Presto 336, the version you are using.

    I would assume the <presto-install-dir>/plugin/mysql directory got removed somehow on local installation.

    Login or Signup to reply.
  3. Get rid of trailing whitespaces in mysql.properties file. I had a similar issue while working with Kafka connector (No factory for connector kafka) and realized that trailing whitespaces were causing the problem. After removing the whitespaces in kafka.properties I got it working.

    Login or Signup to reply.
Please signup or login to give your own answer.
Back To Top
Search