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
Category: RDBMS
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,
An alternative to ISNULL() and NVL() functions in Hive
The NVL() function enables you to substitute null for a more relevant alternative in the query results. This function accepts two arguments. If the first
TOP, LIMIT, ROWNUM vs DENSE_RANK
What would you do if you were asked to identify top-ten products based on their prices? In SQL Server, using a TOP clause with a
Get Table Row Count And Used Size
The following query will help you in checking the total number of rows and the size of the table(s). SELECTs.Name AS SchemaName,t.Name AS TableName,p.rows AS
Last Modified Date – Stored Procedure
Usually, several stored procedures will be provided to DBAs to deploy in the Production environment. Some of the existing stored procedures need to be replaced
Big Data & SQL 