Skip to content

Learning Computer Science and Programming

Share your knowledge with other Developers in REVISIT CLASS.

Launched new portal to write and publish your article. Check it out!

  • Home
  • Programming
    • Java
    • Python
    • Go Language
    • Shell Script
    • C++
    • C Programs
    • DWQA Questions
  • Database
    • Teradata
    • Hadoop
    • GCP
    • Oracle
  • Web Technology
    • Bootstrap
    • CSS
    • PHP
    • JSON
  • Tools

Create table as Select, Create table Copy and Create table Like in BigQuery

Posted on 2nd July 20223rd July 2022 by RevisitClass

Create Table As Select (CTAS) in BigQuery The CTAS statement creates a new table by copying the schema and data

Continue reading
GCP
Leave a comment

Concat and concat_ws function in Hive with examples

Posted on 29th June 20226th December 2022 by RevisitClass

Concat function in Hive The concat() function add two or more strings or bytes together. If any of the value

Continue reading
Hadoop
Leave a comment

How to add a column to existing table in BigQuery?

Posted on 24th June 20226th July 2022 by RevisitClass

ALTER TABLE ADD COLUMN statement Alter statement allows us to modify the structure of the existing table. Using Alter Table

Continue reading
GCP
Leave a comment

Coalesce function in Hive with examples

Posted on 22nd June 202222nd June 2022 by RevisitClass

COALESCE function in Hive Coalesce is a conditional function in Hive which is used to handle the NULL values. It

Continue reading
Hadoop
Leave a comment

How to create an external table in BigQuery?

Posted on 15th June 202218th August 2022 by RevisitClass

External table in BigQuery External Data Sources The data which is not stored in the BigQuery storage is called as

Continue reading
GCP
Leave a comment

DATE_ADD function in BigQuery with examples

Posted on 13th June 202219th September 2022 by RevisitClass

DATE_ADD function in BigQuery DATE_ADD is a part of DATE function in BigQuery. It add a specified time interval to

Continue reading
GCP
Leave a comment

Explode function in Hive with examples

Posted on 10th June 202213th June 2022 by RevisitClass

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

Continue reading
Hadoop
Leave a comment

How to export data from BigQuery table to a file in Cloud Storage?

Posted on 8th June 202213th June 2022 by RevisitClass

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

Continue reading
GCP
Leave a comment

Row_number function in Oracle with examples

Posted on 6th June 202228th June 2022 by RevisitClass

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

Continue reading
Oracle
Leave a comment

How to create a view in BigQuery?

Posted on 2nd June 20226th July 2022 by RevisitClass

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

Continue reading
GCP
Leave a comment

Posts navigation

«Previous Posts 1 2 3 4 5 … 21 Next Posts»

Tags

TeradataHadoopGCPJavaShell ScriptPythonJavascriptOracleSparkExcelCSSNetworkingC ProgramsBootstrapWeb TechnologyAzureGo LanguageC++PHPStatisticsDevOpsJSON

Recent Posts

  • How to concatenate columns in Spark dataframe?
  • How to convert Pandas dataframe to Spark dataframe?
  • How to create Azure Synapse Analytics Workspace?
  • What is Azure Synapse Analytics?
  • How to get the DDL of an existing table/view in BigQuery?

Revisit Class

  • Home
  • About Us
  • Contact Us
  • Careers
  • Privacy Policy

Data Engineering

  • Teradata
  • Hadoop
  • Oracle
  • BigQuery

Programming

  • PySpark
  • Java
  • Shell script
  • C++

Web Technology

  • Javascript
  • Bootstrap
  • CSS
  • PHP