Hive Operations with Cloudera Authentication

This example demonstrates creating the DROP, CREATE, INSERT, and SELECT queries in the Hive database using the Hive - Execute Snap authenticated against the Cloudera Data Platform through the Generic Hive Database Account .



Prerequisites

Configure the Generic Hive Database Account as follows:



Configure the Hive - Execute Snaps as shown in the table below to create queries in the following order and validate the pipeline afterward:

Query Configuration Output

DROP query

The following query drops Doc_demo table from the database.

DROP TABLE Doc_demo



CREATE query:

The following query creates a table:

CREATE TABLE IF NOT EXISTS Doc_demo(ID INT,NAME STRING,AGE INT,ADDRESS STRING,SALARY INT)
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','



INSERT query:

The following query inserts the records of the members into the Doc_demo table:


INSERT INTO Doc_demo VALUES 
(1, 'Ramesh', 32, 'Ahmedabad', 2000.00 ), 
(2, 'Khilan', 25, 'Delhi', 1500.00 ),
(3, 'kaushik', 23, 'Kota', 2000.00 ), 
(4, 'Chaitali', 25, 'Mumbai', 6500.00 ),
(5, 'Hardik', 27, 'Bhopal', 8500.00 ), 
(6, 'Komal', 22, 'MP', 4500.00 )



SELECT query:

The following query retrieves all records from Doc_demo table:

Select * from Doc_demo