Hi,
We have an use case to refactor query from postgreSQL to Hive as we are moving to Hadoop.
HDP-2.5.0 installed and all the data have been moved to Hive. Next we are changing the queries. In the existing postgres function we have an update of data as below. How can I refactor that for Hive ? Looking for your guidance to accomplish this.
update pricing_reporting_final b
set coverage_type=a.X_GEHC_COVERAGE_TYPE from
(
select invc_num,X_GEHC_COVERAGE_TYPE from pricing_reporting_final
where x_trx_cd='Invoice' group by 1,2) a
where a.invc_num=b.Original_Invoice_Num
and b.x_trx_cd in ('Rebill','Credit Memo');