โโ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
pritraj90 / apache_hive Goto Github PK
View Code? Open in Web Editor NEWThis project forked from zaratsian/apache_hive
Apache Hive (SQL on Hadoop) Syntax, Cheatsheet, and Projects