Hive and Hql

we also offer , online and classroom trainings

we support in POC

author: Bharat (sree ram)

contact : 04042026071

_______________________________________________________________

Hive & Hql

In hive the query language used is hql(hive query language)

Hive DDL Statements

                Create

                Alter

Drop

Hive DML Statements

                Insert

                Select

Create:

                Used to Create Database and tables and views.

Alter:

                Used to modify structure of hive tables such as changing data types and adding new columns etc.

Drop:

                To drop hive database,tables and views.

Insert: ( Only mass insertion available in hive)

                To copy data  from one table to another table.

Select:

                To select rows from hive tables or views.

Other Statements of HQL

                Union all

                 Joins etc..

Hive features:

Ø  Hive has string parsers to handle string and unstructured text data.

Ø  Hive has XML parsers to handle XML data.

Ø  Hive has json parsers to process json data.

Ø  Hive has URL parsers to make URL data structured.

Ø  Hive has serde feature,which is short from of serialization and deserialization.

Ex: HiveJsonserde

Ø  Hive has UDF(user defined function) feature) feature to develop custom frnctionalities.

Hive UDFs can be written in java,python,c++,ruby and r.