inner_join (view)
2 rows where name = "rtx2070"
This data as json, CSV (advanced)
PARTITION | AVAIL | TIMELIMIT | NODES | STATE | NODELIST | name | VRAM |
---|---|---|---|---|---|---|---|
rtx2070 | up | 1-00:00:00 | 5 | alloc | c[69-73] | rtx2070 | 8 |
rtx2070 | up | 1-00:00:00 | 10 | idle | c[50,63-67,74-76,79] | rtx2070 | 8 |
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;