It's weird. only one point matched. Wouldn't it search tag value fully when the query WHERE condition is that tag value is Nil.
2016년 8월 31일 수요일 오전 12시 59분 57초 UTC+9, Sean Beckett 님의 말: > > 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 > -- 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/b5625ed2-817f-4c89-a175-2a3dbbb57f71%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
