2.10 - SQL Syntax for the Hive Target Connector - Teradata QueryGrid

Teradata® QueryGrid™ Installation and User Guide

prodname
Teradata QueryGrid
vrm_release
2.10
created_date
September 2019
category
Administration
Configuration
Installation
User Guide
featnum
B035-5991-099K

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.