[jira] [Commented] (DRILL-2344) JDBC : getTables() method never returns

["Rahul Challapalli (JIRA)" <ji...@apache.org>]

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

Rahul Challapalli commented on DRILL-2344:
------------------------------------------

This is one of the first metadata calls executed by the BI tools. That is the reason I marked it as critical

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