Skip to content

Instantly share code, notes, and snippets.

@crocker

crocker/spark-compare-dataframes.scala

Created February 22, 2017 15:54
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save crocker/3aab4dc71fb0a60c145f51ed5d7baca9 to your computer and use it in GitHub Desktop.
Save crocker/3aab4dc71fb0a60c145f51ed5d7baca9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
spark-compare-dataframes.scala
val today = LocalDate.now
val todayTransactions = spark.read
.option("header", "true")
.option("inferSchema", "true")
.json(s"s3n://bucket-name/${today}/transaction.json")
val yesterdayTransactions = spark.read
.option("header", "true")
.option("inferSchema", "true")
.json(s"s3n://bucket-name/${today.minusDays(1)}/transaction.json")
val difference = todayTransactions.except(yesterdayTransactions)
difference.show(25)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment