You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Mythili Gopalakrishnan (JIRA)" <ji...@apache.org> on 2011/06/07 15:21:58 UTC
[jira] [Created] (HIVE-2204) unable to get column names for a table
that has '_' as part of its table name
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 '_' 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.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-2204) unable to get column names for a table
that has '_' as part of its table name
Posted by "Mythili Gopalakrishnan (JIRA)" <ji...@apache.org>.
[ 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
[jira] [Updated] (HIVE-2204) unable to get column names for a
specific table that has '_' as part of its table name
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2204?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl Steinbach updated HIVE-2204:
---------------------------------
Fix Version/s: 0.8.0
> 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
> Fix For: 0.8.0
>
> 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
[jira] [Updated] (HIVE-2204) unable to get column names for a
specific table that has '_' as part of its table name
Posted by "Mythili Gopalakrishnan (JIRA)" <ji...@apache.org>.
[ 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 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.
Summary: unable to get column names for a specific table that has '_' as part of its table name (was: unable to get column names for a table that has '_' as part of its table name)
> 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
>
> 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
[jira] [Commented] (HIVE-2204) unable to get column names for a
specific table that has '_' as part of its table name
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2204?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13065101#comment-13065101 ]
Carl Steinbach commented on HIVE-2204:
--------------------------------------
+1. Will commit if tests pass.
> 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
[jira] [Updated] (HIVE-2204) unable to get column names for a
specific table that has '_' as part of its table name
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2204?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl Steinbach updated HIVE-2204:
---------------------------------
Resolution: Fixed
Hadoop Flags: [Reviewed]
Status: Resolved (was: Patch Available)
Committed to trunk. 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
[jira] [Updated] (HIVE-2204) unable to get column names for a
specific table that has '_' as part of its table name
Posted by "Patrick Hunt (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2204?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Patrick Hunt updated HIVE-2204:
-------------------------------
Status: Patch Available (was: Open)
> 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
[jira] [Commented] (HIVE-2204) unable to get column names for a
specific table that has '_' as part of its table name
Posted by "jiraposter@reviews.apache.org (JIRA)" <ji...@apache.org>.
[ 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
[jira] [Assigned] (HIVE-2204) unable to get column names for a
specific table that has '_' as part of its table name
Posted by "Patrick Hunt (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2204?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Patrick Hunt reassigned HIVE-2204:
----------------------------------
Assignee: Patrick Hunt
> 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
>
> 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
[jira] [Commented] (HIVE-2204) unable to get column names for a
specific table that has '_' as part of its table name
Posted by "Hudson (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2204?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13065597#comment-13065597 ]
Hudson commented on HIVE-2204:
------------------------------
Integrated in Hive-trunk-h0.21 #827 (See [https://builds.apache.org/job/Hive-trunk-h0.21/827/])
HIVE-2204. Unable to get column names for a specific table that has '_' as part of its table name (Patrick Hunt via cws)
cws : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1146828
Files :
* /hive/trunk/jdbc/src/java/org/apache/hadoop/hive/jdbc/HiveDatabaseMetaData.java
* /hive/trunk/jdbc/src/test/org/apache/hadoop/hive/jdbc/TestJdbcDriver.java
> 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
[jira] [Updated] (HIVE-2204) unable to get column names for a
specific table that has '_' as part of its table name
Posted by "Patrick Hunt (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2204?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Patrick Hunt updated HIVE-2204:
-------------------------------
Attachment: HIVE-2204.patch
Added handling of escaped wildcard characters. Also updated jdbc tests to verify.
> 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
[jira] [Updated] (HIVE-2204) unable to get column names for a table
that has '_' as part of its table name
Posted by "Mythili Gopalakrishnan (JIRA)" <ji...@apache.org>.
[ 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 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.
> 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