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

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Not A Problem
• Fix Version/s: 0.9.0
• Component/s: Client - JDBC
• Assignee: Daniel Barclay
• Reporter: Rahul Kumar Challapalli
• Created: 27/Feb/15 23:33
• Updated: 07/Apr/15 22:55
• Resolved: 07/Apr/15 22:55

Description

git.commit.id.abbrev=02d23cb

I am trying to get the tables from drill using the below code and drill never returns

DatabaseMetaData meta = conn.getMetaData();
ResultSet rs = meta.getTables(null, null, null, new String[] {"VIEW"});
System.out.println("Drill does not get to this point");

Below is the underlying query which drill issues from withing the getTables() method.

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 

When I tried to manually run this query, sqlline never returned