Jinho, thank you for replying to my email.

I have implemented  tajo-storage-mysql plugin and tested on tajo-0.11.3-src: it works well.

These are the classes I added:

  *   public class MySQLJdbcScanner extends JdbcScanner
  *
public class MySQLMetadataProvider extends JdbcMetadataProviderBase
  *
public class MySQLTablespace extends JdbcTablespace

I have tested very little, but would be glad to add them to the Tajo’s GIT.

Best regards,
Mahmoud Parsian

From: Jinho Kim <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Reply-To: "[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>" <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Date: Sunday, May 21, 2017 at 5:50 PM
To: tajo-user <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Subject: Re: Tajo Integration with MySQL

Hi,

Currently, tajo only support PostgreSQL

Here is the plugins
https://urldefense.proofpoint.com/v2/url?u=http-3A__tajo.apache.org_docs_current_storage-5Fplugins.html&d=DwIF-g&c=-czJP1j3ADhzrHyCFvd7gA&r=KAD2xa-I5-9D3L1olHkjyK-wKVxGZp2nMzf1MkQ73Vk&m=yfgq1rOF1th1mjHJki3fnpMZc0XH1hMjkAEl7GpQp6k&s=QYRld2iuu6vNdVdwsb2uXqKWeio_6wU0zRfoPq9Y83Q&e= <https://urldefense.proofpoint.com/v2/url?u=http-3A__tajo.apache.org_docs_current_storage-5Fplugins.html&d=DwMFaQ&c=-czJP1j3ADhzrHyCFvd7gA&r=AENxBNLvKRGkYyvM4QPBiR46t8TZD0yOm7viZRABdSI&m=oLus2ql3tI_Vi4elMRYdcc6vSuFYuctuYGVmK8HtPUs&s=e06fr6JDOBpTmHOfFaeDzbzgaV3Meqm-6idFqP78kgI&e=>

— Jinho
Best regards

2017-05-20 6:21 GMT+09:00 Parsian, Mahmoud <[EMAIL PROTECTED]<mailto:[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
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