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]. 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/CALGqCvMgJ3RUZ3wa%2B_cLURv2BiV9AK%3D_0W29Qs7AoLCGCw904A%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
