2.06 - SQL Syntax for the Hive Initiator 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 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.