Skip to content

Support LocalTableScanExec #2513

Closed

Description

@comphead

Comet doesn't support LocalTableScanExec which is used in non correlated subqueries
Query example TPCH Q11

select
	ps_partkey,
	sum(ps_supplycost * ps_availqty) as value
from
	partsupp,
	supplier,
	nation
where
	ps_suppkey = s_suppkey
	and s_nationkey = n_nationkey
	and n_name = 'ALGERIA'
group by
	ps_partkey having
		sum(ps_supplycost * ps_availqty) > (
			select
				sum(ps_supplycost * ps_availqty) * 0.0001000000
			from
				partsupp,
				supplier,
				nation
			where
				ps_suppkey = s_suppkey
				and s_nationkey = n_nationkey
				and n_name = 'ALGERIA'
		)
order by
	value desc;
                      

Activity

  1. kazantsev-maksim commented on Oct 23, 2025

    @kazantsev-maksim
    Contributor

    @comphead are you already working on this task? If not, I would be happy to work on it.

  2. comphead commented on Oct 23, 2025

    @comphead
    ContributorAuthor

    @comphead are you already working on this task? If not, I would be happy to work on it.

    I'm not on it right now, feel free to pick it up

  3. kazantsev-maksim commented on Oct 23, 2025

    @kazantsev-maksim
    Contributor

    take

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions