How to drop all tables in hive at a time in a linux environment ? | Java2bigdata

Tuesday, 22 March 2016

How to drop all tables in hive at a time in a linux environment ?

Use the following to delete all the tables in a linux environment.

hive -e 'show tables' | xargs -I '{}' hive -e 'drop table {}'

1 comment:

Tejuteju8 June 2018 at 00:27
Thank you.Well it was nice post and very helpful information on Big data hadoop online training Hyderabad
ReplyDelete
Replies

Subscribe to: Post Comments (Atom)