Re: Filters with IN clause are getting omitted

Not solution to the problem on HDP 2.6.5, but I have tested the first script in Hive 2.3.4 and Hive 3.1.1. On Hive 2.3.4, it returns 1 row, and on Hive 3.1.1, it returns no row. So, I guess the bug is still in HDP 2.6.5. --- Sungwoo On Tue, Apr 23, 2019 at 7:40 PM Rajat Khandelwal wrote: > Hi

Filters with IN clause are getting omitted

Hi I've recently noticed incorrect behaviour from Hive Query Planner. The simplest example I could construct is as follows SELECT tbl3.col2 AS current_regularity_streak FROM (select 1 col1) tbl1 LEFT JOIN (select 1 col1) tbl2 ON tbl1.col1 = tbl2.col1 LEFT JOIN (select 1 col1, 1 col2) tbl3 ON

Quesition about window function

Dears, when using window function, is there any difference between ' range between unbounded preceding and unbounded following' and 'rows between unbounded preceding and unbounded folllowing'? Thanks! Regards, Zhiyu Sun