How hive replaces in subquery with left semi join

Execute the following hive sql:

SELECT * from Trackinfo where ds= $date and session_id in (select session_id from Rcmd_track_path where ds= $date and Add_ca Rt_flag>0 and Product_id>0);</span>

The following error is indicated:

Failed:parseexception line 2:39 cannot recognize input near ' select ' session_id "from" in expression specification

Cause analysis & solutions are as follows:

Hive does not support the use of in subqueries, consider replacing in with the left semi join, overwriting the above hive SQL as follows:

SELECT * from Trackinfo T1 left semi joins Rcmd_track_path T2 on (t1.session_id=t2.session_id and T2.add_cart_flag>0 and T2.product_id>0 and t1.ds= $date and t2.ds= $date);

Left semi Join usage reference: Https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Joins

How hive replaces in subquery with left semi join