blob: b6298b986408e00c0e912c7d55da2b078f36772a [file] [log] [blame]
alter session set `planner.enable_hashjoin` = false;
select
o.int_col, o.bigint_col, o.date_col, o.time_col, o.timestamp_col, o.interval_col, o.varchar_col, o.float_col, o.double_col, o.bool_col,
p.int_col, p.bigint_col, p.date_col, p.time_col, p.timestamp_col, p.interval_col, p.varchar_col, p.float_col, p.double_col, p.bool_col
from dfs.`cross-sources`.`fewtypes.parquet` p
inner join dfs.`cross-sources`.`fewtypes_null.json` o
on p.int_col=o.int_col
and p.bigint_col = o.bigint_col
and p.date_col = cast(o.date_col as date)
and p.time_col = cast(o.time_col as time)
and p.timestamp_col = cast(o.timestamp_col as timestamp)
and p.interval_col = o.interval_col
and p.varchar_col = o.varchar_col
and p.float_col = cast(o.float_col as float)
and p.double_col = o.double_col
and p.bool_col = o.bool_col;
alter session set `planner.enable_hashjoin` = true;