performed by Group 6

Running relational queries on Hadoop-based systems is an attempt of bringing the known relational model into the massively parallel world. However, the performance of these systems varies widely. Your task is to perform a comparision between two systems in this space, Actian Vortex and Cloudera Impala. The target is a 10TB implementation of the standard relational TPC-H benchmark on the SCILENS cluster of CWI.

• Run the TPC-H benchmark queries using Vortex
• Run the TPC-H benchmark queries using Impala
• Stretch goals: also include a throughput run with Vortex:, i.e. incl. updates and concurrent query streams

This analysis will be using Actian Vortex and Cloudera Impala.

Must be generated using the TPC-H dbgen utility.

• Query Optimization and Execution in vectorwise MPP
• SQL-on-Hadoop: Full Circle Back to Shared-Nothing Database Architectures