hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mythili Gopalakrishnan (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-2204) unable to get column names for a table that has '_' as part of its table name
Date Wed, 08 Jun 2011 08:15:59 GMT

     [ https://issues.apache.org/jira/browse/HIVE-2204?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Mythili Gopalakrishnan updated HIVE-2204:
-----------------------------------------

    Description: 
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.

  was:
I have a table age_group and I am trying to get list of columns for this table name. As '_'
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. 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 table name, I am able to get the list of columns.


> unable to get column names for a 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
>
> 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

Mime
View raw message