distsql: tracking issue for TPC-H queries

[asubiotto]

This is a list of TPC-H queries that we expect to run using DistSQL. All queries are run with a scale factor of 1 on 6-node navy.

Note: Performance numbers are of a single run. More robust performance numbers will be worked on in the future since the current focus is for the queries to run in the first place.

• Query 1
  • Plan

Without DistSQL	With DistSQL
1m20s	50s

• Query 3
  • distsql: panic of TPC-H query 3 when running on 6-node omega #14360
  • Plan

Without DistSQL	With DistSQL
4m27s	4m15s

• Query 7
  • distsql: tpch query 7 results in context cancelled error #13989
  • Plan

Without DistSQL	With DistSQL
2m16s	2m00s

• Query 8
  • Single-node SQL execution time could not be collected due to sql: TPC-H query 8 exceeds memory budget #14933
  • Plan

Without DistSQL	With DistSQL
-	52s

• Query 19
  • Plan

Without DistSQL	With DistSQL
2m10s	2m15s

Queries with memory issues:

• Query 9
  • Single-node SQL execution time could not be collected due to sql: TPC-H query 8 exceeds memory budget #14933
  • Running with DistSQL results in OOM (see sql/distsql: use external storage for larger queries #15206)

Queries supported by single-node SQL but not DistSQL:

• Query 15
  • Cannot be run with DistSQL because this query requires support of CREATE VIEW (see distsql: TPC-H query 15 can't be run with distsql because CREATE VIEW is unsupported #15037)

The other queries are not supported by single-node SQL.

[asubiotto]

cc @andreimatei @RaduBerinde @arjunravinarayan @knz @vivekmenezes @cuongdo