This article introduces the new TRANSLATE and REPLACE string functions available from version 2.9.0 of Cloudera Impala. Both of these functions look identical, shifting letters
Category: Apache Hive
Starting Hive & Hive metastore from command line
The following commands will help in starting the services of Hive and Hive metastore in case they didn’t start automatically without logging into Cloudera manager.
Split equivalent in Impala
Split function splits the data based on the delimiter provided and it is mostly used function in Apache Hive. This function is not available in Impala.
Joins in HiveQL
As we discussed earlier, HiveQL handles structured data only, much like SQL. This doesn’t mean that Hive just manages structured data, it also processes and
Can we create a table based on a view in Hive?
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
Creating a table and a view with the select statement.
In this article, you’ll learn how to create a view and table based on a select statement. -~ To create a viewCREATE VIEW Emp_View ASSELECT Ename,
Big Data & SQL 