Re: hive 3.1 mapjoin with complex predicate produce incorrect results

2018-12-22 Thread Gopal Vijayaraghavan
Hi, > Subject: Re: hive 3.1 mapjoin with complex predicate produce incorrect results ... > |                         0 if(_col0 is null, 44, _col0) (type: int) | > |                         1 _col0 (type: int)        | That rewrite is pretty neat, but I feel like the IF expression nesting is what

Re: hive 3.1 mapjoin with complex predicate produce incorrect results

2018-12-22 Thread Andrey Zinovyev
Hi, We use hive 3.1 from hdp 3.0.1 Here is explain output ++ | Explain | ++ | STAGE DEPENDENCIES:| | Stage-1 is a root