In ____ type of join distribution each node participating in the query builds a hash table from only a fraction of the data.

🎲 Try a Random Question  |  Total Questions in Quiz: 37  |  🧠 Study this quiz with Flashcards
This question is part of a full practice quiz:
Apache Presto Practice Test Questions — practice the complete quiz, review flashcards, or try a random question.

Presto is a distributed query engine for big data using the SQL query language. Its architecture allows users to query data sources such as Hadoop, Cassandra, Kafka, AWS S3, Alluxio, MySQL, MongoDB and Teradata, and allows use of multiple data sources within a query.

Memory –to- Memory across the network is also used to transmit data, eliminating the need for a disc input-output transaction. Presto's performance is 5-10 times faster than Hive's because of this.


In ____ type of join distribution each node participating in the query builds a hash table from only a fraction of the data.