I have no problems with it on my InfluxEnterprise cluster. I'm upgrading my OSS to 1.0 now to test there:
> select * from old name: old --------- time value 1684-10-19T08:00:00Z 1 1938-04-24T22:13:20Z 1 1966-10-31T14:13:20Z 1 1969-12-31T21:13:20Z 1 OSS works fine for me, too: root@sean-stable:~# influx Visit https://enterprise.influxdata.com to register for updates, InfluxDB server management, and monitoring. Connected to http://localhost:8086 version 1.0.0 InfluxDB shell version: 1.0.0 > use mydb Using database mydb > INSERT months,stn_num=66046 lsd="01/01/1832",prcp_day_cnt=1,prcp_day_cnt_qual="X",ttl_mo_prcp=55.9,ttl_mo_prcp_qual="X",data_src=1,last_update_prcp="23/07/2009" -4354905600000 > select * from months name: months ------------ time data_src last_update_prcp lsd prcp_day_cnt prcp_day_cnt_qual stn_num ttl_mo_prcp ttl_mo_prcp_qual 1969-12-31T22:47:25.0944Z 1 23/07/2009 01/01/1832 1 X 66046 55.9 X I notice that your queries are querying "month" but your inserts went to the "months" measurement. Could it be a simple syntax error? On Mon, Sep 12, 2016 at 11:45 PM, Tanya Unterberger < [email protected]> wrote: > Hi Sean, > > Thank you for such a prompt reply. However, I still cannot query the data. > > Again I ran: > > > INSERT months,stn_num=66046 lsd="01/01/1832",prcp_day_cnt= > 1,prcp_day_cnt_qual="X",ttl_mo_prcp=55.9,ttl_mo_prcp_qual= > "X",data_src=1,last_update_prcp="23/07/2009" -4354905600000 > > > SELECT * FROM month WHERE time > '1800-01-01' > > > SELECT * FROM month WHERE time > now() - 5000000w > > > The time is 01/01/1832, so querying time > '1800-01-01' should have > worked? > > Thanks, > > Tanya > > On 13 September 2016 at 02:18, Sean Beckett <[email protected]> wrote: > >> Tanya, >> >> InfluxDB uses epoch 0 and now() as the default time boundaries for >> queries. You can imagine that every query has "WHERE time > 0 AND time < >> now()" in the where clause. >> >> When you use a query like "WHERE time < 0" that replaces the upper bound, >> but the implicit lower bound is still epoch 0. In effect, your query is >> this: >> >> SELECT * FROM month WHERE time > 0 AND time < 0 >> >> As you can see, that will never have any results. To query before epoch 0 >> you need to move the lower bound of the time range, not the upper bound. >> Try something like: >> >> SELECT * FROM month WHERE time > '1950-01-01' >> or >> SELECT * FROM month WHERE time > now() - 5000w >> >> On Mon, Sep 12, 2016 at 1:05 AM, Tanya Unterberger < >> [email protected]> wrote: >> >>> Hi Sean, >>> >>> I have installed version 1.0.0. I still have an issue of querying data >>> prior to 1970. >>> >>> Am I doing anything wrong? >>> >>> My test is: >>> >>> > INSERT months,stn_num=66046 lsd="01/01/1832",prcp_day_cnt= >>> 1,prcp_day_cnt_qual="X",ttl_mo_prcp=55.9,ttl_mo_prcp_qual="X >>> ",data_src=1,last_update_prcp="23/07/2009" -4354905600000 >>> >>> > select * from month >>> > select * from month where time < 0 >>> >>> Thanks, >>> Tanya >>> >>> On 30 August 2016 at 10:22, Tanya Unterberger < >>> [email protected]> wrote: >>> >>>> Thank you!!! >>>> >>>> On 30 Aug 2016 9:28 AM, "Sean Beckett" <[email protected]> wrote: >>>> >>>>> Fixed and in the imminent RC2 release: https://github.com/in >>>>> fluxdata/influxdb/pull/7212 >>>>> >>>>> On Tue, Aug 23, 2016 at 6:35 PM, Tanya Unterberger < >>>>> [email protected]> wrote: >>>>> >>>>>> Great news, thanks a lot!!! >>>>>> >>>>>> On 24 August 2016 at 09:00, Sean Beckett <[email protected]> wrote: >>>>>> >>>>>>> It's a regression bug, so it is a priority. It's also fairly >>>>>>> trivial, so it should be quick. 1.0 will be released in early September >>>>>>> and >>>>>>> we just cut RC1 today. I would anticipate this fix being in RC2, which >>>>>>> will >>>>>>> be out later this week or early next. >>>>>>> >>>>>>> On Tue, Aug 23, 2016 at 4:51 PM, Tanya Unterberger < >>>>>>> [email protected]> wrote: >>>>>>> >>>>>>>> Hi Sean, >>>>>>>> >>>>>>>> Thank you so much for the prompt reply, much appreciated! >>>>>>>> >>>>>>>> Is it a difficult bug to fix? I.e. when can we expect it to be >>>>>>>> fixed, please? I noticed that it was assigned to the version 1.0.0. Is >>>>>>>> there an ETA for this version, please? We have a large number of >>>>>>>> historical >>>>>>>> records we need to insert and depending on whether we can query them >>>>>>>> or not >>>>>>>> we would need to consider alternative solutions. >>>>>>>> >>>>>>>> Thanks again, >>>>>>>> Tanya >>>>>>>> >>>>>>>> >>>>>>>> On 24 August 2016 at 05:26, Sean Beckett <[email protected]> wrote: >>>>>>>> >>>>>>>>> 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/infl >>>>>>>>> uxdata/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, <[email protected]> >>>>>>>>> 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 [email protected]. >>>>>>>>>> To post to this group, send email to [email protected]. >>>>>>>>>> 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/61366ffc-2c9c-4b4 >>>>>>>>>> 9-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 a topic in >>>>>>>>> the Google Groups "InfluxDB" group. >>>>>>>>> To unsubscribe from this topic, visit >>>>>>>>> https://groups.google.com/d/topic/influxdb/JSSmSp5oBaU/unsubscribe >>>>>>>>> . >>>>>>>>> To unsubscribe from this group and all its topics, send an email >>>>>>>>> to [email protected]. >>>>>>>>> To post to this group, send email to [email protected]. >>>>>>>>> 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/CALGqCvPvUDGidNvz >>>>>>>>> t032x0v%2BmJyfjRaUnshBDgDSZV9HVPqbnA%40mail.gmail.com >>>>>>>>> <https://groups.google.com/d/msgid/influxdb/CALGqCvPvUDGidNvzt032x0v%2BmJyfjRaUnshBDgDSZV9HVPqbnA%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>>>>>>> . >>>>>>>>> >>>>>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> 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 [email protected]. >>>>>>>> To post to this group, send email to [email protected]. >>>>>>>> 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/CAAHSRnDWxA78WKq% >>>>>>>> 2BVUvidt%3DO6ne3mGdNuUacQ2yUGqFCuWYSrw%40mail.gmail.com >>>>>>>> <https://groups.google.com/d/msgid/influxdb/CAAHSRnDWxA78WKq%2BVUvidt%3DO6ne3mGdNuUacQ2yUGqFCuWYSrw%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>>>>>> . >>>>>>>> >>>>>>>> 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 a topic in >>>>>>> the Google Groups "InfluxDB" group. >>>>>>> To unsubscribe from this topic, visit https://groups.google.com/d/to >>>>>>> pic/influxdb/JSSmSp5oBaU/unsubscribe. >>>>>>> To unsubscribe from this group and all its topics, send an email to >>>>>>> [email protected]. >>>>>>> To post to this group, send email to [email protected]. >>>>>>> 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/CALGqCvO05jg73WjU >>>>>>> QTeg5H%3D3bmV3wpLKWYzL-gi0qmV-PBGFiA%40mail.gmail.com >>>>>>> <https://groups.google.com/d/msgid/influxdb/CALGqCvO05jg73WjUQTeg5H%3D3bmV3wpLKWYzL-gi0qmV-PBGFiA%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>>>>> . >>>>>>> >>>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>>> >>>>>> >>>>>> -- >>>>>> 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 [email protected]. >>>>>> To post to this group, send email to [email protected]. >>>>>> 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/CAAHSRnBDeHafuNLD >>>>>> nL5sx7jxsotBVq5ttvXVZWeX_EQWO_1z2g%40mail.gmail.com >>>>>> <https://groups.google.com/d/msgid/influxdb/CAAHSRnBDeHafuNLDnL5sx7jxsotBVq5ttvXVZWeX_EQWO_1z2g%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>>>> . >>>>>> >>>>>> 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 a topic in the >>>>> Google Groups "InfluxDB" group. >>>>> To unsubscribe from this topic, visit https://groups.google.com/d/to >>>>> pic/influxdb/JSSmSp5oBaU/unsubscribe. >>>>> To unsubscribe from this group and all its topics, send an email to >>>>> [email protected]. >>>>> To post to this group, send email to [email protected]. >>>>> 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/CALGqCvNrtoRKExKS >>>>> 0ysRfhj0yW6zb9YOnZZ8e%3DvWC22tza0a5g%40mail.gmail.com >>>>> <https://groups.google.com/d/msgid/influxdb/CALGqCvNrtoRKExKS0ysRfhj0yW6zb9YOnZZ8e%3DvWC22tza0a5g%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>>> . >>>>> For more options, visit https://groups.google.com/d/optout. >>>>> >>>> >>> -- >>> 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 [email protected]. >>> To post to this group, send email to [email protected]. >>> 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/CAAHSRnBwe0%3DN23wkO22PnS%3D38xQ3zKwU8NnNVJsiDv >>> M5TuCDeA%40mail.gmail.com >>> <https://groups.google.com/d/msgid/influxdb/CAAHSRnBwe0%3DN23wkO22PnS%3D38xQ3zKwU8NnNVJsiDvM5TuCDeA%40mail.gmail.com?utm_medium=email&utm_source=footer> >>> . >>> >>> 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 a topic in the >> Google Groups "InfluxDB" group. >> To unsubscribe from this topic, visit https://groups.google.com/d/to >> pic/influxdb/JSSmSp5oBaU/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> [email protected]. >> To post to this group, send email to [email protected]. >> 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/CALGqCvOvApHZ4Aoh%2Beg%3Dx8UpBx647XtjeFW753vPiv >> FjYh5%3DYA%40mail.gmail.com >> <https://groups.google.com/d/msgid/influxdb/CALGqCvOvApHZ4Aoh%2Beg%3Dx8UpBx647XtjeFW753vPivFjYh5%3DYA%40mail.gmail.com?utm_medium=email&utm_source=footer> >> . >> >> For more options, visit https://groups.google.com/d/optout. >> > > -- > 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 [email protected]. > To post to this group, send email to [email protected]. > 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/CAAHSRnD8LpaAPV457Gk4wFw_o%3D2oS5YRB6hRd1UxAsDXWZiE3Q% > 40mail.gmail.com > <https://groups.google.com/d/msgid/influxdb/CAAHSRnD8LpaAPV457Gk4wFw_o%3D2oS5YRB6hRd1UxAsDXWZiE3Q%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > > 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 [email protected]. To post to this group, send email to [email protected]. 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/CALGqCvP2yXP09sPsDkZT2MfnztuXpJtGVqpDUEpZfcotzTsc%3Dg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
