> ) t_result where formable = ’t1' … > This sql using 29+ hours in 11 computers cluster within 600G memory. > In my opinion, the time wasting in the `order by sampledate` and `calculate > the table B’s record`. Is there a setting to avoid `table B`’s record not to > get ‘avg_wfoy_b2’ column, in the `t_result` will filter 'formable = ’t1’'
> hive(1.2.0) https://issues.apache.org/jira/browse/HIVE-12808 + https://issues.apache.org/jira/browse/HIVE-16797 These are the relevant fixes for the issue you're looking into, both went into hive 2.x branches. Since you have nested queries for OVER() clauses, you might also need this un-committed patch https://issues.apache.org/jira/browse/HIVE-17668 Cheers, Gopal
