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
You need to add "datasource.driver" to your ‘mysql.properties’ file.
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.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.