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