influxdb cli queries now with regex
By joe
- 1 minutes read - 213 wordsThis is the way queries are supposed to work. Note the perl regex in the series name
unison> select * from /^usn-ramboot.nettotals.kb(in|out)$/ limit 10
D[23261] Scalable::TSDB::_generate_url; dbquery = 'select * from /^usn-ramboot.nettotals.kb(in|out)$/ limit 10'
D[23261] Scalable::TSDB::_generate_url; query = 'p=XXXXXXXX&u;=scalable&chunked;=1&time;_precision=s&q;=select%20%2A%20from%20%2F%5Eusn-ramboot.nettotals.kb%28in%7Cout%29%24%2F%20limit%2010'
D[23261] Scalable::TSDB::_generate_url; url = 'http://localhost:8086/db/unison/series?p=XXXXXXX&u;=scalable&chunked;=1&time;_precision=s&q;=select%20%2A%20from%20%2F%5Eusn-ramboot.nettotals.kb%28in%7Cout%29%24%2F%20limit%2010'
D[23261] Scalable::TSDB::_send_chunked_get_query -> reading 0.009837s
D[23261] Scalable::TSDB::_send_chunked_get_query -> bytes_received = 530B
D[23261] Scalable::TSDB::_send_chunked_get_query return code = 200
D[23261] Scalable::TSDB::_send_chunked_get_query cols = [time,sequence_number,usn-ramboot.nettotals.kbin]
D[23261] Scalable::TSDB::_send_chunked_get_query cols = [time,sequence_number,usn-ramboot.nettotals.kbout]
D[23261] Scalable::TSDB::_send_chunked_get_query -> mapping 0.001205s
D[23261] influxdb-cli.pl; DB query 'select * from /^usn-ramboot.nettotals.kb(in|out)$/ limit 10' took 0.011656s
D[23261] influxdb-cli.pl; output formatting took 0.000685s
.-----------------------------------------------------------------------------------------.
| results: query = 'select * from /^usn-ramboot.nettotals.kb(in|out)$/ limit 10' |
+------------+-----------------+----------------------------+-----------------------------+
| time | sequence_number | usn-ramboot.nettotals.kbin | usn-ramboot.nettotals.kbout |
+------------+-----------------+----------------------------+-----------------------------+
| 1423495580 | 1 | 1 | 5 |
| 1423495579 | 1 | 2 | 6 |
| 1423495578 | 1 | 1 | 5 |
| 1423495577 | 1 | 1 | 5 |
| 1423495576 | 1 | 1 | 5 |
| 1423495575 | 1 | 1 | 5 |
| 1423495574 | 1 | 1 | 5 |
| 1423495573 | 1 | 1 | 5 |
| 1423495572 | 1 | 1 | 5 |
| 1423495571 | 1 | 1 | 5 |
'------------+-----------------+----------------------------+-----------------------------'
D[23261] influxdb-cli.pl; outputting took 0.002347s