ql/src/test/queries/positive/sample7.q - hive - Git at Google

 -- both input pruning and sample filter
 INSERT OVERWRITE TABLE dest1 SELECT s.*
 FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 4 on key) s
 WHERE s.key > 100
	-- both input pruning and sample filter
	INSERT OVERWRITE TABLE dest1 SELECT s.*
	FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 4 on key) s
	WHERE s.key > 100