Skip to content

Instantly share code, notes, and snippets.

@vithalsamp

vithalsamp/Impala rename view.sql

Created February 25, 2018 17:09
Show Gist options
  • Save vithalsamp/8e10492cc133ff86df49c889f861da44 to your computer and use it in GitHub Desktop.
Save vithalsamp/8e10492cc133ff86df49c889f861da44 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Impala rename view.sql
Query: alter VIEW action_movies RENAME TO comedy_movie ;
[quickstart.cloudera:21000] > select * from comedy_movie;
Query: select * from comedy_movie
+-------+-------+--------+----------+
| code | title | kind | len |
+-------+-------+--------+----------+
| C_107 | Bean | Comedy | 01:37:00 |
| C_106 | MIB | Comedy | 01:31:00 |
+-------+-------+--------+----------+
Fetched 2 row(s) in 2.37s
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment