Hive table record filter

hive

#1

if i have a table in hive which contain nearly 20000000 record . what is the best and easy way to filter 1000 record or copy 1000 record from hive table and save it on local node/machine in text file


#2

You can do couple of things …

beeline -u --header=false --incremental=true -e “select * from table limit 1000” >> file.txt

file.txt will be created in your local.

alternatively , your can do insert overwrite local.

Thanks,