En la tabla siguiente se enumeran las condiciones y operaciones que QueryGrid aplica automáticamente en el conector de destino.
CONECTOR DE DESTINO | Condiciones aplicadas |
---|---|
Teradata | Todas |
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 |