In Hive, multiple tables can be created for a single data file using the same HDFS directory. As we know already that metastore acts as the central repository for Hive metadata and it stores metadata like schemas and locations.   Data already remain in the same file. So, it becomes a very easy task to retrieve the different results for the corresponding same data based upon the schema.