TPC-H GPU - Projected Encodings Required

[0ax1]

All Encodings

Encoding	GPU	Queries	Assigned
fastlanes.bitpacked	✓	22
fastlanes.for	✓	22
vortex.primitive	✓	21
vortex.zstd	✓	19
vortex.sequence	✗	19	@a10y
vortex.decimal_byte_parts	✓	17
vortex.datetimeparts	✗	15	@0ax1
vortex.runend	✗	14	@0ax1
vortex.constant	✗	11
vortex.varbinview	✓	4

Per query breakdown

Query 1

Encoding	GPU
fastlanes.bitpacked	✓
fastlanes.for	✓
vortex.constant	✗
vortex.decimal_byte_parts	✓
vortex.datetimeparts	✗
vortex.zstd	✓
vortex.primitive	✓
vortex.sequence	✗

---

Query 2

Encoding	GPU
fastlanes.bitpacked	✓
fastlanes.for	✓
vortex.constant	✗
vortex.decimal_byte_parts	✓
vortex.zstd	✓
vortex.primitive	✓
vortex.runend	✗
vortex.sequence	✗

---

Query 3

Encoding	GPU
fastlanes.bitpacked	✓
fastlanes.for	✓
vortex.decimal_byte_parts	✓
vortex.datetimeparts	✗
vortex.primitive	✓
vortex.runend	✗
vortex.sequence	✗
vortex.varbinview	✓

---

Query 4

Encoding	GPU
fastlanes.bitpacked	✓
fastlanes.for	✓
vortex.datetimeparts	✗
vortex.primitive	✓
vortex.runend	✗
vortex.varbinview	✓

---

Query 5

Encoding	GPU
fastlanes.bitpacked	✓
fastlanes.for	✓
vortex.decimal_byte_parts	✓
vortex.datetimeparts	✗
vortex.zstd	✓
vortex.primitive	✓
vortex.runend	✗
vortex.sequence	✗

---

Query 6

Encoding	GPU
fastlanes.bitpacked	✓
fastlanes.for	✓
vortex.decimal_byte_parts	✓
vortex.datetimeparts	✗

Note: The only missing encoding is vortex.datetimeparts which is a wrapper around Date types that delegates to the inner storage array.

---

Query 7

Encoding	GPU
fastlanes.bitpacked	✓
fastlanes.for	✓
vortex.decimal_byte_parts	✓
vortex.datetimeparts	✗
vortex.zstd	✓
vortex.primitive	✓
vortex.runend	✗
vortex.sequence	✗

---

Query 8

Encoding	GPU
fastlanes.bitpacked	✓
fastlanes.for	✓
vortex.decimal_byte_parts	✓
vortex.datetimeparts	✗
vortex.zstd	✓
vortex.primitive	✓
vortex.runend	✗
vortex.sequence	✗

---

Query 9

Encoding	GPU
fastlanes.bitpacked	✓
fastlanes.for	✓
vortex.decimal_byte_parts	✓
vortex.datetimeparts	✗
vortex.zstd	✓
vortex.primitive	✓
vortex.runend	✗
vortex.sequence	✗

---

Query 10

Encoding	GPU
fastlanes.bitpacked	✓
fastlanes.for	✓
vortex.constant	✗
vortex.decimal_byte_parts	✓
vortex.datetimeparts	✗
vortex.zstd	✓
vortex.primitive	✓
vortex.runend	✗
vortex.sequence	✗

---

Query 11

Encoding	GPU
fastlanes.bitpacked	✓
fastlanes.for	✓
vortex.decimal_byte_parts	✓
vortex.zstd	✓
vortex.primitive	✓
vortex.runend	✗
vortex.sequence	✗

---

Query 12

Encoding	GPU
fastlanes.bitpacked	✓
fastlanes.for	✓
vortex.datetimeparts	✗
vortex.zstd	✓
vortex.primitive	✓
vortex.runend	✗
vortex.varbinview	✓

---

Query 13

Encoding	GPU
fastlanes.bitpacked	✓
fastlanes.for	✓
vortex.zstd	✓
vortex.primitive	✓
vortex.sequence	✗

---

Query 14

Encoding	GPU
fastlanes.bitpacked	✓
fastlanes.for	✓
vortex.decimal_byte_parts	✓
vortex.datetimeparts	✗
vortex.zstd	✓
vortex.primitive	✓
vortex.sequence	✗

---

Query 15

Encoding	GPU
fastlanes.bitpacked	✓
fastlanes.for	✓
vortex.constant	✗
vortex.decimal_byte_parts	✓
vortex.datetimeparts	✗
vortex.zstd	✓
vortex.primitive	✓
vortex.sequence	✗

---

Query 16

Encoding	GPU
fastlanes.bitpacked	✓
fastlanes.for	✓
vortex.constant	✗
vortex.zstd	✓
vortex.primitive	✓
vortex.runend	✗
vortex.sequence	✗

---

Query 17

Encoding	GPU
fastlanes.bitpacked	✓
fastlanes.for	✓
vortex.constant	✗
vortex.decimal_byte_parts	✓
vortex.zstd	✓
vortex.primitive	✓
vortex.sequence	✗

---

Query 18

Encoding	GPU
fastlanes.bitpacked	✓
fastlanes.for	✓
vortex.constant	✗
vortex.decimal_byte_parts	✓
vortex.datetimeparts	✗
vortex.zstd	✓
vortex.primitive	✓
vortex.runend	✗
vortex.sequence	✗

---

Query 19

Encoding	GPU
fastlanes.bitpacked	✓
fastlanes.for	✓
vortex.constant	✗
vortex.decimal_byte_parts	✓
vortex.zstd	✓
vortex.primitive	✓
vortex.sequence	✗
vortex.varbinview	✓

---

Query 20

Encoding	GPU
fastlanes.bitpacked	✓
fastlanes.for	✓
vortex.constant	✗
vortex.decimal_byte_parts	✓
vortex.datetimeparts	✗
vortex.zstd	✓
vortex.primitive	✓
vortex.runend	✗
vortex.sequence	✗

---

Query 21

Encoding	GPU
fastlanes.bitpacked	✓
fastlanes.for	✓
vortex.constant	✗
vortex.datetimeparts	✗
vortex.zstd	✓
vortex.primitive	✓
vortex.runend	✗
vortex.sequence	✗

---

Query 22

Encoding	GPU
fastlanes.bitpacked	✓
fastlanes.for	✓
vortex.constant	✗
vortex.decimal_byte_parts	✓
vortex.zstd	✓
vortex.primitive	✓
vortex.sequence	✗

[a10y]

Can we force Varbin -> VarBinView? Or ZSTD?

[a10y]

Also I think VarBinView is done already

[0ax1]

Can we force Varbin -> VarBinView? Or ZSTD?

Yep! ..updating.

[joseph-isaacs]

update it

[lwwmanning]

what about alp?

[0ax1]

what about alp?

we're covered with decimal_byte_parts. it's all decimals in tpch no floats.

[a10y]

I'll take sequence