How to create a external table in Hive?
External Table in Hive When we create the table in Hive, we can define the type of a table. As
Continue readingCategory: Hadoop
How to execute HiveQL queries using Shell script?
Introduction Shell script can be used to run the Hive queries in batch mode. It will handle the input values/arguments
Continue readingHow to create hourly partitions in Hive table
Hourly partitions in Hive table When we have large quantities of data, we look for partition column to improve the
Continue readingIf 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 readingSum 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 reading
