[jira] [Commented] (GRIFFIN-301) Update custom data connector to have the same parameters as build-in data connector

["ishan verma (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/GRIFFIN-301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17172328#comment-17172328 ] 

ishan verma commented on GRIFFIN-301:
-------------------------------------

Hi [~wankun]

I am currently working on data quality POC using griffin.

So far till now everything is working fine using HIVE  as a data source, but there is new requirement to add mysql as source.

 

I have tried every possible way to have *mysql* as custom data connector but its not working. Measure is getting created and job is going to successful but griffin showing *NO CONTENT* on ui . below is my code for that:-
"data.sources": [
    {
      "name": "source",
      "connectors": [
        {
        "name": "source1595488803031",  
        "type": "CUSTOM",
        "data.unit": "1day",
        "data.time.zone": "",
        "config": 

{           "class": "org.apache.griffin.measure.datasource.connector.batch.MySqlDataConnector",           "database": "griffin_poc",           "tablename": "person_src",           "url": "jdbc:mysql://griffin:3306/griffin_poc",           "user": "test_u",           "password": "test_p",           "driver": "com.mysql.jdbc.Driver"         }

        }
can you please provide some valuable suggestions on this , how to use *mysql/jdbc* as my datasource as it is very critical for my POC. Its an urgent issue.
Anything i am missing  here to link with  mysql, please guide me through this.

It would be great if you can provide one sample on this.

I have also used 0.6 latest commit sql and jdbc class connector but still its showing no content in UI
 Also i have setup mysql on ec2 instance using griffin docker image.

 

[~wankun] request you to please provide your valuable inputs on this if you have done similar setup like that. very much critical for my poc.
 
 Any leads will be appreciated.
Thanks:)

> Update custom data connector to have the same parameters as build-in data connector
> -----------------------------------------------------------------------------------
>
>                 Key: GRIFFIN-301
>                 URL: https://issues.apache.org/jira/browse/GRIFFIN-301
>             Project: Griffin
>          Issue Type: Improvement
>    Affects Versions: 0.6.0
>            Reporter: Wan Kun
>            Assignee: Wan Kun
>            Priority: Major
>             Fix For: 0.6.0
>
>          Time Spent: 0.5h
>  Remaining Estimate: 0h
>
> Now custom data connectors have different parameters with build-in data connector, which will confuse the user. 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)