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

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

Rahul Challapalli created DRILL-2344:
----------------------------------------

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