Thank you Sean.
2016년 9월 1일 목요일 오전 5시 57분 4초 UTC+9, Sean Beckett 님의 말: > > https://github.com/influxdata/influxdb/pull/7246 should improve the speed > of those queries, and I believe it will be part of 1.0 final. > > On Tue, Aug 30, 2016 at 9:59 AM, Sean Beckett <[email protected] > <javascript:>> wrote: > >> The inverse match is a lot more records to return. There's nothing >> necessarily wrong with it taking a long time for that query to complete. >> >> How many points match the WHERE clause conditions? >> >> On Mon, Aug 29, 2016 at 7:38 PM, Jason Park <[email protected] >> <javascript:>> wrote: >> >>> Thanks Sean your reply. >>> >>> but no any difference between two queries. >>> >>> 2016년 8월 30일 화요일 오전 4시 27분 22초 UTC+9, Sean Beckett 님의 말: >>>> >>>> Try the syntax recommended on the Data Exploration page >>>> <https://influxdb.zendesk.com/agent/organizations/10271297128/>: >>>> ...where tag !~ /./ >>>> >>>> >>>> On Sun, Aug 28, 2016 at 7:30 PM, Jason Park <[email protected]> wrote: >>>> >>>>> Hi influxdata team. >>>>> >>>>> Influxdb version : 1.0.0-beta1 >>>>> OS : centos 6.7 >>>>> H/W : 32 cores CPU, 256G Mem, SSD Disk. >>>>> Measurement schema : one tag and 5 values field. >>>>> Data : 28 measurements and 500K series. >>>>> >>>>> Inserted data example when I query. >>>>> Measurements : 1xx >>>>> tag num sum avg min max >>>>> a 1 1 1 1 1 >>>>> b 1 1 1 1 1 >>>>> 2 2 2 2 2 >>>>> 10M data points in a Measurement. >>>>> >>>>> >>>>> When I query as "SELECT num, sum, avg, min, max FROM "1xx" where TIME >>>>> = xxxxxxx and tag=''"(Retrieve data point of Nil tag value), it takes 8 >>>>> seconds for response from InfluxDB >>>>> Unlike "SELECT num, sum, avg, min, max FROM "1xx" where TIME = xxxxxxx >>>>> and tag='a'" response in a few milisecond. >>>>> >>>>> Is it bug or any idea? >>>>> >>>>> Thank you. >>>>> >>>>> >>>>> >>>>> -- >>>>> 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/11600047-b08c-4044-a52b-3000e9bd5cff%40googlegroups.com >>>>> >>>>> <https://groups.google.com/d/msgid/influxdb/11600047-b08c-4044-a52b-3000e9bd5cff%40googlegroups.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] <javascript:>. >>> To post to this group, send email to [email protected] >>> <javascript:>. >>> 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/c007c03b-18ae-40cc-8044-dc663cfa2135%40googlegroups.com >>> >>> <https://groups.google.com/d/msgid/influxdb/c007c03b-18ae-40cc-8044-dc663cfa2135%40googlegroups.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 >> > > > > -- > 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/f2389610-0efc-4e77-b8c0-5e579743594c%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
