{"action":"closed","issue":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/6279","repository_url":"https://api.github.com/repos/influxdata/influxdb","labels_url":"https://api.github.com/repos/influxdata/influxdb/issues/6279/labels{/name}","comments_url":"https://api.github.com/repos/influxdata/influxdb/issues/6279/comments","events_url":"https://api.github.com/repos/influxdata/influxdb/issues/6279/events","html_url":"https://github.com/influxdata/influxdb/issues/6279","id":147394982,"number":6279,"title":"The tags in the select query result displays incorrect data","user":{"login":"anand-vardham","id":12733273,"avatar_url":"https://avatars.githubusercontent.com/u/12733273?v=3","gravatar_id":"","url":"https://api.github.com/users/anand-vardham","html_url":"https://github.com/anand-vardham","followers_url":"https://api.github.com/users/anand-vardham/followers","following_url":"https://api.github.com/users/anand-vardham/following{/other_user}","gists_url":"https://api.github.com/users/anand-vardham/gists{/gist_id}","starred_url":"https://api.github.com/users/anand-vardham/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/anand-vardham/subscriptions","organizations_url":"https://api.github.com/users/anand-vardham/orgs","repos_url":"https://api.github.com/users/anand-vardham/repos","events_url":"https://api.github.com/users/anand-vardham/events{/privacy}","received_events_url":"https://api.github.com/users/anand-vardham/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/influxdata/influxdb/labels/category/queries","name":"category/queries","color":"5319e7"}],"state":"closed","locked":false,"assignee":{"login":"jsternberg","id":1212129,"avatar_url":"https://avatars.githubusercontent.com/u/1212129?v=3","gravatar_id":"","url":"https://api.github.com/users/jsternberg","html_url":"https://github.com/jsternberg","followers_url":"https://api.github.com/users/jsternberg/followers","following_url":"https://api.github.com/users/jsternberg/following{/other_user}","gists_url":"https://api.github.com/users/jsternberg/gists{/gist_id}","starred_url":"https://api.github.com/users/jsternberg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jsternberg/subscriptions","organizations_url":"https://api.github.com/users/jsternberg/orgs","repos_url":"https://api.github.com/users/jsternberg/repos","events_url":"https://api.github.com/users/jsternberg/events{/privacy}","received_events_url":"https://api.github.com/users/jsternberg/received_events","type":"User","site_admin":false},"milestone":null,"comments":12,"created_at":"2016-04-11T11:13:21Z","updated_at":"2016-05-24T13:21:46Z","closed_at":"2016-05-24T13:21:46Z","body":"The Ids in the select query is not displayed correctly. Its displaying incorrect value for cluster_id, svm_id and the id tag. which result in the failure of the UDF script\r\nwith missing key/value error.\r\n\r\n`SELECT iops, latency, throughput, totalcapacity, usedcapacity FROM janus16.\"5mins\".volume_data WHERE time > '2016-04-11T09:51:46.810561587Z' AND time < '2016-04-11T10:51:46.810561587Z' and cluster_id='avardham'   GROUP BY svm_id, cluster_id, id`\r\n\r\n```\r\nname: volume_data\r\ntags: cluster_id=id, id=, svm_id=avardham\r\ntime                    iops                    latency                 throughput              totalcapacity   usedcapacity\r\n----                    ----                    -------                 ----------              -------------   ------------\r\n1460370744000000000     0.038461538461538464    73311                   0                       102400          5300\r\n1460371244000000000     0                       0                       0                       102400          5300\r\n1460371331000000000     0.034482758620689655    73073.33333333333       0                       102400          5300\r\n1460371419000000000     0.03409090909090909     74895.33333333333       0                       102400          5300\r\n1460371524000000000     0.02857142857142857     73372                   0                       102400          5300\r\n```\r\n\r\nThe show tag values displays the data properly\r\n\r\n```\r\n> show tag values with key=svm_id where cluster_id = 'avardham'\r\nname: volume_data\r\n-----------------\r\nkey     value\r\nsvm_id  Systemic21\r\nsvm_id  Systemic22\r\nsvm_id  Systemic23\r\nsvm_id  Systemic24\r\nsvm_id  Systemic25\r\nsvm_id  avardham-01\r\n```"}}
{"actor":{"display_login":"jsternberg"}}