I am trying to access MySQL database from Tajo (the latest version 0.11.3).

This is what I did:

  1.  Added storage-site.json to the …/conf/ directory
  2.  Added mysql-connector-java-5.1.42-bin.jar to …/extlib/

Here is my storage-site.json

{

  "spaces":

  {

      "jdbc_mysql":

      {

        "uri": "jdbc:mysql://MYSERVER:3306/MYDB",

        "configs": {

                     "mapped_database": "tajo_mydb",

                     "connection_properties": {

                                                "user":     “my_username",

                                                "password": “my_password"

                                              }

                   }

      }

  }

}
Please note that in my actual storage-site.json, all username/passwords, db name are VALID.
When I start the server, I get the following error:

2017-05-19 13:47:18,351 FATAL org.apache.tajo.master.TajoMaster: Error starting TajoMaster

java.lang.ExceptionInInitializerError

at org.apache.tajo.master.TajoMaster.serviceInit(TajoMaster.java:186)

at org.apache.hadoop.service.AbstractService.init(AbstractService.java:163)

at org.apache.tajo.master.TajoMaster.main(TajoMaster.java:603)

Caused by: org.apache.tajo.exception.TajoRuntimeException: org.apache.tajo.exception.UndefinedTablespaceHandlerException: No tablespace handler for URI scheme 'jdbc:mysql'

at org.apache.tajo.storage.TablespaceManager.initializeTableSpace(TablespaceManager.java:290)

at org.apache.tajo.storage.TablespaceManager.registerTableSpace(TablespaceManager.java:222)

at org.apache.tajo.storage.TablespaceManager.AddTableSpace(TablespaceManager.java:217)

at org.apache.tajo.storage.TablespaceManager.loadTableSpaces(TablespaceManager.java:201)

at org.apache.tajo.storage.TablespaceManager.applyConfig(TablespaceManager.java:162)

at org.apache.tajo.storage.TablespaceManager.initSiteConfig(TablespaceManager.java:135)

at org.apache.tajo.storage.TablespaceManager.<init>(TablespaceManager.java:101)

at org.apache.tajo.storage.TablespaceManager.<clinit>(TablespaceManager.java:91)

... 3 more

Caused by: org.apache.tajo.exception.UndefinedTablespaceHandlerException: No tablespace handler for URI scheme 'jdbc:mysql'

... 11 more

2017-05-19 13:47:18,354 INFO org.apache.tajo.master.TajoMaster: ============================================

2017-05-19 13:47:18,354 INFO org.apache.tajo.master.TajoMaster: TajoMaster received SIGINT Signal

2017-05-19 13:47:18,354 INFO org.apache.tajo.master.TajoMaster: ============================================

2017-05-19 13:47:18,354 INFO org.apache.tajo.master.TajoMaster: Tajo Master main thread exiting

2017-05-19 13:47:18,458 INFO org.apache.tajo.master.TajoMaster: SHUTDOWN_MSG:

Thank you!

Best regards,

Mahmoud
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB