[
https://issues.apache.org/jira/browse/DRILL-3180?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15070144#comment-15070144
]
Hyzandey Castro Alves edited comment on DRILL-3180 at 12/23/15 8:26 PM:
------------------------------------------------------------------------
Hi, Jacques.
Considering this plugin can theoretically connect to any RDBMS through JDBC, I
tried to connect it to some INFORMIX database with something like this (named
it "informix"):
{
"type": "jdbc",
"driver": "com.informix.jdbc.IfxDriver",
"url":
"jdbc:informix-sqli://IP:PORT/sample_database:INFORMIXSERVER=sample_server;user=sample_user;password=sample_password",
"username": null,
"password": null,
"enabled": true
}
It successfully connects and gets me to list "schemas" and tables, but I cannot
get queries to work because the SQL sent to the INFORMIX server looks like
this:
SELECT *
FROM sample_database.sample_table
for a Drill query like this:
SELECT *
FROM informix.sample_database.sample_table
I think this error occurs because it is not necessary to qualify the table name
with the database name. Worse than this, the appended database name gets the
query on INFORMIX to fail.
How could I fix this? I tried to query from "informix.sample_table" table, but
it gets me a "VALIDATION ERROR: informix.sample_table not found".
was (Author: hyzandey):
Hi, Jacques.
Considering this plugin can theoretically connect to any RDBMS through JDBC, I
tried to connect it to some INFORMIX database with something like this (named
it "informix"):
{
"type": "jdbc",
"driver": "com.informix.jdbc.IfxDriver",
"url":
"jdbc:informix-sqli://IP:PORT/sample_database:INFORMIXSERVER=sample_server;user=sample_user;password=sample_password",
"username": null,
"password": null,
"enabled": true
}
It successfully connects and get me to list "schemas" and tables, but I cannot
get queries to work because the SQL sent to the INFORMIX server looks like
this:
SELECT *
FROM sample_database.sample_table
for a Drill query like this:
SELECT *
FROM informix.sample_database.sample_table
I think this error occurs because it is not necessary to qualify the table name
with the database name. Worse than this, the appended database name gets the
query on INFORMIX to fail.
How could I fix this? I tried to query from "informix.sample_table" table, but
it gets me a "VALIDATION ERROR: informix.sample_table not found".
> 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)
