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);
Copyright ©2022 coderraj.com. All Rights Reserved.