[
https://issues.apache.org/jira/browse/DRILL-3180?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14633590#comment-14633590
]
Venkat Gurukrishna edited comment on DRILL-3180 at 7/20/15 1:25 PM:
--------------------------------------------------------------------
[~magnusp] [~rshaw]
Hi Magnus, Richard,
I want to create the mysql plugin in Apache Drill 1.1.0 using the following
configuration:
{ "type": "jdbc", "driver": "com.mysql.jdbc.Driver", "uri":
"jdbc:mysql://ipaddress:3306/schemana", "username": "abc", "password": "xyz",
"enabled": true }
Also copied com.mysql.jdbc_5.1.5.jar in the "apache-drill-1.1.0\jars\3rdparty"
folder.
When I try to create a plugin it gives the following error:
Error: Invalid JSON Mapping
Need your help on the same.
Thanks & Regards,
-Venkat Gurukrishna
was (Author: vgkkonda):
[~magnusp]
Hi Magnus,
I want to create the mysql plugin in Apache Drill 1.1.0 using the following
configuration:
{ "type": "jdbc", "driver": "com.mysql.jdbc.Driver", "uri":
"jdbc:mysql://ipaddress:3306/schemana", "username": "abc", "password": "xyz",
"enabled": true }
Also copied com.mysql.jdbc_5.1.5.jar in the "apache-drill-1.1.0\jars\3rdparty"
folder.
When I try to create a plugin it gives the following error:
Error: Invalid JSON Mapping
Need your help on the same.
Thanks & Regards,
-Venkat Gurukrishna
> Apache Drill JDBC storage plugin to query rdbms systems such as MySQL and
> Netezza from Apache Drill
> ---------------------------------------------------------------------------------------------------
>
> Key: DRILL-3180
> URL: https://issues.apache.org/jira/browse/DRILL-3180
> Project: Apache Drill
> Issue Type: New Feature
> Components: Storage - Other
> Affects Versions: 1.0.0
> Reporter: Magnus Pierre
> Assignee: Jacques Nadeau
> Labels: Drill, JDBC, plugin
> Fix For: 1.2.0
>
> Attachments: pom.xml, storage-mpjdbc.zip
>
> Original Estimate: 1m
> Remaining Estimate: 1m
>
> I have developed the base code for a JDBC storage-plugin for Apache Drill.
> The code is primitive but consitutes a good starting point for further
> coding. Today it provides primitive support for SELECT against RDBMS with
> JDBC.
> The goal is to provide complete SELECT support against RDBMS with push down
> capabilities.
> Currently the code is using standard JDBC classes.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
