| set hive.stats.dbclass=fs; |
| -- |
| -- Table src |
| -- |
| DROP TABLE IF EXISTS src; |
| |
| CREATE TABLE src (key STRING COMMENT 'default', value STRING COMMENT 'default') STORED AS TEXTFILE; |
| |
| LOAD DATA LOCAL INPATH "${hiveconf:test.data.dir}/kv1.txt" INTO TABLE src; |
| |
| ANALYZE TABLE src COMPUTE STATISTICS; |
| |
| ANALYZE TABLE src COMPUTE STATISTICS FOR COLUMNS key,value; |
| |
| -- |
| -- Table src_thrift |
| -- |
| DROP TABLE IF EXISTS src_thrift; |
| |
| CREATE TABLE src_thrift |
| ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.thrift.ThriftDeserializer' |
| WITH SERDEPROPERTIES ( |
| 'serialization.class' = 'org.apache.hadoop.hive.serde2.thrift.test.Complex', |
| 'serialization.format' = 'org.apache.thrift.protocol.TBinaryProtocol') |
| STORED AS SEQUENCEFILE; |
| |
| LOAD DATA LOCAL INPATH "${hiveconf:test.data.dir}/complex.seq" INTO TABLE src_thrift; |
| |
| ANALYZE TABLE src_thrift COMPUTE STATISTICS; |