Regexp_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 readingHow to execute a Select query on BigQuery using Java?
BigQuery BigQuery is a fully managed and serverless datawarehouse system. It is part of Google Cloud Platform. It can process
Continue readingHow to send Spark dataframe values as HTML table to Email?
Spark dataframe Spark dataframe is a distributed collection of rows with the same schema. The schema defines the structure of
Continue readingHow to write a Spark dataframe to Hive table in Pyspark?
Apache spark to write a Hive Table Apache Spark provides an option to read from Hive table as well as
Continue reading