Tasks needing completion to be able to run TPC-H queries

thisisnic commented 2 years ago

In order to be able to run the TPC-H queries (R versions here), the following tasks need to be completed:

Function bindings

[x] #143
[ ] #219
[x] #218
[x] #203
[x] #193 (specifically grepl)
[x] #204 (specifically lubridate::year())
[x] #191
[x] #156
[x] #221
[x] #148
[x] #74
[x] #222
[x] #93
[x] #237 (specifically abs)
[x] #145
[x] #256
[ ] #258 (no binding in Acero yet)
[ ] #245 (no binding in Acero yet)

Verb bindings

[x] #23
[x] #22
[x] #27
[x] #207
[x] #206
[x] #257

Data types

[x] #124

Other

[x] #202
[x] #155
[x] #153
[ ] #252

thisisnic commented 2 years ago

TPCH-1:

[x] #202
[x] #124
[x] #218
[x] #143
[ ] #219
[x] #155
[x] #221

TPCH-2:

[x] #193
[x] #23
[x] #148
[x] #203

TPCH-3:

[x] #23
[x] #124
[x] #203

TPC-H 4:

[x] #124
[x] #23
[ ] #219

TPC-H 5:

[x] #23
[x] #221

TPC-H 6:

[x] #124
[x] #191
[x] #221

TPC-H 7:

[x] #23
[x] #74
[x] #124
[x] #222
[x] #204
[x] #221

TPC-H 8:

[x] #23
[x] #222
[x] #124
[x] #221
[x] #156

TPC-H 9:

[x] #193
[x] #23
[x] #221

TPC-H 10:

[x] #222
[x] #124
[x] #23
[x] #221
[x] #203

TPC-H 11:

[x] #222
[x] #23
[x] #221

TPC-H 12:

[x] #74
[x] #221
[x] #156
[x] #23

TPC-H 13:

[x] #22
[x] #193
[x] #221
[x] #93
[ ] #219

TPC-H 14:

[x] #124
[x] #23
[x] #221
[x] #156

TPC-H 15:

[x] #124
[x] #221
[x] #148
[x] #23
[x] #237

TPC-H 16:

[x] #193
[x] #222
[x] #74
[x] #145
[x] #23

TPC-H 17:

[x] #222
[x] #218
[x] #23
[x] #221

TPC-H 18:

[x] #221
[x] #23
[x] #203

TPC-H 19:

[x] #23
[x] #222
[x] #74
[x] #221

TPC-H 20:

[x] #23
[x] #193
[x] #207
[x] #124
[x] #221

TPC-H 21:

[ ] #219
[x] #207
[x] #23
[x] #222
[x] #221
[x] #156
[x] #203

TPC-H 22:

[x] #74
[x] #218
[x] #193 (substr)
[x] #27
[ ] #219

thisisnic commented 2 years ago

In the order of number of queries requiring those tickets to be completed:

[x] #221 | 17
[x] #23 | 17
[x] #124 | 10
[x] #222 | 8
[x] #193 | 5
[x] #203 | 5
[ ] #219 | 5
[x] #74 | 5
[x] #156 | 4
[x] #218 | 3
[x] #148 | 2
[x] #207 | 2
[x] #143 | 1
[x] #145 | 1
[x] #237 | 1
[x] #191 | 1
[x] #193 (substr) | 1
[x] #204 | 1
[x] #22 | 1
[x] #27 | 1
[x] #93 | 1

voltrondata / substrait-r

Tasks needing completion to be able to run TPC-H queries #205