“Hive” stores table data

hive architecture
  • 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/conf directory 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.

Categorized in:

Hive

Tagged in:

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,