If condition in Hive with examples
If condition/statement in Hive Hive supports many conditional functions such as If, isnull, isnotnull, nvl, nullif, COALESCE and CASE. The
Continue readingCategory: Hadoop
Sum function with Case expression in Hive
Sum() function in Hive Sum is one of the Aggregate function that returns the sum of the values of the
Continue readingHow to get the HDFS file size using WebHDFS?
WebHDFS WebHDFS is a protocol which is based on an industry-standard RESTful mechanism. It provides the same functionality as HDFS,
Continue readingFind list of databases/tables with specific pattern in Hive
Show databases like query in Hive Show databases or Show schemas statement is lists all the database names in Hive
Continue readingLength function in Hive with examples
Length function in Hive The length function returns the length of a specified string. In other words, it gives the
Continue readingRLIKE (Regular expression) function in Hive with examples
RLIKE function in Hive RLIKE function is an advanced version of LIKE operator in Hive. It is used to search
Continue readingCurrent timestamp in Hive with examples
Timestamp values in Hive Timestamp values are required to capture the time along with date values. Hive provides few date
Continue readingHow to use ROW NUMBER function in Hive?
ROW_NUMBER() function in Hive Row_number is one of the analytics function in Hive. It will assign the unique number(1,2,3…) for
Continue readingRegexp_extract function in Hive with examples
Regexp_extract function in hive In the programming languages, Regular expression is used to search the certain pattern on the string
Continue readingSubstring function in Hive with examples
Hive substring : Substring is a built-in string function in Hive which is used to extract a part of a
Continue reading
