Hive DML Commands

Apache Hive DML commands for beginners and professionals with examples on hive, pig, hbase, hdfs, mapreduce, oozie, zooker, spark, sqoop

To understand the Hive DML commands, let's see the employee and employee_department table first.

LOAD DATA

hive> LOAD DATA LOCAL INPATH './usr/Desktop/kv1.txt' OVERWRITE INTO TABLE Employee;

SELECTS and FILTERS

hive> SELECT  E.EMP_ID FROM Employee E  WHERE E.Address='US';

GROUP BY

hive> hive> SELECT  E.EMP_ID FROM Employee E GROUP BY E.Addresss;

.NET Array Dictionary List String 2D Async DataTable Dates DateTime Enum File For Foreach Format IEnumerable If IndexOf Lambda LINQ Parse Path Process Property Regex Replace Sort Split Static StringBuilder Substring Switch Tuple

Core Array ArrayList HashMap String 2D Cast Character Console Deque Duplicates File For Format HashSet If IndexOf Lambda Math ParseInt Process Random Regex Replace Sort Split StringBuilder Substring Switch Vector While

TheDeveloperBlog.com