Hi Everybody, Please do visit my new blog that has much more information about Big Data and SQL. The site covers big data and almost all the...

There are some of the functions that hardly come into use. Often this kind of function would have so...

This article introduces the new TRANSLATE and REPLACE string functions available from version 2.9....

This article will help you to learn how to implement chaining common table expressions in Cloudera's Impala....

Often, some requests for reports seem simple and straightforward. But it is challenging to find a better solution to be applied. Cloudera...

The following commands will help in starting the services of Hive and Hive metastore in case they didn't start automatically without log...

Split  function splits the data based on the delimiter provided and it is mostly used function in Apache Hive. This function is not availabl...

As we discussed earlier, HiveQL handles structured data only, much like SQL. This doesn't mean that Hive just manages structured data, i...

Can we create a table based on a view in Hive? Yes, we can.!! Let's create "View" by combining Emp and Dept tables. -~ To crea...

In this article, you'll learn how to create a view and table based on a select statement. -~ To create a view CREATE VIEW Emp_View  AS S...