You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "jiraposter@reviews.apache.org (JIRA)" <ji...@apache.org> on 2011/07/14 07:26:02 UTC

[jira] [Commented] (HIVE-2204) unable to get column names for a specific table that has '_' as part of its table name

    [ https://issues.apache.org/jira/browse/HIVE-2204?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13065055#comment-13065055 ] 

jiraposter@reviews.apache.org commented on HIVE-2204:
-----------------------------------------------------


-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/1106/
-----------------------------------------------------------

Review request for hive and Carl Steinbach.


Summary
-------

Added additional handling for escaped wildcards.


This addresses bug HIVE-2204.
    https://issues.apache.org/jira/browse/HIVE-2204


Diffs
-----

  jdbc/src/java/org/apache/hadoop/hive/jdbc/HiveDatabaseMetaData.java d1ff509 
  jdbc/src/test/org/apache/hadoop/hive/jdbc/TestJdbcDriver.java 591fa1f 

Diff: https://reviews.apache.org/r/1106/diff


Testing
-------

added new tests, all tests pass for me.


Thanks,

Patrick



> unable to get column names for a specific table that has '_' as part of its table name
> --------------------------------------------------------------------------------------
>
>                 Key: HIVE-2204
>                 URL: https://issues.apache.org/jira/browse/HIVE-2204
>             Project: Hive
>          Issue Type: Bug
>          Components: JDBC
>    Affects Versions: 0.8.0
>            Reporter: Mythili Gopalakrishnan
>            Assignee: Patrick Hunt
>         Attachments: HIVE-2204.patch
>
>
> I have a table age_group and I am trying to get list of columns for this table name. As underscore and '%' have special meaning in table search pattern according to JDBC searchPattern string specification, I escape the '_' in my table name when I call getColumns for this single table. But HIVE does not return any columns. My call to getColumns is as follows
> catalog	<null>
> schemaPattern	"%"
> tableNamePattern  "age\_group"
> columnNamePattern  "%"
> If I don't escape the '_' in my tableNamePattern, I am able to get the list of columns.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira