| set hive.mapred.mode=nonstrict; |
| set hive.explain.user=false; |
| |
| create table t1_n97 (v string, k int); |
| insert into t1_n97 values ('people', 10), ('strangers', 20), ('parents', 30); |
| |
| create table t2_n60 (v string, k double); |
| insert into t2_n60 values ('people', 10), ('strangers', 20), ('parents', 30); |
| |
| -- should not produce exceptions |
| explain |
| select * from t1_n97 where t1_n97.k in (select t2_n60.k from t2_n60 where t2_n60.v='people') and t1_n97.k<15; |
| |
| select * from t1_n97 where t1_n97.k in (select t2_n60.k from t2_n60 where t2_n60.v='people') and t1_n97.k<15; |
| |
| |