Working with Google Drill

In this recipe, you will learn how to integrate Hive with Google Drill.

Getting ready

Google Drill is an open source SQL query engine by Apache. Google Drill is designed in such a manner that it works on semi-structured data giving quality performance on rapidly immerging data using almost same syntax used in ANSI SQL. For integrating Hive with Google Drill, there are few prerequisites that must be met. In this topic, we will cover the use of Hive and Drill. You must have Google Drill installed on your system before going further in the topic.

How to do it…

Follow these steps to access the Hive table from Google Drill:

1. Create the table Sales_Drill through the Hive shell:

   CREATE TABLE 'Sales_drill'(
     'id' int,
     'fname' string,
     'lname' string,
     'address' string,
     'city' string,
     'state' string,
     'ip' string,
     'p_id' string,
     'dop' string)
   row format delimited...