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

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 0.13.1
    • 1.2.0
    • Metastore, Statistics
    • 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.1.patch
          4 kB
          Chaoyu Tang
        2. HIVE-9620.patch
          4 kB
          Chaoyu Tang

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: