Hive create view example.sql

Query: create VIEW action_movies AS 
 SELECT * 
 FROM films 
 WHERE kind = 'Action' 
Fetched 0 row(s) in 0.17s 

-- now check the output

[quickstart.cloudera:21000] > select * from action_movies; 
Query: select * from action_movies 
+-------+-----------+--------+----------+ 
| code | title | kind | len | 
+-------+-----------+--------+----------+ 
| C_103 | Globe2 | Action | 01:30:00 | 
| C_105 | Globe4 | Action | 01:37:00 | 
| C_102 | Globe1 | Action | 01:40:00 | 
| C_104 | Globe3 | Action | 01:36:00 | 
| C_101 | Globe | Action | 01:30:00 | 
| C_701 | GoldenEye | Action | 01:36:00 | 
+-------+-----------+--------+----------+ 
Fetched 6 row(s) in 2.03s