@@ -6457,10 +6457,9 @@ physical_plan
6457645702)--AggregateExec: mode=Final, gby=[], aggr=[count(Int64(1))]
6458645803)----CoalescePartitionsExec
6459645904)------AggregateExec: mode=Partial, gby=[], aggr=[count(Int64(1))]
6460- 05)--------ProjectionExec: expr=[]
6461- 06)----------FilterExec: substr(md5(CAST(value@0 AS Utf8View)), 1, 32) IN (SET) ([7f4b18de3cfeb9b4ac78c381ee2ad278, a, b, c])
6462- 07)------------RepartitionExec: partitioning=RoundRobinBatch(4), input_partitions=1
6463- 08)--------------LazyMemoryExec: partitions=1, batch_generators=[generate_series: start=1, end=100000, batch_size=8192]
6460+ 05)--------FilterExec: substr(md5(CAST(value@0 AS Utf8View)), 1, 32) IN (SET) ([7f4b18de3cfeb9b4ac78c381ee2ad278, a, b, c]), projection=[]
6461+ 06)----------RepartitionExec: partitioning=RoundRobinBatch(4), input_partitions=1
6462+ 07)------------LazyMemoryExec: partitions=1, batch_generators=[generate_series: start=1, end=100000, batch_size=8192]
64646463
64656464query I
64666465with test AS (SELECT substr(md5(i::text)::text, 1, 32) as needle FROM generate_series(1, 100000) t(i))
@@ -6485,10 +6484,9 @@ physical_plan
6485648402)--AggregateExec: mode=Final, gby=[], aggr=[count(Int64(1))]
6486648503)----CoalescePartitionsExec
6487648604)------AggregateExec: mode=Partial, gby=[], aggr=[count(Int64(1))]
6488- 05)--------ProjectionExec: expr=[]
6489- 06)----------FilterExec: substr(md5(CAST(value@0 AS Utf8View)), 1, 32) IN (SET) ([7f4b18de3cfeb9b4ac78c381ee2ad278, a, b, c])
6490- 07)------------RepartitionExec: partitioning=RoundRobinBatch(4), input_partitions=1
6491- 08)--------------LazyMemoryExec: partitions=1, batch_generators=[generate_series: start=1, end=100000, batch_size=8192]
6487+ 05)--------FilterExec: substr(md5(CAST(value@0 AS Utf8View)), 1, 32) IN (SET) ([7f4b18de3cfeb9b4ac78c381ee2ad278, a, b, c]), projection=[]
6488+ 06)----------RepartitionExec: partitioning=RoundRobinBatch(4), input_partitions=1
6489+ 07)------------LazyMemoryExec: partitions=1, batch_generators=[generate_series: start=1, end=100000, batch_size=8192]
64926490
64936491query I
64946492with test AS (SELECT substr(md5(i::text)::text, 1, 32) as needle FROM generate_series(1, 100000) t(i))
@@ -6513,10 +6511,9 @@ physical_plan
6513651102)--AggregateExec: mode=Final, gby=[], aggr=[count(Int64(1))]
6514651203)----CoalescePartitionsExec
6515651304)------AggregateExec: mode=Partial, gby=[], aggr=[count(Int64(1))]
6516- 05)--------ProjectionExec: expr=[]
6517- 06)----------FilterExec: substr(md5(CAST(value@0 AS Utf8View)), 1, 32) IN (SET) ([7f4b18de3cfeb9b4ac78c381ee2ad278, a, b, c])
6518- 07)------------RepartitionExec: partitioning=RoundRobinBatch(4), input_partitions=1
6519- 08)--------------LazyMemoryExec: partitions=1, batch_generators=[generate_series: start=1, end=100000, batch_size=8192]
6514+ 05)--------FilterExec: substr(md5(CAST(value@0 AS Utf8View)), 1, 32) IN (SET) ([7f4b18de3cfeb9b4ac78c381ee2ad278, a, b, c]), projection=[]
6515+ 06)----------RepartitionExec: partitioning=RoundRobinBatch(4), input_partitions=1
6516+ 07)------------LazyMemoryExec: partitions=1, batch_generators=[generate_series: start=1, end=100000, batch_size=8192]
65206517
65216518query I
65226519with test AS (SELECT substr(md5(i::text)::text, 1, 32) as needle FROM generate_series(1, 100000) t(i))
@@ -6541,10 +6538,9 @@ physical_plan
6541653802)--AggregateExec: mode=Final, gby=[], aggr=[count(Int64(1))]
6542653903)----CoalescePartitionsExec
6543654004)------AggregateExec: mode=Partial, gby=[], aggr=[count(Int64(1))]
6544- 05)--------ProjectionExec: expr=[]
6545- 06)----------FilterExec: substr(md5(CAST(value@0 AS Utf8View)), 1, 32) IN (SET) ([7f4b18de3cfeb9b4ac78c381ee2ad278, a, b, c])
6546- 07)------------RepartitionExec: partitioning=RoundRobinBatch(4), input_partitions=1
6547- 08)--------------LazyMemoryExec: partitions=1, batch_generators=[generate_series: start=1, end=100000, batch_size=8192]
6541+ 05)--------FilterExec: substr(md5(CAST(value@0 AS Utf8View)), 1, 32) IN (SET) ([7f4b18de3cfeb9b4ac78c381ee2ad278, a, b, c]), projection=[]
6542+ 06)----------RepartitionExec: partitioning=RoundRobinBatch(4), input_partitions=1
6543+ 07)------------LazyMemoryExec: partitions=1, batch_generators=[generate_series: start=1, end=100000, batch_size=8192]
65486544
65496545query I
65506546with test AS (SELECT substr(md5(i::text)::text, 1, 32) as needle FROM generate_series(1, 100000) t(i))
@@ -6569,10 +6565,9 @@ physical_plan
6569656502)--AggregateExec: mode=Final, gby=[], aggr=[count(Int64(1))]
6570656603)----CoalescePartitionsExec
6571656704)------AggregateExec: mode=Partial, gby=[], aggr=[count(Int64(1))]
6572- 05)--------ProjectionExec: expr=[]
6573- 06)----------FilterExec: substr(md5(CAST(value@0 AS Utf8View)), 1, 32) IN (SET) ([7f4b18de3cfeb9b4ac78c381ee2ad278, a, b, c])
6574- 07)------------RepartitionExec: partitioning=RoundRobinBatch(4), input_partitions=1
6575- 08)--------------LazyMemoryExec: partitions=1, batch_generators=[generate_series: start=1, end=100000, batch_size=8192]
6568+ 05)--------FilterExec: substr(md5(CAST(value@0 AS Utf8View)), 1, 32) IN (SET) ([7f4b18de3cfeb9b4ac78c381ee2ad278, a, b, c]), projection=[]
6569+ 06)----------RepartitionExec: partitioning=RoundRobinBatch(4), input_partitions=1
6570+ 07)------------LazyMemoryExec: partitions=1, batch_generators=[generate_series: start=1, end=100000, batch_size=8192]
65766571
65776572query I
65786573with test AS (SELECT substr(md5(i::text)::text, 1, 32) as needle FROM generate_series(1, 100000) t(i))
@@ -6599,10 +6594,9 @@ physical_plan
6599659402)--AggregateExec: mode=Final, gby=[], aggr=[count(Int64(1))]
6600659503)----CoalescePartitionsExec
6601659604)------AggregateExec: mode=Partial, gby=[], aggr=[count(Int64(1))]
6602- 05)--------ProjectionExec: expr=[]
6603- 06)----------FilterExec: substr(md5(CAST(value@0 AS Utf8View)), 1, 32) IS NOT NULL OR NULL
6604- 07)------------RepartitionExec: partitioning=RoundRobinBatch(4), input_partitions=1
6605- 08)--------------LazyMemoryExec: partitions=1, batch_generators=[generate_series: start=1, end=100000, batch_size=8192]
6597+ 05)--------FilterExec: substr(md5(CAST(value@0 AS Utf8View)), 1, 32) IS NOT NULL OR NULL, projection=[]
6598+ 06)----------RepartitionExec: partitioning=RoundRobinBatch(4), input_partitions=1
6599+ 07)------------LazyMemoryExec: partitions=1, batch_generators=[generate_series: start=1, end=100000, batch_size=8192]
66066600
66076601# any operator
66086602query ?
0 commit comments