drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Parth Chandra (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-2344) JDBC : getTables() method never returns
Date Mon, 02 Mar 2015 19:25:06 GMT

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

Parth Chandra updated DRILL-2344:
---------------------------------
    Fix Version/s: 0.9.0

> JDBC : getTables() method never returns
> ---------------------------------------
>
>                 Key: DRILL-2344
>                 URL: https://issues.apache.org/jira/browse/DRILL-2344
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Client - JDBC
>            Reporter: Rahul Challapalli
>            Assignee: Daniel Barclay (Drill)
>            Priority: Critical
>             Fix For: 0.9.0
>
>
> git.commit.id.abbrev=02d23cb
> I am trying to get the tables from drill using the below code and drill never returns
> {code}
> DatabaseMetaData meta = conn.getMetaData();
> ResultSet rs = meta.getTables(null, null, null, new String[] {"VIEW"});
> System.out.println("Drill does not get to this point");
> {code}
> Below is the underlying query which drill issues from withing the getTables() method.
> {code}
> SELECT table_catalog AS TABLE_CAT, 
>        table_schema  AS TABLE_SCHEM, 
>        table_name, 
>        table_type, 
>        ''            AS REMARKS, 
>        ''            AS TYPE_CAT, 
>        ''            AS TYPE_SCHEM, 
>        ''            AS TYPE_NAME, 
>        ''            AS SELF_REFERENCING_COL_NAME, 
>        ''            AS REF_GENERATION 
> FROM   INFORMATION_SCHEMA.`TABLES` 
> WHERE  1 = 1 
>        AND ( table_type LIKE 'VIEW' ) 
> ORDER  BY table_type, 
>           table_catalog, 
>           table_schema, 
>           table_name 
> {code}
> When I tried to manually run this query, sqlline never returned



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message