QueryGrid supports the following SQL statements from a Hive connector node when Hive is the initiator:
- SELECT
- INSERT
- SHOW
- DESCRIBE
- EXPLAIN
SQL syntax used with the Hive connector differs from Teradata SQL syntax.
The Hive connector supports predicate pushdown by default. Hive initiator connectors support the following logical expressions as pushdown predicates: And, Or, Not, Eq, NEq, LT, GT, LE, GE, Like, IsNULL, Between, In, and NOT IN.