[jira] [Commented] (HIVE-6719) No results from getTables() and getColumns with null tableNamePattern

["Rick Spickelmier (JIRA)" <ji...@apache.org>]

    [ 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)