Setup as in this issue #1208
IN should be fixed together with JOINS #1209.
SELECT * FROM hybrid_table_64293f1a_0cba_11f1_876b_de7b9eea3490 WHERE string_col IN (SELECT DISTINCT string_col FROM merge_tree_table_640a9b6e_0cba_11f1_876b_de7b9eea3490 WHERE long_col > 1500);
In output there are some rows from the table along with exception:
Code: 60. DB::Exception: Received from localhost:9000. DB::Exception: Received from clickhouse2:9000. DB::Exception: Unknown table expression identifier 'default.merge_tree_table_640a9b6e_0cba_11f1_876b_de7b9eea3490' in scope (SELECT DISTINCT __table1.string_col AS string_col FROM default.merge_tree_table_640a9b6e_0cba_11f1_876b_de7b9eea3490 AS __table1 WHERE __table1.long_col > 1500). (UNKNOWN_TABLE)