{"action":"created","issue":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/3129","labels_url":"https://api.github.com/repos/influxdb/influxdb/issues/3129/labels{/name}","comments_url":"https://api.github.com/repos/influxdb/influxdb/issues/3129/comments","events_url":"https://api.github.com/repos/influxdb/influxdb/issues/3129/events","html_url":"https://github.com/influxdb/influxdb/issues/3129","id":90779047,"number":3129,"title":"Cant SELECT over multiple regexps","user":{"login":"mjdesa","id":1477539,"avatar_url":"https://avatars.githubusercontent.com/u/1477539?v=3","gravatar_id":"","url":"https://api.github.com/users/mjdesa","html_url":"https://github.com/mjdesa","followers_url":"https://api.github.com/users/mjdesa/followers","following_url":"https://api.github.com/users/mjdesa/following{/other_user}","gists_url":"https://api.github.com/users/mjdesa/gists{/gist_id}","starred_url":"https://api.github.com/users/mjdesa/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mjdesa/subscriptions","organizations_url":"https://api.github.com/users/mjdesa/orgs","repos_url":"https://api.github.com/users/mjdesa/repos","events_url":"https://api.github.com/users/mjdesa/events{/privacy}","received_events_url":"https://api.github.com/users/mjdesa/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"otoolep","id":536312,"avatar_url":"https://avatars.githubusercontent.com/u/536312?v=3","gravatar_id":"","url":"https://api.github.com/users/otoolep","html_url":"https://github.com/otoolep","followers_url":"https://api.github.com/users/otoolep/followers","following_url":"https://api.github.com/users/otoolep/following{/other_user}","gists_url":"https://api.github.com/users/otoolep/gists{/gist_id}","starred_url":"https://api.github.com/users/otoolep/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/otoolep/subscriptions","organizations_url":"https://api.github.com/users/otoolep/orgs","repos_url":"https://api.github.com/users/otoolep/repos","events_url":"https://api.github.com/users/otoolep/events{/privacy}","received_events_url":"https://api.github.com/users/otoolep/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/influxdb/influxdb/milestones/41","html_url":"https://github.com/influxdb/influxdb/milestones/0.9.2","labels_url":"https://api.github.com/repos/influxdb/influxdb/milestones/41/labels","id":1152021,"number":41,"title":"0.9.2","description":"","creator":{"login":"toddboom","id":53132,"avatar_url":"https://avatars.githubusercontent.com/u/53132?v=3","gravatar_id":"","url":"https://api.github.com/users/toddboom","html_url":"https://github.com/toddboom","followers_url":"https://api.github.com/users/toddboom/followers","following_url":"https://api.github.com/users/toddboom/following{/other_user}","gists_url":"https://api.github.com/users/toddboom/gists{/gist_id}","starred_url":"https://api.github.com/users/toddboom/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/toddboom/subscriptions","organizations_url":"https://api.github.com/users/toddboom/orgs","repos_url":"https://api.github.com/users/toddboom/repos","events_url":"https://api.github.com/users/toddboom/events{/privacy}","received_events_url":"https://api.github.com/users/toddboom/received_events","type":"User","site_admin":false},"open_issues":82,"closed_issues":32,"state":"open","created_at":"2015-06-05T20:05:49Z","updated_at":"2015-06-25T00:05:45Z","due_on":"2015-07-22T07:00:00Z","closed_at":null},"comments":4,"created_at":"2015-06-24T20:59:45Z","updated_at":"2015-06-25T00:21:54Z","closed_at":null,"body":"On OSX with Influx version 0.9 built from source\r\n\r\nRunning\r\n\r\n```\r\nselect * from /^cpu/, /^mem/\r\n```\r\n\r\nyields\r\n\r\n```\r\nERR: can not use field in group by clause: cpu\r\n```"},"comment":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/comments/115052593","html_url":"https://github.com/influxdb/influxdb/issues/3129#issuecomment-115052593","issue_url":"https://api.github.com/repos/influxdb/influxdb/issues/3129","id":115052593,"user":{"login":"beckettsean","id":6537329,"avatar_url":"https://avatars.githubusercontent.com/u/6537329?v=3","gravatar_id":"","url":"https://api.github.com/users/beckettsean","html_url":"https://github.com/beckettsean","followers_url":"https://api.github.com/users/beckettsean/followers","following_url":"https://api.github.com/users/beckettsean/following{/other_user}","gists_url":"https://api.github.com/users/beckettsean/gists{/gist_id}","starred_url":"https://api.github.com/users/beckettsean/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/beckettsean/subscriptions","organizations_url":"https://api.github.com/users/beckettsean/orgs","repos_url":"https://api.github.com/users/beckettsean/repos","events_url":"https://api.github.com/users/beckettsean/events{/privacy}","received_events_url":"https://api.github.com/users/beckettsean/received_events","type":"User","site_admin":false},"created_at":"2015-06-25T00:21:54Z","updated_at":"2015-06-25T00:21:54Z","body":"`select` will work over multiple measurements if and only if they have identical field keys. Otherwise it will blow up with an error like the above. The regex in Michael's original example appears to expose both that issue and the implicit `group by *`"}}