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
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.