[an error occurred while processing this directive]
<div class="title">Project F: SQL-on-Hadoop BakeOff 2</div>
<p><b>performed by Group 6</b></p>
<p>
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 <a href="http://www.tpc.org/tpch/">TPC-H benchmark</a> on the SCILENS cluster of CWI.
</p>

<div class="post_title">Idea</div>
<ul>
<li>Run the TPC-H benchmark queries using Vortex</li>
<li>Run the TPC-H benchmark queries using Impala</li>
<li><i>Stretch goals: also include a throughput run with Vortex:, i.e. incl. updates and concurrent query streams</i></li>
</ul>

<div class="post_title">Technology</div>
<p>
This analysis will be using <a href="http://www.actian.com/company/news-and-events/press-releases/vectorwise-3-with-hadoop/">Actian Vortex</a> and <a href="http://www.cloudera.com/content/cloudera/en/products-and-services/cdh/impala.html">Cloudera Impala</a>. 
</p>

<div class="post_title">Data</div>
<p>
Must be generated using the TPC-H dbgen utility.
</p>

<div class="post_title">Literature</div>
<ul>
<li><a href="http://homepages.cwi.nl/~boncz/msc/2012-AndreiCosteaAdrianIonescu.pdf">Query Optimization and Execution in vectorwise MPP</a></li>
<li><a href="http://pages.cs.wisc.edu/~floratou/SQLOnHadoop.pdf">SQL-on-Hadoop: Full Circle Back to Shared-Nothing Database Architectures</a></li>
</ul>


[an error occurred while processing this directive]