zaratsian/apache_hive

Apache Hive (SQL on Hadoop) Syntax, Cheatsheet, and Projects

  Hive Syntax & Projects

Commands:

show databases;
show tables;

describe formatted test_table;
describe formatted test_table partition (my_column='my_value');

CREATE TABLE test_table (name VARCHAR(64), age INT, rating DECIMAL(3, 2));

INSERT INTO TABLE test_table VALUES ('frank', 33, 9.28), ('dean', 35, 8.32);


Beeline:
beeline -u jdbc:hive2://localhost:10000/default -n username -w password_file
!connect jdbc:hive2://localhost:10015
HiveServer2 Clients - Beeline


Simple Example - Create Hive Table and Insert Records


References:
Hortonworks hive Cheatsheet