The function MONTHS_BETWEEN returns the number of months between the dates specified. If the first expression is later than the second, the outcome is positive,
Category: Cloudera Impala
Case Conversion in Apache Hive & Apache Impala
Apache Hive provides many features that SQL developers are familiar with. The behavior in much of the functions is the same. Such functions help to
Best Example For Repeat Function In Apache Hive & Impala
When the new business rules are introduced, it might be necessary to perform any cleanup or transformations on existing data. The below is an use
Padding Functions in Apache Hive & Apache Impala
The padding functions are used to fill the left or right side of a string with a specific set of characters. These functions are useful
Comparison of two dates – Apache Hive & Apache Impala
There will be some situations where we need to compare two dates during the data analysis, to verify how many specified time intervals exist between
Finding the length of a string – Apache Hive & Apache Impala
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
Big Data & SQL 