CREATE TABLE claims(claim_rec_id bigint, claim_invoice_num string, typ_c int); | |
ALTER TABLE claims UPDATE STATISTICS set ('numRows'='1154941534','rawDataSize'='1135307527922'); | |
SET hive.stats.estimate=false; | |
EXPLAIN EXTENDED SELECT count(1) FROM claims WHERE typ_c=3; | |
SET hive.stats.ndv.estimate.percent=5e-7; | |
EXPLAIN EXTENDED SELECT count(1) FROM claims WHERE typ_c=3; |