{"action":"created","issue":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/7072","repository_url":"https://api.github.com/repos/influxdata/influxdb","labels_url":"https://api.github.com/repos/influxdata/influxdb/issues/7072/labels{/name}","comments_url":"https://api.github.com/repos/influxdata/influxdb/issues/7072/comments","events_url":"https://api.github.com/repos/influxdata/influxdb/issues/7072/events","html_url":"https://github.com/influxdata/influxdb/issues/7072","id":167768026,"number":7072,"title":"CQs and INTO queries should allow for non-nanosecond precision","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},"labels":[{"url":"https://api.github.com/repos/influxdata/influxdb/labels/category/continuous%20queries","name":"category/continuous queries","color":"207de5"}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2016-07-27T04:32:28Z","updated_at":"2016-07-28T16:01:55Z","closed_at":null,"body":"### Feature Request\r\n\r\n__Proposal:__ [Description of the feature]\r\n\r\nAllow users to specify the write precision for points written to InfluxDB with an `INTO` clause\r\n\r\n__Current behavior:__ [What currently happens]\r\n\r\nCurrently all CQs and ad hoc INTO queries write points with full nanosecond precision.\r\n\r\n__Desired behavior:__ [What you would like to happen]\r\n\r\nWe should be able to specify units other than `ns` for the timestamps, particularly `us`, `ms`, and `s`.\r\n\r\n__Use case:__ [Why is this important (helps with prioritizing requests)]\r\n\r\nCompression and throughput are better with less precise timestamps. "},"comment":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/comments/235941210","html_url":"https://github.com/influxdata/influxdb/issues/7072#issuecomment-235941210","issue_url":"https://api.github.com/repos/influxdata/influxdb/issues/7072","id":235941210,"user":{"login":"mark-rushakoff","id":290647,"avatar_url":"https://avatars.githubusercontent.com/u/290647?v=3","gravatar_id":"","url":"https://api.github.com/users/mark-rushakoff","html_url":"https://github.com/mark-rushakoff","followers_url":"https://api.github.com/users/mark-rushakoff/followers","following_url":"https://api.github.com/users/mark-rushakoff/following{/other_user}","gists_url":"https://api.github.com/users/mark-rushakoff/gists{/gist_id}","starred_url":"https://api.github.com/users/mark-rushakoff/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mark-rushakoff/subscriptions","organizations_url":"https://api.github.com/users/mark-rushakoff/orgs","repos_url":"https://api.github.com/users/mark-rushakoff/repos","events_url":"https://api.github.com/users/mark-rushakoff/events{/privacy}","received_events_url":"https://api.github.com/users/mark-rushakoff/received_events","type":"User","site_admin":false},"created_at":"2016-07-28T16:01:55Z","updated_at":"2016-07-28T16:01:55Z","body":"@beckettsean AFAICT, using `precision rfc3339` in the CLI will display timestamps with  the same precision as what's stored.\r\n\r\nA measurement that I know is stored with second precision:\r\n\r\n```\r\n> select n from go limit 1\r\nname: go\r\n--------\r\ntime\t\t\tn\r\n2016-03-31T16:54:14Z\t50000\r\n```\r\n\r\nA measurement with microsecond precision:\r\n\r\n```\r\n> select bytes from hh_queue limit 1\r\nname: hh_queue\r\n--------------\r\ntime\t\t\t\tbytes\r\n2016-07-28T15:46:50.770082Z\t191559\r\n```\r\n\r\nI'm not aware of a more efficient way to discover the stored precision of a point."}}
{"actor":{"display_login":"mark-rushakoff"}}