Remove unnecessary projects

Remove unnecessary project and Hive queries.