Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@dsmdavid

dsmdavid/data_validation_hash.sql

Created December 1, 2022 10:02
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dsmdavid/fc3a5d6878f021f7314e536748129b8b to your computer and use it in GitHub Desktop.
Save dsmdavid/fc3a5d6878f021f7314e536748129b8b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
data_validation_hash.sql
-- ~4m25 (17487 rows)
select
*
from "TEST_DB"."DAVID_TEST"."LINEITEM_ORIGINAL"
where hash(L_COMMENT,L_SUPPKEY,L_DISCOUNT,L_EXTENDEDPRICE,L_COMMITDATE,L_LINESTATUS,L_QUANTITY,L_RETURNFLAG,L_LINENUMBER,L_PARTKEY,L_SHIPDATE,L_SHIPINSTRUCT,L_TAX,L_ORDERKEY,L_RECEIPTDATE,L_SHIPMODE)
not in (select
hash(L_COMMENT,L_SUPPKEY,L_DISCOUNT,L_EXTENDEDPRICE,L_COMMITDATE,L_LINESTATUS,L_QUANTITY,L_RETURNFLAG,L_LINENUMBER,L_PARTKEY,L_SHIPDATE,L_SHIPINSTRUCT,L_TAX,L_ORDERKEY,L_RECEIPTDATE,L_SHIPMODE)
from "TEST_DB"."DAVID_TEST"."LINEITEM_FEW_CHANGES");
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment