Describe a scenario where 'smalls' (tiny files, scanning overhead, over partitioning) significantly impact Spark query performance. Provide a detailed analysis of the performance issues encountered and propose a solution involving repartitioning and coalescing to address these issues. Include a code snippet demonstrating the solution.