From the course: Hadoop for Data Science Tips, Tricks, & Techniques

Unlock the full course today

Join today to access over 22,700 courses taught by industry experts or purchase this course individually.

Create flat tables for Impala

Create flat tables for Impala - Hadoop Tutorial

From the course: Hadoop for Data Science Tips, Tricks, & Techniques

Start my 1-month free trial

Create flat tables for Impala

“

- [Instructor] One of the reasons we like to flatten out tables in Hive is because we want to use Impala. Impala is a faster query engine that Cloudera offers, which is really nice especially when you're working with big data. So we've just looked at how to do a bunch with these complex structures, including how to actually flatten most of them out using the lateral view explode option. So I want to show you now just the next step, which would be to store that as a table so you can join it to other Impala objects. So I'm going to paste in a query that we just used in the previous clip. So if you didn't follow along with that one, you can either get this from the exercise files or you can just go back and follow along and write it out with me. So I'll expand this here and I'm in Hue, and I'll just go through this real quick. So we have a common table expression, which is for the select query here, which just is a lateral view explode on orders. Then we go down and we use that and we…

Contents