Tajo Integration with MySQL

[Parsian, Mahmoud]

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