Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

null exception from filter with Query-Time Lookup #1711

Closed
epistemancer opened this issue Sep 8, 2015 · 3 comments
Closed

null exception from filter with Query-Time Lookup #1711

epistemancer opened this issue Sep 8, 2015 · 3 comments

Comments

@epistemancer
Copy link

If a query contains a filter with a QTL extractionFn, and its intervals contain both times for which there is data and times for which there is no data, Druid returns a null exception.

For example, it's currently about 2015-09-09 00:15 UTC, and it looks like Druid contains data through about 2015-09-08 23:30. A query like:

{
  "queryType":"timeseries",
  "dataSource":"metrics",
  "granularity":"all",
  "intervals":["2015-09-02/2015-09-09"],
  "filter":{
    "type":"extraction",
    "dimension":"service",
    "value":"hadoop",
    "extractionFn":{
      "type":"regex",
      "expr":"^([^/]*).*"
    }
  },
  "aggregations":[
    {"name":"size","type":"cardinality","fieldNames":["service"],"byRow":true}
  ]
}

returns
{"error":"null exception"}

But the same query over a period with
"intervals":["2015-09-02/2015-09-08T23:00:00"]
succeeds.

Similarly, if the time range is changed to one for which the whole interval contains no data, e.g. one entirely in the future or entirely in the past before the first datum in Druid:
"intervals":["2010-09-02/2010-09-09"]
then Druid successfully returns [].

It's apparently only when the intervals contain overlaps both periods for which there is data and periods for which there is no data that there's a problem.

@epistemancer
Copy link
Author

Looks like this may have already been resolved by:
#1578

@xvrl
Copy link
Member

xvrl commented Sep 17, 2015

@epistemancer there was also a bug with regex extraction on null values #1731

@vogievetsky
Copy link
Contributor

Jonathan! Long time no see! I remember when this was filed... good times.
@fjy I believe this was resolved (as noted above) by #1578 and #1731 and can be closed.

@gianm gianm closed this as completed Aug 3, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants