Added ddl and hive_setup.py for scout ticket links