Home >> Big Data Hadoop >> Hive Joins cont in Big Data Hadoop

Hive Joins cont in Big Data Hadoop

Outer Joins:

LEFT, RIGHT, and FULL OUTER joins exist in hive order to provide more control over ON clauses for which there is no match.

SELECT a.val, b.val FROM a LEFT OUTER JOIN b ON (a.key=b.key)

SELECT a.val, b.val FROM a RIGHT OUTER JOIN b ON (a.key=b.key)

select distinct control.job_date,error.job_date,control.table_name,error.table_name,control.process_id,error.process_id,control.state,control.job_name,error.job_name,error.type,error.origin,error.message,case when error.process_id is null then 'pass' else 'fail' end as  status,files('deleted_file')as deleted,files('table_data')as table_data,files('Reject_file')as reject_file from control_table_int control FULL OUTER join error_table_int error on(control.process_id=error.process_id);

 

Post Your Comment

Next Questions
Hive Built-in Operators
Hive Data Types
Hive Built-in Functions
Hive Explode
Hive SORT BY vs ORDER By
HIve DISTRIBUTE BY vs CLUSTER BY
Hive HUE Editor
Hive vs Impala
Hive Data & Schema
Hive Partitioning
Hive Bucketing
Hive File Format
Hive Engine
Hive Vectorization
Hive User Defined Function
Hive How to Write a User Defined Function
Hive User Defined Aggregate Functions
Hive Performance Tuning
Hive Rank and Over
Hive SERDE
Hive Directed Acyclic Graph
Hive with Sqoop
How to save hive query output in csv using python
Hive How To Convert External table to Internal table or vice-versa
Hive What is User Defined Function and User Defined Aggregate Function

Copyright ©2022 coderraj.com. All Rights Reserved.