{"action":"opened","issue":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/8043","repository_url":"https://api.github.com/repos/influxdata/influxdb","labels_url":"https://api.github.com/repos/influxdata/influxdb/issues/8043/labels{/name}","comments_url":"https://api.github.com/repos/influxdata/influxdb/issues/8043/comments","events_url":"https://api.github.com/repos/influxdata/influxdb/issues/8043/events","html_url":"https://github.com/influxdata/influxdb/issues/8043","id":209403060,"number":8043,"title":"[1.2.0] error parsing multiple subqueries","user":{"login":"keithmork","id":5634347,"avatar_url":"https://avatars.githubusercontent.com/u/5634347?v=3","gravatar_id":"","url":"https://api.github.com/users/keithmork","html_url":"https://github.com/keithmork","followers_url":"https://api.github.com/users/keithmork/followers","following_url":"https://api.github.com/users/keithmork/following{/other_user}","gists_url":"https://api.github.com/users/keithmork/gists{/gist_id}","starred_url":"https://api.github.com/users/keithmork/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/keithmork/subscriptions","organizations_url":"https://api.github.com/users/keithmork/orgs","repos_url":"https://api.github.com/users/keithmork/repos","events_url":"https://api.github.com/users/keithmork/events{/privacy}","received_events_url":"https://api.github.com/users/keithmork/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-02-22T09:53:53Z","updated_at":"2017-02-22T09:53:53Z","closed_at":null,"body":"\r\nI want to calculate the percentage of errors in jmeter load test results, this [doc](https://docs.influxdata.com/influxdb/v1.2/query_language/data_exploration/#subqueries) says `Note that there can be multiple subqueries per main query`, but I got the error as below:\r\n\r\n```\r\nSELECT 1 - \"error\" / \"all\" FROM (SELECT sum(\"value\") AS \"all\" FROM \"jmeter.a.count\";SELECT sum(\"value\") AS \"error\" FROM \"jmeter.ko.count\")\r\n\r\nERR: error parsing query: found ;, expected ) at line 1, char 84\r\n```\r\n\r\nThe queries in () :\r\n\r\n```\r\nSELECT sum(\"value\") AS \"all\" FROM \"jmeter.a.count\";SELECT sum(\"value\") AS \"error\" FROM \"jmeter.ko.count\"\r\n\r\nname: jmeter.a.count\r\ntime all\r\n---- ---\r\n0    584992\r\n\r\nname: jmeter.ko.count\r\ntime error\r\n---- -----\r\n0    6016\r\n```\r\n"}}
{"actor":{"display_login":"keithmork"}}