You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Boris Gitline (JIRA)" <ji...@apache.org> on 2019/03/12 02:16:00 UTC
[jira] [Created] (IMPALA-8301) Eliminate need for SYNC_DDL in local
catalog mode
Boris Gitline created IMPALA-8301:
-------------------------------------
Summary: Eliminate need for SYNC_DDL in local catalog mode
Key: IMPALA-8301
URL: https://issues.apache.org/jira/browse/IMPALA-8301
Project: IMPALA
Issue Type: Improvement
Reporter: Boris Gitline
In the following scenario looks like the INSERT on coordinator 2 is gated behind a long-running DDL on coordinator 1. That scenario still requires SYNC_DDL even in metadata v2. We want to change the metadata handling design so that coordinator 3 does not have to wait for the long-running DDL to complete – it would render the correct result on the target table t1 reference.
Step1. coordinator 1
##*say*, the following compute stats runs about 100 seconds
compute stats tao_ddl_contention;
[steps 2 and 3 are performed while COMPUTE STATS is running]
Step2. coordinator 2
create another new table.
create table t1(c1 int);
insert into t1 select 1 ;
select * from t1;
[can see the inserted rows]
Step3. coordinator 3
query the newly inserted rows in t1 while the COMPUTE STATS is still running:
select * from t1;
[see no rows]
##the query in [Step3] won't show the row inserted by step2 until the first step "compute stats" completed, unless:
- SYNC_DDL is set before the INSERT on coordinator 2, or
* when the step1 compute stats is completed, or
* you can see the data from this impala session, or
* a manual refresh of the t1 table.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org