Pages
(Move to ...)
Home
Thank You
▼
Wednesday, September 30, 2020
Chaining Common Table Expressions in Impala
›
This article will help you to learn how to implement chaining common table expressions in Cloudera's Impala....
Get the unique values from multiple CTEs - Impala
›
Often, some requests for reports seem simple and straightforward. But it is challenging to find a better solution to be applied. Cloudera...
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 log...
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 availabl...
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, i...
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 crea...
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 view CREATE VIEW Emp_View AS S...
Hive - Extended Properties
›
In this article, you will learn how to list out the properties of a database or a table in Hive. DATABASE LEVEL: DESCRIBE DATABASE db_name; ...
Hive Table Properties
›
The TBLPROPERTIES clause enables you to use your own metadata key/value pairs to tag the table definition. There are also several predefined...
Word Count in HiveQL - Explode and Split Usage
›
This article aims to explain the usage of the SPLIT function in HiveQL. If you are looking for a similar function in SQL Server, then please...
‹
›
Home
View web version