{"action":"created","issue":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/2414","labels_url":"https://api.github.com/repos/influxdata/influxdb/issues/2414/labels{/name}","comments_url":"https://api.github.com/repos/influxdata/influxdb/issues/2414/comments","events_url":"https://api.github.com/repos/influxdata/influxdb/issues/2414/events","html_url":"https://github.com/influxdata/influxdb/issues/2414","id":70659506,"number":2414,"title":"Select Into Not Work on sample data","user":{"login":"yank1","id":9472593,"avatar_url":"https://avatars.githubusercontent.com/u/9472593?v=3","gravatar_id":"","url":"https://api.github.com/users/yank1","html_url":"https://github.com/yank1","followers_url":"https://api.github.com/users/yank1/followers","following_url":"https://api.github.com/users/yank1/following{/other_user}","gists_url":"https://api.github.com/users/yank1/gists{/gist_id}","starred_url":"https://api.github.com/users/yank1/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yank1/subscriptions","organizations_url":"https://api.github.com/users/yank1/orgs","repos_url":"https://api.github.com/users/yank1/repos","events_url":"https://api.github.com/users/yank1/events{/privacy}","received_events_url":"https://api.github.com/users/yank1/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-04-24T11:01:55Z","updated_at":"2016-01-05T16:07:56Z","closed_at":"2015-04-30T23:23:18Z","body":"HI. I use the data in the readme.md.\r\n\r\n\t> select * from cpu\r\n\tname: cpu\r\n\t---------\r\n\ttime\t\t\tvalue\r\n\t2014-11-10T23:00:00Z\t100\r\n\r\nWhen I execute the select into query. It seems not work\r\n\r\n\t> select * into another_cpu from cpu\r\n\t> select * from another_cpu\r\n\tERR: measurement not found: \"mydb\".\"default\".another_cpu\r\n\r\nversion : 0.9.0-rc27\r\n\r\nIs there any hero can help me?\r\nThanks"},"comment":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/comments/169045704","html_url":"https://github.com/influxdata/influxdb/issues/2414#issuecomment-169045704","issue_url":"https://api.github.com/repos/influxdata/influxdb/issues/2414","id":169045704,"user":{"login":"saiello","id":1553023,"avatar_url":"https://avatars.githubusercontent.com/u/1553023?v=3","gravatar_id":"","url":"https://api.github.com/users/saiello","html_url":"https://github.com/saiello","followers_url":"https://api.github.com/users/saiello/followers","following_url":"https://api.github.com/users/saiello/following{/other_user}","gists_url":"https://api.github.com/users/saiello/gists{/gist_id}","starred_url":"https://api.github.com/users/saiello/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/saiello/subscriptions","organizations_url":"https://api.github.com/users/saiello/orgs","repos_url":"https://api.github.com/users/saiello/repos","events_url":"https://api.github.com/users/saiello/events{/privacy}","received_events_url":"https://api.github.com/users/saiello/received_events","type":"User","site_admin":false},"created_at":"2016-01-05T16:07:56Z","updated_at":"2016-01-05T16:07:56Z","body":"@rossmcdonald all is right. That kind of select was my first attempt, but it didn't work. Instead of the expected outcome, with the inserted record count, influx shows my the select results.\r\n\r\nI updated influxdb from the 0.9.4.2 to the latest stable version 0.9.6.1 and now it works, even though\r\n> the INTO statement does not work in 0.9 except as part of creating a continuous query. \r\n\r\nas @beckettsean said."}}