Hive Tutorials

By | April 17, 2017

Hive Tutorials

I highly recommend everyone to buy and read the book to get clear theoretical knowledge about the Hive. You can find book below.

This short tutorial will explain you how to create table in Hive, how to import data into hive table. For more advanced hive create table commands please refer my further hive tutorials. I hope your hive is already up and running.

Creating table in Hive

CREATE TABLE myHiveTable (rawData STRING);

Loading or inserting data into Hive table                                                             

LOAD DATA INPATH ‘rawDataFile.txt’ OVERWRITE INTO TABLE myHiveTable;

Reading or selecting records from Hive table

SELECT * FROM myHiveTable;

Deleting or drop table in Hive

DROP TABLE myHiveTable;