HiveProject(p_dt=[$1]) HiveJoin(condition=[=($1, $2)], joinType=[inner], algorithm=[none], cost=[not available]) HiveJoin(condition=[=($1, $0)], joinType=[inner], algorithm=[none], cost=[not available]) HiveProject($f0=[$0]) HiveAggregate(group=[{0}]) HiveProject($f0=[translate(CAST(TO_DATE(DATE_SUB(_UTF-16LE'2022-08-01':VARCHAR(2147483647) CHARACTER SET "UTF-16LE", 1))):VARCHAR(2147483647) CHARACTER SET "UTF-16LE", _UTF-16LE'-':VARCHAR(2147483647) CHARACTER SET "UTF-16LE", _UTF-16LE'':VARCHAR(2147483647) CHARACTER SET "UTF-16LE")]) HiveFilter(condition=[=($1, translate(CAST(TO_DATE(DATE_SUB(_UTF-16LE'2022-08-01':VARCHAR(2147483647) CHARACTER SET "UTF-16LE", 1))):VARCHAR(2147483647) CHARACTER SET "UTF-16LE", _UTF-16LE'-':VARCHAR(2147483647) CHARACTER SET "UTF-16LE", _UTF-16LE'':VARCHAR(2147483647) CHARACTER SET "UTF-16LE"))]) HiveTableScan(table=[[default, table_a]], table:alias=[table_a]) HiveProject($f0=[$0]) HiveAggregate(group=[{0}]) HiveProject($f0=[translate(CAST(TO_DATE(DATE_SUB(_UTF-16LE'2022-08-01':VARCHAR(2147483647) CHARACTER SET "UTF-16LE", 1))):VARCHAR(2147483647) CHARACTER SET "UTF-16LE", _UTF-16LE'-':VARCHAR(2147483647) CHARACTER SET "UTF-16LE", _UTF-16LE'':VARCHAR(2147483647) CHARACTER SET "UTF-16LE")]) HiveFilter(condition=[=($1, translate(CAST(TO_DATE(DATE_SUB(_UTF-16LE'2022-08-01':VARCHAR(2147483647) CHARACTER SET "UTF-16LE", 1))):VARCHAR(2147483647) CHARACTER SET "UTF-16LE", _UTF-16LE'-':VARCHAR(2147483647) CHARACTER SET "UTF-16LE", _UTF-16LE'':VARCHAR(2147483647) CHARACTER SET "UTF-16LE"))]) HiveTableScan(table=[[default, table_b]], table:alias=[table_b]) HiveProject($f0=[$0]) HiveAggregate(group=[{0}]) HiveProject($f0=[translate(CAST(TO_DATE(DATE_SUB(_UTF-16LE'2022-08-01':VARCHAR(2147483647) CHARACTER SET "UTF-16LE", 1))):VARCHAR(2147483647) CHARACTER SET "UTF-16LE", _UTF-16LE'-':VARCHAR(2147483647) CHARACTER SET "UTF-16LE", _UTF-16LE'':VARCHAR(2147483647) CHARACTER SET "UTF-16LE")]) HiveFilter(condition=[=($1, translate(CAST(TO_DATE(DATE_SUB(_UTF-16LE'2022-08-01':VARCHAR(2147483647) CHARACTER SET "UTF-16LE", 1))):VARCHAR(2147483647) CHARACTER SET "UTF-16LE", _UTF-16LE'-':VARCHAR(2147483647) CHARACTER SET "UTF-16LE", _UTF-16LE'':VARCHAR(2147483647) CHARACTER SET "UTF-16LE"))]) HiveTableScan(table=[[default, table_a]], table:alias=[table_a])