{"action":"created","issue":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/2911","repository_url":"https://api.github.com/repos/influxdata/influxdb","labels_url":"https://api.github.com/repos/influxdata/influxdb/issues/2911/labels{/name}","comments_url":"https://api.github.com/repos/influxdata/influxdb/issues/2911/comments","events_url":"https://api.github.com/repos/influxdata/influxdb/issues/2911/events","html_url":"https://github.com/influxdata/influxdb/issues/2911","id":87247458,"number":2911,"title":"[feature request] Add CAST function","user":{"login":"sudabon","id":140196,"avatar_url":"https://avatars.githubusercontent.com/u/140196?v=3","gravatar_id":"","url":"https://api.github.com/users/sudabon","html_url":"https://github.com/sudabon","followers_url":"https://api.github.com/users/sudabon/followers","following_url":"https://api.github.com/users/sudabon/following{/other_user}","gists_url":"https://api.github.com/users/sudabon/gists{/gist_id}","starred_url":"https://api.github.com/users/sudabon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sudabon/subscriptions","organizations_url":"https://api.github.com/users/sudabon/orgs","repos_url":"https://api.github.com/users/sudabon/repos","events_url":"https://api.github.com/users/sudabon/events{/privacy}","received_events_url":"https://api.github.com/users/sudabon/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/influxdata/influxdb/labels/category/feature%20request","name":"category/feature request","color":"006b75"},{"url":"https://api.github.com/repos/influxdata/influxdb/labels/category/functions","name":"category/functions","color":"d4c5f9"},{"url":"https://api.github.com/repos/influxdata/influxdb/labels/RFC","name":"RFC","color":"207de5"}],"state":"closed","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/influxdata/influxdb/milestones/39","html_url":"https://github.com/influxdata/influxdb/milestones/1.0.0","labels_url":"https://api.github.com/repos/influxdata/influxdb/milestones/39/labels","id":1101423,"number":39,"title":"1.0.0","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":5,"closed_issues":3,"state":"open","created_at":"2015-05-08T06:30:59Z","updated_at":"2016-03-18T22:36:55Z","due_on":null,"closed_at":null},"comments":2,"created_at":"2015-06-11T07:42:31Z","updated_at":"2016-03-18T22:36:55Z","closed_at":"2016-03-18T22:36:55Z","body":"CAST is the function that converts field type in the select query.\r\n\r\nFor example, if convert from string field 'fieldA' to integer, query is like this:\r\n\r\n```\r\nselect cast(fieldA AS integer), ...\r\n```\r\n\r\nAt least, It is preferable to support integer/float/string as conversion type.\r\n"},"comment":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/comments/198568494","html_url":"https://github.com/influxdata/influxdb/issues/2911#issuecomment-198568494","issue_url":"https://api.github.com/repos/influxdata/influxdb/issues/2911","id":198568494,"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":"2016-03-18T22:36:55Z","updated_at":"2016-03-18T22:36:55Z","body":"As mentioned in my [post to the mailing list](https://groups.google.com/d/msg/influxdb/CkKzZoXDgiU/5E-vDNVGCwAJ) we are experimenting with simplifying our open GitHub Issues. This feature request has been rolled into an [aggregate issue](https://github.com/influxdata/influxdb/issues/5930) for all function requests, so that we can close this issue until we are ready to work on it. \r\n\r\nYou may continue to make comments here. Closing the issue does not mean we are rejecting this idea."}}