influxdb cli queries now with regex

This 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

Viewed 40515 times by 5431 viewers

Facebooktwittergoogle_plusredditpinterestlinkedinmail