Regular expression functions identify precise patterns of characters in the given string and returns the matching text item from the string/data. Syntax: REGEXP_EXTRACT(STRING subject, STRING
Category: Apache Hive
Data Sampling Techniques – Apache Hive
Data sampling is the best practice to understand the data patterns and trends of large datasets by looking at the smaller portion of the data
Can We Create An External Table Using CTAS?
Can we create an external table using CTAS? The answer is NO. (Read till the end) As per the Hive’s documentation, CTAS has these restrictions:
Hive Internal Tables Using CTAS
In addition to previous implementations of the creation of internal tables (a.k.a. managed tables), another approach for creating internal tables is using the CTAS (create-table-as-select)
Internal Tables in Hive – Part-3
This is a continuation of “Internal Tables in Hive” from the previous article. There is an option to decide where to place the data when
Internal Tables in Hive – Part-2
This is a continuation of “Internal Tables in Hive” from the previous article. There is an option to decide where to place the data when
Big Data & SQL 