CREATE TABLE part( | |
p_partkey INT, | |
p_name STRING, | |
p_mfgr STRING, | |
p_brand STRING, | |
p_type STRING, | |
p_size INT, | |
p_container STRING, | |
p_retailprice DOUBLE, | |
p_comment STRING | |
); | |
LOAD DATA LOCAL INPATH '${hiveconf:test.data.dir}/tpch/tiny/part.tbl.bz2' overwrite into table part; | |
analyze table part compute statistics; | |
analyze table part compute statistics for columns; |