Skip to content

Instantly share code, notes, and snippets.

@nsabharwal
Created November 21, 2015 03:18
Show Gist options
  • Save nsabharwal/ae2317e1bec173f6cdb6 to your computer and use it in GitHub Desktop.
Save nsabharwal/ae2317e1bec173f6cdb6 to your computer and use it in GitHub Desktop.
mysql -u hive -p -e " select concat( 'show create table ' , TBL_NAME,';') from TBLS" hive > file.sql
hive -f /tmp/file.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment