The LENGTH() function returns the length of a string. Both leading and trailing spaces at the begin and end of the string is included when
Category: Apache Hive
Adding and Substracting Months to a Date – Apache Hive & Apache Impala
We addressed in the previous post that “Date” is the most significant column that helps to explain patterns, trends and even business. From diagnostic analysis
Concatenating Columns In Apache Hive & Apache Impala
The CONCAT function in Apache Hive incorporates two or more strings into a single string. This function’s behavior is the same as in relational database
LOCATE Function in Apache Hive & Apache Impala
The LOCATE function is also helpful when looking for a substring in a string, similar to the INSTR function. Note: The below specified function is
String Conversion To Map Key Values
In a key-value pair, there are two related data elements: the key is the name of a constant that determines the data set, and the
Adding and Substracting Days to a Date – Apache Hive & Impala
We addressed in the previous post that “Date” is the most significant column that helps to explain patterns, trends and even business. From diagnostic analysis
Big Data & SQL 