- Learning Computer Science and Programming

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

Sum() function in Hive Sum is one of the Aggregate function that returns the sum of the values of the

Unused tables in Teradata In general, DBA team in the Organization allocate limited amount of Teradata space for each user(individual/batch

WebHDFS WebHDFS is a protocol which is based on an industry-standard RESTful mechanism. It provides the same functionality as HDFS,

Show databases like query in Hive Show databases or Show schemas statement is lists all the database names in Hive

Length function in Hive The length function returns the length of a specified string. In other words, it gives the

Insert Into Select statement in Teradata Insert statement is used to insert a rows in a table. It is providing

RLIKE function in Hive RLIKE function is an advanced version of LIKE operator in Hive. It is used to search

Timestamp values in Hive Timestamp values are required to capture the time along with date values. Hive provides few date

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