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
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 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 readingJavascript Array with examples
Array in Javascript Array is an object in Javascript which is used to store the collection of values. Each value
Continue readingHow to create a file in vim editor and save/exit the editor
Vim editor in Linux Vim(Vi IMproved) is a widely used text editor in Linux. It is a enhanced version of
Continue readingHow to split the string by dot in Java?
Dot(.) character in Regular Expression Dot(.) is a special character in regular expression which is used to match any character.
Continue reading
