inner_join (view)
3 rows where VRAM = 16
This data as json, CSV (advanced)
Suggested facets: PARTITION, NODES, STATE, name
PARTITION | AVAIL | TIMELIMIT | NODES | STATE | NODELIST | name | VRAM |
---|---|---|---|---|---|---|---|
a4000 | up | 1-00:00:00 | 3 | alloc | c[4-5,35] | a4000 | 16 |
a4000 | up | 1-00:00:00 | 3 | idle | c[6-7,36] | a4000 | 16 |
rtx4060ti16g | up | 1-00:00:00 | 1 | alloc | c25 | rtx4060ti16g | 16 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW inner_join AS SELECT * FROM nodes INNER JOIN [nvidia-gpus] ON nodes.PARTITION = [nvidia-gpus].name;