[jira] [Issue Comment Deleted] (DRILL-3180) Apache Drill JDBC storage plugin to query rdbms systems such as MySQL and Netezza from Apache Drill

["Olav Jordens (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-3180?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Olav Jordens updated DRILL-3180:
--------------------------------
    Comment: was deleted

(was: Another issue I am having in 1.2.0 (running local): When I run
SELECT TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE
FROM INFORMATION_SCHEMA.`TABLES`
ORDER BY TABLE_NAME DESC;
I see my storage plugin listed with two 'Tables' NZ_MAT_VALUE_TABLE and NZ_MAT_CONF, but none of the tables in Netezza. I have tried to do a select * ... limit 20 from the tables I know should be there, but each time I get a Table not found error. Also if I issue this query:
select * from netezzaplugin.`NZ_MAT_CONF`; 
I get:
org.apache.drill.common.exceptions.UserRemoteException: DATA_READ ERROR: The JDBC storage plugin failed while trying setup the SQL query. sql SELECT * FROM "NZM"."NZ_MAT_CONF" plugin netezzaplugin Fragment 0:0

So I guess my question is: How should I query my tables in Netezza?

Thanks for your support - the potential for Drill looks really good to me once I get my head around it. I would ultimately like to query across Netezza and Hadoop. Is this geared towards the MapR distribution, or should all functionality be available in any case?
Olav)

> 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)