Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Tracking: Which TPC-H queries can be run? #184

Open
11 of 22 tasks
jurplel opened this issue Sep 3, 2024 · 1 comment
Open
11 of 22 tasks

Tracking: Which TPC-H queries can be run? #184

jurplel opened this issue Sep 3, 2024 · 1 comment

Comments

@jurplel
Copy link
Member

jurplel commented Sep 3, 2024

Related: #11, #68, #127

Ran with no datafusion optimizations (all of our own optimizations)

Tests were done for whether or not the query works with perfbench. Query result may be incorrect, but it compiles and runs

  • Q1
  • Q2
    • Depends on more complete subquery unnesting ruleset
  • Q3
  • Q4
    • Depends on subquery unnesting EXISTS support
    • May depend also on left semi join
  • Q5
  • Q6
  • Q7
  • Q8
  • Q9
  • Q10
  • Q11
    • Depends on more complete subquery unnesting
  • Q12
  • Q13
  • Q14
  • Q15
    • Error: db error: ERROR: cannot insert multiple commands into a prepared statement
    • ??? maybe test framework bug
  • Q16
    • Depends on subquery unnesting IN support
    • May depend also on left anti join
  • Q17
    • Depends on more complete subquery unnesting ruleset
  • Q18
    • Depends on subquery unnesting IN support
    • May depend also on left semi join
  • Q19
  • Q20
    • Depends on subquery unnesting IN support
    • May depend also on left semi join
  • Q21
    • Depends on subquery unnesting EXISTS support
    • May depend also on left semi and left anti join
  • Q22
    • Depends on subquery unnesting IN support
    • May depend also on left anti join
@jurplel jurplel changed the title Which TPC-H queries can be run? Tracking: Which TPC-H queries can be run (v4)? Sep 3, 2024
@jurplel jurplel changed the title Tracking: Which TPC-H queries can be run (v4)? Tracking: Which TPC-H queries can be run? Sep 3, 2024
@skyzh
Copy link
Member

skyzh commented Nov 7, 2024

also note that we didn't test if the query plan we generated is correct -- for now it is possible that we generated a plan that doesn't run in DF, or generates wrong result.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants