The snapshot filesets cannot be explored through hive. If you try, you get an error like:
This is because the create table statement for a fileset sets the Hive table location to the base path of the FileSet. The error happens if you don't tell Hive that subdirectories are supported. Though even if we set that subdirectories are supported, it wouldn't be enough in this particular use case.
This is because the fileset uses other directories in its basepath to perform some data swapping, and those directories shouldn't be explorable. So we would need some way to set the explore location when creating the dataset.