From 31a4c5ba17399f76d2c2d3be82cd5d3421f03e35 Mon Sep 17 00:00:00 2001
From: Jan Vales <jan@jvales.net>
Date: Wed, 15 May 2019 07:47:49 +0200
Subject: [PATCH] ex4 weitergeschrieben.

---
 ex2/main_4.tex | 28 ++++++++++++++++++++++++++++
 1 file changed, 28 insertions(+)

diff --git a/ex2/main_4.tex b/ex2/main_4.tex
index 2dfa699..c98bec0 100644
--- a/ex2/main_4.tex
+++ b/ex2/main_4.tex
@@ -1 +1,29 @@
 %ex2.4
+
+\begin{enumerate}[label=(\alph*)]
+	\item\textbf{Create a new database and create tables for all datasets listed above.}\\
+	
+	Running:
+	\begin{verbatim}rsync -vaPp --delete ~/gitstuff/adbs/ex2/hive/ \
+	e726236f@lbd.zserv.tuwien.ac.at:hive/; \
+	ssh -t e726236f@lbd.zserv.tuwien.ac.at "cd hive; hive"
+	\end{verbatim}
+	
+	once the hive-shell opens, use:
+	\begin{verbatim}source create.sql\end{verbatim}
+
+	Time taken: 31.799 seconds.
+	
+	\item\textbf{Explore how Partitions and Buckets affect joins.}\\
+	Running:
+	\begin{verbatim}rsync -vaPp --delete ~/gitstuff/adbs/ex2/hive/ \
+	e726236f@lbd.zserv.tuwien.ac.at:hive/; \
+	ssh -t e726236f@lbd.zserv.tuwien.ac.at "cd hive; hive"
+	\end{verbatim}
+	
+	once the hive-shell opens, use:
+	\begin{verbatim}source query.sql\end{verbatim}
+
+	Various experiments/attempts are documented in the \textbf{query.sql} file. 
+	You likely dont want to run that file without editing it first, as this will run all kinds of queries and it will take \textbf{really} long to complete.
+\end{enumerate}
-- 
2.43.0