- Page 3 of 20 - Learning Computer Science and Programming

Explode function in Hive with examples

Explode function in Hive Explode is a User Defined Table generating Function(UDTF) in Hive. It takes an array (or a

Export data to a file in BigQuery After loading the data into BigQuery table, we may need that data in

Row_number function in Oracle Row_number is an analytical function. It assigns a unique sequential number to each row according to

Views in BigQuery A view is a virtual table. It logically represents subsets of data from one or more tables.

BigQuery Substring Substring function is used to extract the portion of the string from a given string. Since Substring is

Delete statement in BigQuery Delete statement allows us to delete rows from a table. To perform the delete operation in

Google Cloud Storage (GCS) Google Cloud Storage is a secure and scalable storage option offered by Google. It allows us

Regexp_replace function in BigQuery The Regexp_replace function is search the given regular expression pattern in the input string. Then it

Apache Hive Apache Hive is an open source data warehousing solution build on top of Hadoop. It supports SQL-like query

Alter table statement in Hive The Alter table statement is used to change the structure of the existing table in