HIVE VIEW

HIVE

DataBase Introduction

Table Operation

hive buit in operation

Hive Partition By _and _buecketing

Hive Partition By

HIVE VIEW

HiveQl_Part1

Hive_Built_In_Functions

Hive_QL_JOIN

Hive_Table_Operation

HIVE VIEW

1.) Views Views are used for creating virtual tables. They are faster than creating actual tables and they can work as table while using them in any other query. For example precipitation view can be made as follows and can be used in other query just like a table is used. a.) CREATE VIEW test_data SELECT * FROM ORDERS WHERE CUSTOMER_ID IS NOT NULL AND AMOUNT>10;