Try,
select a.* from tmp_source_fs_price1 a join ( select
fund_id,nav_date,CURRENCY,nav,count(1) from tmp_source_fs_price1 group by
fund_id,nav_date,CURRENCY,nav having count(1) > 1) b on a.fund_id =
b.fund_id ;
The grammar you've mentioned is not supported in hive-0.11.0 (hive-0.13.0,
by HIVE-6
Hi Team,
I am looking for to get duplicate records with in the table (using hive
version : 0.11.0 ) .
Below is my query : select a.* from tmp_source_fs_price1 a, ( select
fund_id,nav_date,CURRENCY,nav,count(1) from tmp_source_fs_price1 group by
fund_id,nav_date,CURRENCY,nav having count(1) >
