Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-2204

unable to get column names for a specific table that has '_' as part of its table name

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 0.8.0
    • Fix Version/s: 0.8.0
    • Component/s: JDBC
    • Labels:
      None
    • Hadoop Flags:
      Reviewed

      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.

        Attachments

          Activity

            People

            • Assignee:
              phunt Patrick Hunt
              Reporter:
              mgk.424@gmail.com Mythili Gopalakrishnan
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: