You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
For example =>
select x, y from person where x='GG' and y='3489' and y='0943'
2017-02-10 10:04:30,043] INFO filodb.spark.FiloRelation$ - Incoming filters = List(EqualTo(x,GG), EqualTo(y,3489), EqualTo(y,0943))
[2017-02-10 10:04:30,043] INFO filodb.spark.FiloRelation$ - Pushing down partition column x, filters List(EqualTo(x,GG))
[2017-02-10 10:04:30,043] INFO filodb.spark.FiloRelation$ - Pushing down partition column y, filters List(EqualTo(y,3489), EqualTo(y,0943))
[2017-02-10 10:04:30,043] INFO filodb.spark.FiloRelation$ - Push down partition predicates: List(Set(GG))
The text was updated successfully, but these errors were encountered:
parekuti
changed the title
Predicate pushdown is not working when a single table query has filters on the same column
Predicate pushdown is not working when a single table query has multiple conditions on the same column
Feb 22, 2017
To be more precise, when the same column has multiple = relations. It's arguable whether this is valid SQL or not (as it really should be OR and not AND) but we could probably parse it.
For example =>
select x, y from person where x='GG' and y='3489' and y='0943'
2017-02-10 10:04:30,043] INFO filodb.spark.FiloRelation$ - Incoming filters = List(EqualTo(x,GG), EqualTo(y,3489), EqualTo(y,0943))
[2017-02-10 10:04:30,043] INFO filodb.spark.FiloRelation$ - Pushing down partition column x, filters List(EqualTo(x,GG))
[2017-02-10 10:04:30,043] INFO filodb.spark.FiloRelation$ - Pushing down partition column y, filters List(EqualTo(y,3489), EqualTo(y,0943))
[2017-02-10 10:04:30,043] INFO filodb.spark.FiloRelation$ - Push down partition predicates: List(Set(GG))
The text was updated successfully, but these errors were encountered: