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] > <javascript:>> 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] <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/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. For more options, visit https://groups.google.com/d/optout.
