drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Olav Jordens (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (DRILL-3180) Apache Drill JDBC storage plugin to query rdbms systems such as MySQL and Netezza from Apache Drill
Date Tue, 17 Nov 2015 22:30:11 GMT

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

Olav Jordens edited comment on DRILL-3180 at 11/17/15 10:29 PM:
----------------------------------------------------------------

Hi Jacques,

I followed Magnus' suggestion to create the storage plugin to Netezza using a database like
so:
{
  "type": "jdbc",
  "driver": "org.netezza.Driver",
  "url": "jdbc:netezza://edw-vip-prod:5480/SYSTEM",
  "username": "username",
  "password": "password",
  "enabled": true
}
and it gives "Success" in version 1.3.0. I can see the tables now - thanks!


was (Author: olavj):
Hi Jacques,

I followed Magnus' suggestion to create the storage plugin to Netezza using a database like
so:
{
  "type": "jdbc",
  "driver": "org.netezza.Driver",
  "url": "jdbc:netezza://edw-vip-prod:5480/SYSTEM",
  "username": "username",
  "password": "password",
  "enabled": true
}
and it gives "Success" in version 1.2.0. However, when I try your version 1.3.0 linked above,
I get the unable to create/update storage plugin error.

> 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: patch.diff, 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)

Mime
View raw message