%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}
