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

Hive SELECT queries with Hive as the initiator are used to import data from a target data source into Hive. Teradata QueryGrid supports Beeline and Hive CLI clients 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)