hive> use hiveql;
现在，使用以下命令创建表:
hive> create table employee(empid int, empname string , state string)
row format delimited
fields terminated by ',' ;
将相应的数据加载到表中。
hive> load data local inpath '/home/codegyani/hive/employee' into table employee;
现在，使用以下命令创建另一个表:
hive> create table employee_department(depid int, department_name string)
row format delimited
fields terminated by ',' ;
将相应的数据加载到表中。
hive> load data local inpath '/home/codegyani/hive/employee_department' into table employee_department;
现在，使用以下命令执行内部联接操作:-
hive>select e1.empname, e2.department_name from employee e1 join employee_department e2 on e1.empid= e2.depid;
hive> select e1.empname, e2.department_name from employee e1 left outer join employee_department e2 on e1.empid= e2.depid;
hive> select e1.empname, e2.department_name from employee e1 right outer join employee_department e2 on e1.empid= e2.depid;
select e1.empname, e2.department_name from employee e1 full outer join employee_department e2 on e1.empid= e2.depid;
