By end of this chapter we have covered various SQL statements written using Impala Query Language, which can be used either with the Impala shell or directly from a web interface. When applicable, we have provided small examples of SQL statements, because in the next chapter we will take the learning from this and the previous chapters into a full-scale example, and apply these SQL statements to load data from HDFS and then run queries on it. By the time this book was ready in print, Impala 1.2.0 Beta was released with new features. It is possible that some of the features written in this chapter either work differently or require more attention. Please check the Cloudera documentation for more information regarding this.