view – Programming & Mustangs!

Hive: Views

This tutorial will show you some common usage for creating views. If you have no installed Hive yet please follow this tutorial.

Create View:

CREATE VIEW IF NOT EXISTS test_view AS
SELECT * FROM test;

Drop View:

DROP VIEW IF EXISTS test_view;

To create a view is rather simple.

 CREATE OR REPLACE VIEW Audit.vw_Your_Table AS
      SELECT *
      FROM Your_table;

Comment on View:

 COMMENT ON VIEW Audit.vw_Your_Table IS 'Display the data';