Select multiple series

[william-p]

Hi,
Can i select multiple series ?

See output:

    db> select * from local-root.workers.nb_hit limit 3;
    ┌──────────────────┬─────────────────┬────────────────┬───────┐
    │       time       │ sequence_number │ location       │ value │
    ├──────────────────┼─────────────────┼────────────────┼───────┤
    │ 9/12/13 15:52:00 │ 1251580001      │ FR:VSS:ILD:DC  │ 3     │
    │ 9/12/13 15:52:00 │ 1251570001      │ FR:SHB:FRE:A9M │ 1     │
    │ 9/12/13 15:52:00 │ 1251560001      │ CA:BHS:OVH:DC  │ 1     │
    └──────────────────┴─────────────────┴────────────────┴───────┘

    db> select * from local-root.workers.nb_job limit 3;
    ┌──────────────────┬─────────────────┬────────────────┬───────┐
    │       time       │ sequence_number │ location       │ value │
    ├──────────────────┼─────────────────┼────────────────┼───────┤
    │ 9/12/13 15:52:00 │ 1251300001      │ FR:VSS:ILD:DC  │ 6     │
    │ 9/12/13 15:52:00 │ 1251290001      │ FR:SHB:FRE:A9M │ 1     │
    │ 9/12/13 15:52:00 │ 1251280001      │ CA:BHS:OVH:DC  │ 1     │
    └──────────────────┴─────────────────┴────────────────┴───────┘

    db> select * from local-root.workers.nb_hit, local-root.workers.nb_job;
    db> ✘ Error: Error at 441358232:32597. syntax error, unexpected ',', expecting $end

InfluxDB v0.4.0.rc2 (git: e25fe4997a36997d293c271f1dadf7670961b0b2)

i've missing something ?

Thanks

[jvshahid]

Currently, only regex are supported. I thought there was an issue to address this, but i can't seem to find it right now. It's pretty straight forward to implement it, so I'll try to get to it some time today. For now if you want to select from multiple series please use regex instead, e.g. select * from /local-root\.workers\.nb_(hit|job)/ or something similar.

[william-p]

Okay thanks @jvshahid