You can find someone having the same problem here and the corresponding JIRA ticket.
Based on those answers, I would advise you to try :
Select a,b,c from t1 where a in (0,100) AND t1.b in (select b from t2 where d>2 GROUP BY 1 ) LIMIT 1;
It is because you have b in both queries, the main one and the inner within the in statement. To fix it you have to explicitly tell hive to which b you're referring to. That's why changing it to t1.b solves it.