“Hive” stores table data
- The default location of the hive table is:
/user/hive/warehouse/databasename - Go to in browser, it will take to a page with a Browse the filesystem link.
- In the
$HIVE_HOME/confdirectory there is the hive-default.xml and/or hive-site.xml which has the hive.metastore.warehouse.dir property. - That value is where the user want to navigate to after clicking the Browse the filesystem link.
- Once the user navigate to that location, they will see the names of their tables.
- Clicking on a table name (which is simply a folder) can then expose the partitions of the table.
- If you wish access to data, you can use a Hive query and output the result to a file.These will have the exact same structure (divider between columns, ect) because the files on the HDFS.