This case study concerns how Open Source Connections moved large amounts of US Patent and Trademark Office patent data from Cassandra to Solr. How we approached the problem, the introduction of Spark as a solution, and how to optimize Spark jobs