| drop table if exists temp_tab; | |
| create TEMPORARY table temp_tab as select '12312' as c2; | |
| drop table if exists dfs.drillTestDir.pers_tab; | |
| create table dfs.drillTestDir.pers_tab as select '12312' as c1; | |
| --@test | |
| select * from dfs.drillTestDir.`pers_tab` a join `temp_tab` b on a.c1 = b.c2; |