Table of Contents Previous Next


2 Architecture Overview

C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\79278d5f\Screen Shot 2017-07-25 at 10.53.56 AM.png
Figure 2.1 - Using a Hadoop distributed file system with Postgres.
When possible, the data adapter asks the Hive or Spark server to peform the actions associated with the WHERE clause of a SELECT statement. Pushing down the WHERE clause improves performance by decreasing the amount of data moving across the network. Currently push-down is not supported for:
Aggregate Functions (such as AVG, SUM, and COUNT)

2 Architecture Overview

Table of Contents Previous Next