Create table as Select, Create table Copy and Create table Like in BigQuery
Create Table As Select (CTAS) in BigQuery The CTAS statement creates a new table by copying the schema and data
Continue readingConcat and concat_ws function in Hive with examples
Concat function in Hive The concat() function add two or more strings or bytes together. If any of the value
Continue readingHow to add a column to existing table in BigQuery?
ALTER TABLE ADD COLUMN statement Alter statement allows us to modify the structure of the existing table. Using Alter Table
Continue readingCoalesce function in Hive with examples
COALESCE function in Hive Coalesce is a conditional function in Hive which is used to handle the NULL values. It
Continue readingHow to create an external table in BigQuery?
External table in BigQuery External Data Sources The data which is not stored in the BigQuery storage is called as
Continue readingDATE_ADD function in BigQuery with examples
DATE_ADD function in BigQuery DATE_ADD is a part of DATE function in BigQuery. It add a specified time interval to
Continue readingExplode 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
Continue readingHow to export data from BigQuery table to a file in Cloud Storage?
Export data to a file in BigQuery After loading the data into BigQuery table, we may need that data in
Continue readingRow_number function in Oracle with examples
Row_number function in Oracle Row_number is an analytical function. It assigns a unique sequential number to each row according to
Continue readingHow to create a view in BigQuery?
Views in BigQuery A view is a virtual table. It logically represents subsets of data from one or more tables.
Continue reading