Skip to content

Instantly share code, notes, and snippets.

@boristyukin

boristyukin/impala_command_drop_database_tables.sh

Created March 23, 2019 01:41
Show Gist options
  • Save boristyukin/a594a323472d8aa5bef55608adf96cc2 to your computer and use it in GitHub Desktop.
Save boristyukin/a594a323472d8aa5bef55608adf96cc2 to your computer and use it in GitHub Desktop.
Download ZIP
How to drop all Impala tables in a given database
Raw
impala_command_drop_database_tables.sh
impala-shell -d mydbname -q 'show tables' -B | xargs -I '{}' impala-shell -d mydbname -q 'DROP TABLE IF EXISTS `{}`;'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment