pig scripts for final docsim raport