Teradata QueryGrid supports the following SQL statements when Hive is the target connector:
- SELECT
- INSERT
- HELP, SHOW, or DESCRIBE (depending on the syntax of the initiator connector; for example, HELP FOREIGN is used when Teradata is the initiator connector)
- EXPLAIN INSERT and EXPLAIN SELECT
The Hive connector supports predicate pushdown by default. Hive target connectors support the following logical expressions as pushdown predicates: And, Or, Not, Gt, Lt, Le, Ge, Ne, Eq, Case, IsNULL, Between, Abs, Concat, Lower, Upper, Like, Plus, Minus, Mult, Div, In, and NOT IN.
Predicate pushdown can be disabled by setting the disablePushdown property to TRUE. See Hive Connector and Link Properties.