Hive bucketing

[#1]

i have 4 buckets in a hive table

is it possible to pull the records from 2nd and 3rd bucket at the same time

[#2]

Hi,

Can you try with below command:

select * from bucketing_table tablesample(bucket n out of y on clustered_criteria_column);

n => nth bucket

y => total no. of buckets