HiveAggregate(group=[{}], agg#0=[count()])
HiveFilter(condition=[AND(OR(IS NULL($4), =($1, 0)), OR(IS NOT NULL($0), =($1, 0), IS NOT NULL($4)), OR(>=($2, $1), =($1, 0), IS NOT NULL($4), IS NULL($0)))])
HiveProject(p_partkey=[$0], c=[$3], ck=[$4], p_partkey0=[$1], i826=[$2])
HiveJoin(condition=[true], joinType=[inner], algorithm=[none], cost=[{27.0 rows, 0.0 cpu, 0.0 io}])
HiveJoin(condition=[=($0, $1)], joinType=[left], algorithm=[none], cost=[{51.0 rows, 0.0 cpu, 0.0 io}])
HiveProject(p_partkey=[$0])
HiveTableScan(table=[[qtest, part]], table:alias=[part])
HiveProject(p_partkey=[$0], i826=[true])
HiveAggregate(group=[{0}])
HiveFilter(condition=[IS NOT NULL($0)])
HiveTableScan(table=[[qtest, part]], table:alias=[part])
HiveProject(c=[$0], ck=[$1])
HiveAggregate(group=[{}], c=[COUNT()], ck=[COUNT($0)])
HiveTableScan(table=[[qtest, part]], table:alias=[part])