Snowflake

COMPARE WHETHER TWO TABLES CONTAIN THE SAME DATA OR NOT USING HASH_AGG IN SNOWFLAKE.

Snowflake has one cool function called HASH_AGG which returns a 64 bit signed hash value over the set of inputs column. As the snowflake document itself mentioned, “HASH_AGG is not a cryptographic hash function and should not be used as such”. We can use it to compare whether two columns or sets of columns value are identical or not.

process control block,operating system

Open Source Operating Systems

Open Source refers to any program whose source code is made available for use or modification as users other developers see fit. Usually, this kind of operating system is developed as a public collaboration and made freely available to everyone. Most of the open-source operating system was released under a license where the copyright holder allows others to study, change as well as distribute software to other people

Operating System Variations

The operating system(OS) is the collection of software that directs a computer’s operations, controlling and scheduling the execution of other programs, and managing storage, input/output,and communication resources.Basically, the operating system is an interface between the user and machine. It helps user to communicate with machines. Below are the list of widely used variations of the operating system…