Substring function in BigQuery with examples
BigQuery Substring Substring function is used to extract the portion of the string from a given string. Since Substring is
Continue readingDelete and Truncate statement in BigQuery
Delete statement in BigQuery Delete statement allows us to delete rows from a table. To perform the delete operation in
Continue readingCreate a Hive External table on Google Cloud Storage(GCS)
Google Cloud Storage (GCS) Google Cloud Storage is a secure and scalable storage option offered by Google. It allows us
Continue readingRegexp_replace function in BigQuery with examples
Regexp_replace function in BigQuery The Regexp_replace function is search the given regular expression pattern in the input string. Then it
Continue readingParsing Hive Create table query using Apache Hive library
Apache Hive Apache Hive is an open source data warehousing solution build on top of Hadoop. It supports SQL-like query
Continue readingHow to rename a column in Hive?
Alter table statement in Hive The Alter table statement is used to change the structure of the existing table in
Continue readingHow to add partition to existing table in BigQuery?
Partitioned tables in BigQuery Partitioned table is a special table that is divided into segments called partitions. Those partitioned tables
Continue readingHow to use Qualify Row_number in BigQuery?
ROW_NUMBER() function in BigQuery Row_number is a Numbering function which is a subset of Analytic function in BigQuery. In the
Continue readingTrim function in Hive with examples
Trim function in Hive Trim function removes the extra space from both ends of the string value. In other words,
Continue readingHow to add Primary key in the Create Table statement using Parser?
Parser Parser is a program which understand the grammar of the sequence of words/sentences and produce the syntactical tree representation.
Continue reading