Input data:

>
  {
    "product_id": 1,
    "unit_price": 23.2
  },
  {
    "product_id": 4,
    "unit_price": 21.64
  },
  {
    "product_id": 2,
    "unit_price": 10.87
  }

]

Delta lake lookup table. This is same for all operations performed

Return all matching rows, generating a record for each match:

Return first matching row:

There won’t be change in the output from above since there are no duplicates in input.

 Return a count of matching rows:

Return true if matches exist, otherwise false:

Input data:

a
  {

    "product_id": 1,
    "unit_price": 23.2
  },
  {

    "product_id": 2,
    "unit_price": 21.64
  },
  {
    "product_id": 4,
    "unit_price": 10.87
  },
  
  {
    "product_id": 5,
    "unit_price": 99.32
  },
  
  {
    "product_id": 4,
    "unit_price": 20.33
  }
]

Return all matching rows, generating a record for each match:

Return first matching row:

Return true if matches exist, otherwise false:

Return a count of matching rows: