Hive receipts

hive-receipts

# Overwrite non-partitioned table with their own contents
CREATE table xx_COPY LIKE xx;

INSERT OVERWRITE TABLE xx 
SELECT * FROM xx

# Overwrite partitioned table with their own contents
CREATE table xx_COPY LIKE xx;

SHOW PARTITIONS ABC;

## for each partition:
INSERT OVERWRITE ABC_COPY PARTITION(partkey = "$partkey")
SELECT `(partkey)?+.+` FROM ABC WHERE partkey = "$partkey";

# Count rows
SELECT COUNT(*)
FROM xx