- Page 2 of 16 - Learning Computer Science and Programming

Find 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

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

Regexp_extract function in hive In the programming languages, Regular expression is used to search the certain pattern on the string

Array in Javascript Array is an object in Javascript which is used to store the collection of values. Each value

Vim editor in Linux Vim(Vi IMproved) is a widely used text editor in Linux. It is a enhanced version of

Dot(.) character in Regular Expression Dot(.) is a special character in regular expression which is used to match any character.