[ 
https://issues.apache.org/jira/browse/IMPALA-9068?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Joe McDonnell resolved IMPALA-9068.
-----------------------------------
    Fix Version/s: Impala 3.4.0
       Resolution: Fixed

> Impala should respect the distinction between the managed warehouse and the 
> external warehouse
> ----------------------------------------------------------------------------------------------
>
>                 Key: IMPALA-9068
>                 URL: https://issues.apache.org/jira/browse/IMPALA-9068
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Infrastructure
>    Affects Versions: Impala 3.4.0
>            Reporter: Joe McDonnell
>            Priority: Blocker
>             Fix For: Impala 3.4.0
>
>
> Recent Hive 3 makes a distinction between the directory for managed tables 
> and the directory for external tables.
> {code:java}
> WAREHOUSE("metastore.warehouse.dir", "hive.metastore.warehouse.dir", 
> "/user/hive/warehouse",
>         "location of default database for the warehouse"),    
> WAREHOUSE_EXTERNAL("metastore.warehouse.external.dir",        
> "hive.metastore.warehouse.external.dir", "",
>         "Default location for external tables created in the warehouse. " +
>         "If not set or null, then the normal warehouse location will be used 
> as the default location."),
> {code}
> With HIVE-22189, Hive is militantly enforcing the distinction. It no longer 
> allows external tables in the hive.metastore.warehouse.dir (the managed 
> directory). The create table statements are currently translated to create 
> external table statements with appropriate table properties, but in order for 
> this to work correctly, we need to specify 
> hive.metastore.warehouse.external.dir to be different from 
> hive.metastore.warehouse.dir. A sensible approach is to set 
> hive.metastore.warehouse.external.dir to /test-warehouse and change 
> hive.metastore.warehouse.dir to something else, like /test-warehouse-managed.
> This will require further changes in our test infrastructure to incorporate 
> this distinction. For example, tests/comparison/cluster/cluster.py's 
> warehouse_dir needs to handle this appropriately (this is needed for 
> testdata/bin/load_nested.py). It may also require changes to some paths for 
> tests that use managed tables.
> hive.metastore.warehouse.external.dir does not exist in Hive 2, so this will 
> require some Hive 3 specific logic.



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

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to