[
https://issues.apache.org/jira/browse/HIVE-6719?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13943374#comment-13943374
]
Rick Spickelmier commented on HIVE-6719:
----------------------------------------
For getColumns, the issue is with the columnNamePattern. Specifying "%" in
both methods produces the expected results, but specifying null returns a
result set with 0 records. The specification says that if null is used, the
parameter will not be used in the search (which should be the equivalent of
"%"), which is what most other JDBC drivers do.
Squirrel does not show the catalog and I assume it is due to this.
> No results from getTables() and getColumns with null tableNamePattern
> ---------------------------------------------------------------------
>
> Key: HIVE-6719
> URL: https://issues.apache.org/jira/browse/HIVE-6719
> Project: Hive
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 0.12.0
> Reporter: Jonathan Seidman
>
> Calling DatabaseMetaData.getTables() or getColumns() with a nullĀ
> tableNamePattern argument returns 0 results, counter to the JDBC spec.
> For example, the following will return no results:
> meta.getTables( null, schema, null , tableTypes);
--
This message was sent by Atlassian JIRA
(v6.2#6252)