Use this clear-cut guide to install Hive on Ubuntu and get the best of both worlds. Apply a familiar SQL-like structure on all that valuable data in HDFS.
Learn how to create a table in Hive and load data. As a bonus, you will learn additional commands to display the data from the table.