Select Predefined Columns

Query

The query returns all series columns as well as entity tags, entity groups, metric tags, and a metric field column.

Tags

The tags columns serialize tags into a colon-separated key=value string. Each tag can be referenced in a separate column using the tags.{tag-name} notation.

entity.tags.app
entity.tags.location
entity.tags."loc-area"

Tag names containing special characters must be quoted.

Fields

The metric and entity metadata fields can be accessed using the metric.{field-name} and entity.{field-name} notation.

metric.units
entity.label
entity.timeZone

Query Text

SELECT time, datetime, value, text, metric, entity, tags, -- series columns, same as SELECT * columns
  entity.tags,     -- all entity tags in one column
  entity.tags.app, -- specific tag by name
  entity.groups,   -- all entity groups in one column
  metric.tags,     -- all entity tags in one column
  metric.units     -- metric metadata field
  FROM "df.disk_used"
WHERE entity = 'nurswgvml006'
  AND datetime > now - 5 * minute
ORDER BY datetime

Results

| time           | datetime                  | value     | text  | metric     | entity        | tags                                                | entity.tags.app  | entity.tags                             | entity.groups              | metric.tags          | metric.units |
|----------------|---------------------------|-----------|-------|------------|---------------|-----------------------------------------------------|------------------|-----------------------------------------|----------------------------|----------------------|--------------|
| 1532408808000  | 2018-07-24T05:06:48.000Z  | 4796380   |       | disk_used  | nurswgvml006  | file_system=/dev/mapper/vg-lv_root;mount_point=/    | Hadoop/HBASE     | app=Hadoop/HBASE;ip=192.0.2.5;os=Linux  | nmon-linux;nur-collectors  | table=Disk (script)  | bytes        |
| 1532408808000  | 2018-07-24T05:06:48.000Z  | 61406796  |       | disk_used  | nurswgvml006  | file_system=/dev/sdb1;mount_point=/media/datadrive  | Hadoop/HBASE     | app=Hadoop/HBASE;ip=192.0.2.5;os=Linux  | nmon-linux;nur-collectors  | table=Disk (script)  | bytes        |