[
https://issues.apache.org/jira/browse/DRILL-2344?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14353995#comment-14353995
]
Rahul Challapalli commented on DRILL-2344:
------------------------------------------
The moment I disabled hbase storage plugin, the query worked. So for some
reason hbase and information_schema do not go well
> 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)
