The VIEW database object is one of the most often used database objects in SQL, and every SQL developer is familiar with its creation, use,
Hive Built-in Operators
When doing typical arithmetic operations or logically comparing two operands in SQL, operators are always useful; the same is true in Hive. They are divided
LIMIT with OFFSET in Hive & Impala
When the query output zooms over the top of the screen before we see it, we can use LIMIT with OFFSET to display it one
Display Built-in Functions in Impala
As noted in a previous post, SHOW FUNCTIONS by default displays user-defined functions (UDFs) and SHOW AGGREGATE FUNCTIONS displays user-defined aggregate functions (UDAFs) connected with
Hive Metadata Queries
Metadata is a type of data that describes and provides information about other types of data, such as database objects. And Hive’s metastore maintains metadata
Extended vs Formatted Table Properties – Hive
When it comes to verifying the table information, Hive offers two choices for checking its specifics. One is “Extended,” and the other is “Formatted.” Both
Big Data & SQL 