Tanya, it appears to be a bug in 0.13 where the query engine won't allow time ranges older than epoch 0. That is a regression bug and I've opened an issue: https://github.com/influxdata/influxdb/issues/7194
Your writes are succeeding and the data is persisting, but the data is unqueryable until the bug is fixed. The other queries are failing to return the results because the default lower time bound is epoch 0. When you issue "SELECT * FROM hist_days" there's an implicit "WHERE time > 0 and time < now()" on that query due to internal defaults. The problem is that the query parser won't currently allow a statement like "SELECT * FROM hist_days WHERE time > '1900-01-01'", which would reset the lower bound. On Mon, Aug 22, 2016 at 10:16 PM, <tanya.unterber...@gmail.com> wrote: > Hi, > > I have a number or records that go back way before 1970. I am having > trouble inserting these records into InfluxDB. > > I tried to insert very simple records either via CLI or via curl. Either > approach does not give an error but the data doesn't get in. Alternatively > I am not queuing the database correctly. In either case I cannot see the > data I need to retrieve. > > The simplified version of the inserts and queries is as follows: > > > [xxx ~]$ curl -i -XPOST 'http://localhost:8086/write?db=history' -H > 'Content-Type: text/plain' --data-binary 'hist_days,stn_num=61310 > prcp=1,prcp_type="RAIN" -531360000000' > HTTP/1.1 204 No Content > Request-Id: a5264040-68c4-11e6-80a3-000000000000 > X-Influxdb-Version: 0.13.0 > Date: Tue, 23 Aug 2016 00:00:47 GMT > > [xxx ~]$ curl -i -XPOST 'http://localhost:8086/write?db=history' -H > 'Content-Type: text/plain' --data-binary 'hist_days,stn_num=61310 > prcp=1,prcp_type="RAIN" 531360000001' > HTTP/1.1 204 No Content > Request-Id: a7514208-68c4-11e6-80a4-000000000000 > X-Influxdb-Version: 0.13.0 > Date: Tue, 23 Aug 2016 00:00:51 GMT > > [xxx ~]$ influx > Visit https://enterprise.influxdata.com to register for updates, InfluxDB > server management, and monitoring. > Connected to http://localhost:8086 version 0.13.0 > InfluxDB shell version: 0.13.0 > > use history > Using database history > > select * from hist_days > name: hist_days > --------------- > time prcp prcp_type stn_num > 531360000001 1 RAIN 61310 > > > select * from hist_days where time < 0 > > > > > Can you please help as I need to ingest historical data!!! > > Tanks a lot, any help is appreciated. > > Tanya > > -- > Remember to include the InfluxDB version number with all issue reports > --- > You received this message because you are subscribed to the Google Groups > "InfluxDB" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to influxdb+unsubscr...@googlegroups.com. > To post to this group, send email to influxdb@googlegroups.com. > Visit this group at https://groups.google.com/group/influxdb. > To view this discussion on the web visit https://groups.google.com/d/ms > gid/influxdb/61366ffc-2c9c-4b49-8599-28de3b2b7332%40googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- Sean Beckett Director of Support and Professional Services InfluxDB -- Remember to include the InfluxDB version number with all issue reports --- You received this message because you are subscribed to the Google Groups "InfluxDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to influxdb+unsubscr...@googlegroups.com. To post to this group, send email to influxdb@googlegroups.com. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/CALGqCvPvUDGidNvzt032x0v%2BmJyfjRaUnshBDgDSZV9HVPqbnA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
