Yes, it is possible to create more than one table for a data file. In Hive, schemas are stored in the metastore. Therefore, it is very easy to obtain the result for the corresponding data.