Instead of joining files, you can perform operations/transformations with hive query and then final results can be written to file(parquet kind to HDFS or to local file system)   You can even use spark for transformations and joining the views. (spark will give better performance than hive sql) ... View more