Snowflake : 8 Key Features and Functions in Snowflake Not Available in Redshift

Snowflake and Redshift are both cloud-based data warehousing solutions, but they have some differences in terms of features and functions….

Hive @

Hive : Different types of file formats supported by Hive

Apache Hive supports a variety of file formats to store and process data. These file formats can be categorized into…

Hive @

Hive : Exploring Different Types of User-Defined Functions (UDFs) in Hive

In addition to its built-in functions, Hive also supports User-Defined Functions (UDFs), which enable users to extend Hive’s functionality by…

Hive @

Hive : Understanding the MAPJOIN Operator in Hive with an Example

When dealing with large datasets, optimizing join operations is crucial to improving query performance. One of the techniques to achieve…

Hive @

Hive : Understanding the DISTRIBUTE BY Operator in Hive with an Example

One of the key features of Hive is its ability to optimize queries for improved performance. The DISTRIBUTE BY operator…

python @

Python : set object is not subscriptable – Resolved

The “set object is not subscriptable” error occurs when you try to access a set element using indexing or slicing,…


GCP : The user account authentication flow no longer works as of Febuary 1, 2023.

Since the user account authentication flow has changed, you should go ahead with the Cloud SDK installation to authenticate and…

python @

Python : How to split a list into batch of specific number in python

Here I have a list of 5500 elements , I want to split in to batches of 1000. You can use…

python @

Python : Dynamically access or modify object attributes [ getattr and setattr ]

getattr and setattr are built-in Python functions that allow you to dynamically get and set attributes of an object, respectively….


Snowflake : Sharing Data with External Organizations using Snowflake Data Share

Snowflake Data Share is a powerful feature that allows you to securely share your data with external organizations without the…