The following table lists the conditions and operations that are automatically pushed down to the target connector by QueryGrid.
| Target Connector | Pushdown Conditions |
|---|---|
| Teradata | All |
| Presto | Eq, Ne, Gt, Le, Lt, And, Or, Not, Between, In, NotIn, Ge, Like, IsNULL, Case, Abs, Extract, Ln, Sqrt, Concat, Lower, Upper, Substring, Plus, Minus, Mult, Div |
| Hive | Eq, Ne, Gt, Le, Lt, And, Or, Not, Between, In, NotIn, Ge, Like, IsNULL, Case, Abs, Extract, Ln, Log, Sqrt, Concat, Lower, Upper, Plus, Minus, Mult, Div |
| Spark SQL | Eq, Ne, Gt, Le, Lt, And, Or, Not, Between, In, NotIn, Ge, Like, IsNULL, Case, Abs, Ln, Log, Sqrt, Plus, Minus, Mult, Div |
| Oracle | Eq, Ne, Gt, Le, Lt, And, Or, Not, Between, In, NotIn, Ge, Like, IsNULL, Case, Abs, Extract, Ln, Sqrt, Concat, Lower, Upper, Plus, Minus, Mult, Div |
| BigQuery | Eq, Ne, Gt, Le, Lt, And, Or, Not, Between, In, NotIn, Ge, Like, IsNULL, Case, Cast, Abs, Mod, Extract, Ln, Log, Sqrt, Concat, Lower, Upper, Substring, Trim, AO_Plus, AO_Minus, AO_Mult, AO_Div |
| Generic JDBC | Eq, Ne, Gt, Le, Lt, And, Or, Not, Between, In, NotIn, Ge, Like, IsNULL, Case, Cast, Abs, Mod, Extract, Ln, Log, Sqrt, Concat, Lower, Upper, Substring, Trim, AO_Plus, AO_Minus, AO_Mult, AO_Div |