Hive SELECT queries with Hive as the initiator are used to import data from a target data source into Hive. Teradata Fabric 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 is Teradata.
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)