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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.8.0
• Fix Version/s: 0.8.0
• Component/s: JDBC
• Hadoop Flags: Reviewed
• Assignee: Patrick D. Hunt
• Reporter: Mythili Gopalakrishnan
• Created: 07/Jun/11 13:21
• Updated: 16/Dec/11 23:56
• Resolved: 14/Jul/11 18:08

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.