Naveen Gangam created HIVE-24396:
------------------------------------

             Summary: [New Feature] Add data connector support for remote 
datasources
                 Key: HIVE-24396
                 URL: https://issues.apache.org/jira/browse/HIVE-24396
             Project: Hive
          Issue Type: Improvement
          Components: Hive
            Reporter: Naveen Gangam
            Assignee: Naveen Gangam


This feature work is to be able to support in Hive Metastore to be able to 
configure data connectors for remote datasources and map databases. We 
currently have support for remote tables via StorageHandlers like 
JDBCStorageHandler and HBaseStorageHandler.

Data connectors are a natural extension to this where we can map an entire 
database or catalogs instead of individual tables. The tables within are 
automagically mapped at runtime. The metadata for these tables are not 
persisted in Hive. They are always mapped and built at runtime. 

With this feature, we introduce a concept of type for Databases in Hive. NATIVE 
vs REMOTE. All current databases are NATIVE. To create a REMOTE database, the 
following syntax is to be used
CREATE REMOTE DATABASE remote_db USING <dataconnector> WITH DCPROPERTIES (....);

Will attach a design doc to this jira. 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to