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)
