ql/src/test/queries/clientpositive/truncate_column_buckets.q

--! qt:dataset:src
set hive.mapred.mode=nonstrict;
-- Tests truncating columns from a bucketed table, table should remain bucketed

CREATE TABLE test_tab (key STRING, value STRING) CLUSTERED BY (key) INTO 2 BUCKETS STORED AS RCFILE;



INSERT OVERWRITE TABLE test_tab SELECT * FROM src;

-- Check how many rows there are in each bucket, there should be two rows
SELECT cnt FROM (
SELECT INPUT__FILE__NAME file_name, count(*) cnt FROM 
test_tab GROUP BY INPUT__FILE__NAME
)a ORDER BY file_name DESC;

-- Truncate a column on which the table is not bucketed
TRUNCATE TABLE test_tab COLUMNS (value);

-- Check how many rows there are in each bucket, this should produce the same rows as before
-- because truncate should not break bucketing
SELECT cnt FROM (
SELECT INPUT__FILE__NAME file_name, count(*) cnt FROM 
test_tab GROUP BY INPUT__FILE__NAME
)a ORDER BY file_name DESC;