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

Teradata® QueryGrid™ Installation and User Guide

Product
Teradata QueryGrid
Release Number
2.06
Published
September 2018
Language
English (United States)
Last Update
2018-11-26
dita:mapPath
blo1527621308305.ditamap
dita:ditavalPath
ft:empty

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.