How 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 find the unused tables in Teradata?
Unused tables in Teradata In general, DBA team in the Organization allocate limited amount of Teradata space for each user(individual/batch
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 readingINSERT INTO SELECT Statement in Teradata with examples
Insert Into Select statement in Teradata Insert statement is used to insert a rows in a table. It is providing
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
