checksums only plays nicely with order by and during repartitioning you must preserve original partition expression