Weekly Change Log: July 24, 2017 - July 30, 2017


Issue Category Type Subject
4419 sql Bug IndexOutOfBoundsException fixed in queries that referred to a non-existent metric.
4417 sql Bug Fixed a NullPointerException if all columns selected for a new metric without any samples.
4416 api-network Feature Invalid Action (a) string field added to the metric command
4403 sql Bug Added syntax validation for the IN clause to require enclosing brackets.
4377 sql Feature Add support for selecting all columns in inline views.
4361 sql Feature Add support for compressed CSV files in scheduled SQL query export
3918 api-rest Bug Replace last=true with limit=1 in Series Get method.

Issue 4416

metric Command Syntax:

metric m:{metric} b:{enabled} p:{data-type} l:{label} d:{description} i:{interpolate} u:{units} f:{filter} z:{timezone} v:{versioning} a:{invalid_action} min:{minimum_value} max:{maximum_value} t:{tag-1}={text} t:{tag-2}={text}

Issue 4403

This query causes an error:

SELECT * FROM jvm_memory_used
  WHERE value IN 169328488
  AND datetime > NOW - 10*HOUR

The correct syntax is to use brackets:

SELECT * FROM jvm_memory_used
  WHERE value IN (169328488)
  AND datetime > NOW - 10*HOUR

Issue 4377

Add support for selecting all columns with an asterisk (*) symbol in inline views:

SELECT TableauSQL.datetime AS datetime,
  TableauSQL.value AS value
FROM ( select * from table_size ) TableauSQL
  LIMIT 10

Issue 4361

Compression for CSV report files can be selected on the SQL > Scheduled Queries page.

Issue 3918

last=true is replaced with limit=1 and direction=DESC.

  "startDate": "2017-02-28T19:00:00Z",
  "endDate":   "2017-02-28T20:00:00Z",
  "entity": "nurswgvml007",
  "metric": "cpu_busy",
  "limit": 1