Earlier versions of Hive did not enable us to ALTER the view once it was generated, but this limitation has been removed in the later
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
Views In Apache Hive
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
Big Data & SQL 