Hi, Currently, tajo only support PostgreSQL
Here is the plugins http://tajo.apache.org/docs/current/storage_plugins.html — Jinho Best regards 2017-05-20 6:21 GMT+09:00 Parsian, Mahmoud <[email protected]>: > 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 > > > >
