2.10 - SELECT 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

Hive SELECT queries with Hive as the initiator are used to import data from a target data source into Hive. Teradata QueryGrid supports Beeline to use for Hive initiator queries.

The Hive connector supports predicate pushdown by default. Predicate pushdown can be disabled by setting the disablePushdown property to TRUE.

Example: Using SELECT with Hive as the Initiator Connector

The example shows a SELECT using the Beeline command line shell. Hive is the initiator and the target connector can be any other Teradata QueryGrid connector; for example, Teradata, Presto, or target Hive.

jdbc:hive2://localhost:10000> SELECT cardata_target.price,cardata_target.mileage,
cardata_target.make, cardata_target.model FROM cardata_target WHERE price < 10000;

Result:

+----------------------+------------------------+---------------------+--------------+
|cardata_target.price|cardata_target.mileage|cardata_target.make|cardata_target.model|
+----------------------+------------------------+---------------------+--------------+
| 8638.930895        | 25216                | Chevrolet         | AVEO               | 
| 9482.219404        | 24842                | Chevrolet         | AVEO               | 
| 8768.998585        | 35299                | Chevrolet         | AVEO               | 
| 9665.84886         | 19565                | Chevrolet         | AVEO               | 
| 9563.789309        | 19273                | Chevrolet         | AVEO               | 
| 9720.97889         | 20836                | Chevrolet         | AVEO               | 
| 9954.054174        | 37345                | Chevrolet         | AVEO               | 
| 9654.060142        | 19183                | Chevrolet         | AVEO               | 
| 9919.048185        | 34621                | Chevrolet         | AVEO               | 
| 9041.906254        | 26191                | Chevrolet         | AVEO               | 
| 9928.188175        | 29680                | Chevrolet         | AVEO               | 
| 9220.829677        | 29992                | Chevrolet         | AVEO               | 
| 9789.037676        | 22986                | Chevrolet         | AVEO               | 
| 9506.047937        | 22169                | Chevrolet         | AVEO               | 
+--------------------+----------------------+-------------------+--------------------+
15 rows selected (2.041 seconds)