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]> 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/ms >>> gid/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]. > 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/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/CALGqCvMKeTEkXU_%2Bt2EbOeY%2BUf6uuCrukJqgR%2BiU4npk8KdDUQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
