In this recipe, you will learn how to integrate Hive with Google Drill.
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.
Follow these steps to access the Hive table from Google Drill:
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 fields terminated by '\t' stored as textfile;
Once the table is created, load the data into the
Sales_Drill...