Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-316

External table definitions should be allowed outside of Warehouse Filesystem

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 0.4.0
    • Metastore
    • None

    Description

      I have a situation where I have hive's datastore pointed at an hdfs, but would like to create an external table on data accessable from an outside data storage solution exported via nfs.

      Presently, Warehouse.java aggregates only a single FileSystem object which limits all tables, both internal and external to being relative to the URl specified in the hive configuration. I feel like the Warehouse code should prefer to use the configured warehouse URI for non-absolute Paths, but honor paths outside of the Warehouse; particularly when they are defined in external tables.

      I was going to implement this by adding a Map of FileSystem objects to the Warehouse object. This map gets populated with FileSystem objects when operations cannot be performed by either the warehouse FS, or any other FS object in the map. I am not sure what impact this change would have on hive overall... or if this is the only place that this change would need to be made.

      Please advise.

      Attachments

        1. external_table_join.q
          0.4 kB
          Richard Lee
        2. external_table1.q
          0.3 kB
          Richard Lee
        3. external_table1.q.out
          0.7 kB
          Richard Lee
        4. hive-external-filesystems.diff
          4 kB
          Richard Lee
        5. hive-external-filesystems2.diff
          7 kB
          Richard Lee
        6. hive-external-filesystems3.diff
          16 kB
          Richard Lee
        7. hive-external-filesystems5.diff
          11 kB
          Richard Lee

        Activity

          People

            rl337 Richard Lee
            rl337 Richard Lee
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: