Hive Connector SQL Syntax | QueryGrid - SQL Syntax for the Hive Initiator Connector - Teradata QueryGrid

QueryGridâ„¢ Installation and User Guide - 3.08

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Lake
Product
Teradata QueryGrid
Release Number
3.08
Publication Date
July 2025
Content Type
Administration
Configuration
Installation
User Guide
Publication ID
B035-5991-065K
ft:locale
en-US
ft:lastEdition
2025-07-30
dita:mapPath
tca1747267140087.ditamap
dita:ditavalPath
ft:empty
ft:sourceId
dita
dita:id
lxg1591800469257
Product Category
Analytical Ecosystem
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.