Skip to content
This repository has been archived by the owner on Nov 28, 2020. It is now read-only.

PP for interval join with BAMDataSource #89

Open
mwiewior opened this issue Jul 25, 2018 · 0 comments
Open

PP for interval join with BAMDataSource #89

mwiewior opened this issue Jul 25, 2018 · 0 comments
Labels

Comments

@mwiewior
Copy link
Collaborator

Write unit test and document if in this query for BAMDataSource interval pushdown works if BAI is in place.

SELECT s2.targetId,count(*)
    FROM reads s1 JOIN targets s2
    ON s1.chr=s2.chr
    AND s1.end>=s2.start
    AND s1.start<=s2.end
	AND s1.chr='chr1' AND s1.start > 10000
    GROUP BY targetId;
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
Projects
None yet
Development

No branches or pull requests

1 participant