Hi Sean, Thank you so much and how embarrassing - it was "months", not "month". It is all working now.
Million apologies for wasting your time!!!! Thanks, Tanya On 14 September 2016 at 08:04, Sean Beckett <[email protected]> wrote: > 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/unsub >>>>>>>>>> scribe. >>>>>>>>>> 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/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/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/ms >> gid/influxdb/CAAHSRnD8LpaAPV457Gk4wFw_o%3D2oS5YRB6hRd1UxAsDX >> WZiE3Q%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 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/CALGqCvP2yXP09sPsDkZT2MfnztuXpJtGVqpDUEpZfcotzTsc%3Dg% > 40mail.gmail.com > <https://groups.google.com/d/msgid/influxdb/CALGqCvP2yXP09sPsDkZT2MfnztuXpJtGVqpDUEpZfcotzTsc%3Dg%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/CAAHSRnCXctg5ie%2BSMhXWwdmx_PJDxHpbwXrhwjV%2BQV-tr0s_7Q%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
