Aggregate functions are the function that is used to compute against a "returned column of…
Tag: Database
How to choose the right database for your service – SQL vs NoSQL – Diagrammatic explanation
Structured data is for tabular datastores. Semi-structured data is for NoSQL. Unstructured data is for Blob Storage. [ We will…
What are the Optimization Techniques that you can apply on Apache Hive ?
1. Partitioning : Partitioning works by dividing the data into smaller segments, These are created using logical grouping based on…
What are the Aggregate functions in SQL ?
Aggregate functions are the function that is used to compute against a “returned column of numeric data” from your select…
Snowflake : How to load data from Amazon S3 to Snowflake table using Copy
With Snowflake COPY command you can load data from staged files on internal/external locations to an existing table or vice…
What is Snowflake Merge Command ? How to use it ?
The Snowflake Merge command will allows you to perform merge operations between two tables. The Merge operation includes Insert, Delete,…
What are the Data Processing Operators in Snowflake ?
Filter : Represents an operation that filters the records. Attributes: Filter condition – the condition used to perform filtering. Join…
What are the Query Operators supported by Snowflake
Snowflake supports most of the standard operators defined in SQL:1999. Arithmetic Operators + , – , * , / ,…
Amazon Aurora quick reference and cheat sheet.
1. Aurora is an AWS proprietary database. 2. Aurora is a fully managed service. 3. Aurora have High performance and…
Amazon Athena quick reference and cheat sheet
1. Amazon Athena is an interactive query service to analyze data in Amazon S3 using standard SQL. 2. Athena is…
Serializable isolation violation on table in Redshift : ERROR: 1023 : Resolved solution
When you run concurrent Amazon Redshift operations in different sessions, there is a probability of getting “ERROR: 1023 DETAIL: Serializable…