[geomesa-dev] [JIRA] (GEOMESA-2292) Cost based query planning is not han

["Emilio Lahr-Vivaz (JIRA)" <jira@xxxxxxxxxxxxxxxxxxxxx>]

Title: Message Title

Emilio Lahr-Vivaz created an issue

GeoMesa / GEOMESA-2292

Cost based query planning is not handling 'attribute not null' queries well

Issue Type:	Bug
Assignee:	Unassigned
Created:	01/Jun/18 10:42 AM
Priority:	Major
Reporter:	Emilio Lahr-Vivaz

18/06/01 16:18:33 TRACE Explainer: Planning 'fleet' NOT (tripId IS NULL) AND timestamp < 2018-01-01T00:00:00+00:00 AND timestamp > 2017-01-01T00:00:00+00:00 AND status = 90 AND CONTAINS(POLYGON ((16.3384 48.18677, 16.3384 48.1891, 16.34338 48.1891, 16.34338 48.18677, 16.3384 48.18677)), geom) AND NOT (status IS NULL) AND NOT (timestamp IS NULL)
18/06/01 16:18:33 TRACE Explainer:   Original filter: NOT (tripId IS NULL) AND timestamp < 2018-01-01T00:00:00+00:00 AND timestamp > 2017-01-01T00:00:00+00:00 AND status = 90 AND CONTAINS(POLYGON ((16.3384 48.18677, 16.3384 48.1891, 16.34338 48.1891, 16.34338 48.18677, 16.3384 48.18677)), geom) AND NOT (status IS NULL) AND NOT (timestamp IS NULL) AND INCLUDE
18/06/01 16:18:33 TRACE Explainer:   Hints: bin[false] arrow[false] density[false] stats[false] map-aggregate[false] sampling[none]
18/06/01 16:18:33 TRACE Explainer:   Sort: none
18/06/01 16:18:33 TRACE Explainer:   Transforms: tripId=tripId;timestamp=timestamp
18/06/01 16:18:33 TRACE Explainer:   Strategy selection:
18/06/01 16:18:33 TRACE Explainer:     Query processing took 42ms and produced 4 options
18/06/01 16:18:34 TRACE Explainer:     Costs: FilterPlan[AttributeIndex[NOT (tripId IS NULL)][timestamp < 2018-01-01T00:00:00+00:00 AND timestamp > 2017-01-01T00:00:00+00:00 AND status = 90 AND CONTAINS(POLYGON ((16.3384 48.18677, 16.3384 48.1891, 16.34338 48.1891, 16.34338 48.18677, 16.3384 48.18677)), geom) AND NOT (status IS NULL) AND NOT (timestamp IS NULL)]] (Cost 0 in 4ms); FilterPlan[Z3Index[CONTAINS(POLYGON ((16.3384 48.18677, 16.3384 48.1891, 16.34338 48.1891, 16.34338 48.18677, 16.3384 48.18677)), geom) AND (timestamp < 2018-01-01T00:00:00+00:00 AND timestamp > 2017-01-01T00:00:00+00:00 AND NOT (timestamp IS NULL))][NOT (tripId IS NULL) AND status = 90 AND NOT (status IS NULL)]] (Cost 255327884 in 429ms); FilterPlan[AttributeIndex[timestamp < 2018-01-01T00:00:00+00:00 AND timestamp > 2017-01-01T00:00:00+00:00 AND NOT (timestamp IS NULL)][NOT (tripId IS NULL) AND status = 90 AND CONTAINS(POLYGON ((16.3384 48.18677, 16.3384 48.1891, 16.34338 48.1891, 16.34338 48.18677, 16.3384 48.18677)), geom) AND NOT (status IS NULL)]] (Cost 255327884 in 12ms); FilterPlan[Z2Index[CONTAINS(POLYGON ((16.3384 48.18677, 16.3384 48.1891, 16.34338 48.1891, 16.34338 48.18677, 16.3384 48.18677)), geom)][NOT (tripId IS NULL) AND timestamp < 2018-01-01T00:00:00+00:00 AND timestamp > 2017-01-01T00:00:00+00:00 AND status = 90 AND NOT (status IS NULL) AND NOT (timestamp IS NULL)]] (Cost 259812001 in 4ms)
18/06/01 16:18:34 TRACE Explainer:     Filter plan selected: FilterPlan[AttributeIndex[NOT (tripId IS NULL)][timestamp < 2018-01-01T00:00:00+00:00 AND timestamp > 2017-01-01T00:00:00+00:00 AND status = 90 AND CONTAINS(POLYGON ((16.3384 48.18677, 16.3384 48.1891, 16.34338 48.1891, 16.34338 48.18677, 16.3384 48.18677)), geom) AND NOT (status IS NULL) AND NOT (timestamp IS NULL)]]
18/06/01 16:18:34 TRACE Explainer:     Filter plans not selected: FilterPlan[Z3Index[CONTAINS(POLYGON ((16.3384 48.18677, 16.3384 48.1891, 16.34338 48.1891, 16.34338 48.18677, 16.3384 48.18677)), geom) AND (timestamp < 2018-01-01T00:00:00+00:00 AND timestamp > 2017-01-01T00:00:00+00:00 AND NOT (timestamp IS NULL))][NOT (tripId IS NULL) AND status = 90 AND NOT (status IS NULL)]], FilterPlan[Z2Index[CONTAINS(POLYGON ((16.3384 48.18677, 16.3384 48.1891, 16.34338 48.1891, 16.34338 48.18677, 16.3384 48.18677)), geom)][NOT (tripId IS NULL) AND timestamp < 2018-01-01T00:00:00+00:00 AND timestamp > 2017-01-01T00:00:00+00:00 AND status = 90 AND NOT (status IS NULL) AND NOT (timestamp IS NULL)]], FilterPlan[AttributeIndex[timestamp < 2018-01-01T00:00:00+00:00 AND timestamp > 2017-01-01T00:00:00+00:00 AND NOT (timestamp IS NULL)][NOT (tripId IS NULL) AND status = 90 AND CONTAINS(POLYGON ((16.3384 48.18677, 16.3384 48.1891, 16.34338 48.1891, 16.34338 48.18677, 16.3384 48.18677)), geom) AND NOT (status IS NULL)]]
18/06/01 16:18:34 TRACE Explainer:     Strategy selection took 463ms for 4 options

Add Comment

Get Jira notifications on your phone! Download the Jira Cloud app for Android or iOS
This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100086-sha1:88f2c8f)