You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "ABHISHEK KUMAR GUPTA (Jira)" <ji...@apache.org> on 2020/02/07 04:33:00 UTC
[jira] [Created] (HIVE-22846) Hive metastore doesn’t support stats on container types
ABHISHEK KUMAR GUPTA created HIVE-22846:
-------------------------------------------
Summary: Hive metastore doesn’t support stats on container types
Key: HIVE-22846
URL: https://issues.apache.org/jira/browse/HIVE-22846
Project: Hive
Issue Type: Bug
Components: SQL
Affects Versions: 2.3.6
Reporter: ABHISHEK KUMAR GUPTA
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
# 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)
--
This message was sent by Atlassian Jira
(v8.3.4#803005)