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

Hive metastore doesn’t support stats on container types

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 2.3.6
    • None
    • SQL
    • None

    Description

      hive> CREATE TABLE `test_map_text`(`id` string,`score` map<string,int>) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' WITH SERDEPROPERTIES ( 'colelction.delim'=',','field.delim'='|','mapkey.delim'=':','serializaion.format'='|') STORED AS TEXTFILE;
      hive> LOAD DATA INPATH '/tmp/map.text' INTO TABLE test_map.text;
      This is my test_map.txt at HDFS location
      1|Math:90,English:89
      2|Math:88,English:90
      3|Math:93,English:93
      hive> analyze table test_map_text compute statistics for columns;
      hive> desc formatted test_map_text score;
      OK

      1. col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment

      score map<string,int> from deserializer
      COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"id\":\"true\"}}
      Time taken: 0.053 seconds, Fetched: 4 row(s)

      Attachments

        Activity

          People

            Unassigned Unassigned
            abhishek.akg ABHISHEK KUMAR GUPTA
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: