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

Cannot retrieve column statistics using HMS API if column name contains uppercase characters

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 0.13.1
    • Fix Version/s: 1.2.0
    • Component/s: Metastore, Statistics
    • Labels:
      None

      Description

      The issue only happens on avro table,

      CREATE TABLE t2_avro (
      columnNumber1 int,
      columnNumber2 string )
      PARTITIONED BY (p1 string)
      ROW FORMAT SERDE 
        'org.apache.hadoop.hive.serde2.avro.AvroSerDe' 
      STORED AS INPUTFORMAT 
        'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat' 
      OUTPUTFORMAT 
        'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat'
      TBLPROPERTIES(
      'avro.schema.literal'='{
      "namespace": "testing.hive.avro.serde",
      "name": "test",
      "type": "record",
      "fields": [
      { "name":"columnNumber1", "type":"int" },
      { "name":"columnNumber2", "type":"string" }
      ]}');
      

      I don't have latest hive so I am not sure if this is already fixed in trunk.

        Attachments

        1. HIVE-9620.patch
          4 kB
          Chaoyu Tang
        2. HIVE-9620.1.patch
          4 kB
          Chaoyu Tang

          Activity

            People

            • Assignee:
              ctang Chaoyu Tang
              Reporter:
              jyu@cloudera.com Juan Yu
            • Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: