outer join
tag test data for mapred debugging
forgot to also truncate sequence table