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 "Riza Suminto (Jira)" <ji...@apache.org> on 2023/06/08 20:23:00 UTC
[jira] [Created] (IMPALA-12196) Cost based planner hit AnalysisException if run with impala-shell and REQUEST_POOL=""
Riza Suminto created IMPALA-12196:
-------------------------------------
Summary: Cost based planner hit AnalysisException if run with impala-shell and REQUEST_POOL=""
Key: IMPALA-12196
URL: https://issues.apache.org/jira/browse/IMPALA-12196
Project: IMPALA
Issue Type: Bug
Components: Frontend
Affects Versions: Impala 4.3.0
Reporter: Riza Suminto
Assignee: Riza Suminto
SET REQUEST_POOL=""; should have the same effect as UNSET REQUEST_POOL;.
However, the former will hit AnalysisException during executor group selection, as shown in the following impala-shell session:
{code:java}
[localhost:21050] default> set compute_processing_cost=1;
COMPUTE_PROCESSING_COST set to 1
[localhost:21050] default> set request_pool=root.large;
REQUEST_POOL set to root.large
[localhost:21050] default> compute stats tpcds_parquet.store_sales;
Query: compute stats tpcds_parquet.store_sales
+---------------------------------------------+
| summary |
+---------------------------------------------+
| Updated 1824 partition(s) and 22 column(s). |
+---------------------------------------------+
Fetched 1 row(s) in 7.75s
[localhost:21050] default> set request_pool="";
REQUEST_POOL set to ""
[localhost:21050] default> compute stats tpcds_parquet.store_sales;
Query: compute stats tpcds_parquet.store_sales
ERROR: AnalysisException: Request pool: "" does not map to any known executor group set.[localhost:21050] default> unset request_pool;
Unsetting option REQUEST_POOL
[localhost:21050] default> compute stats tpcds_parquet.store_sales;
Query: compute stats tpcds_parquet.store_sales
+---------------------------------------------+
| summary |
+---------------------------------------------+
| Updated 1824 partition(s) and 22 column(s). |
+---------------------------------------------+
Fetched 1 row(s) in 6.78s
[localhost:21050] default> {code}
This is the error logs in coordinator:
{code:java}
I0608 13:14:31.535946 1106693 jni-util.cc:288] ee43b616d65cfd21:081e9bf500000000] org.apache.impala.common.AnalysisException: Request pool: "" does not map to any known executor group set.
at org.apache.impala.service.Frontend.setupThresholdsForExecutorGroupSets(Frontend.java:1944)
at org.apache.impala.service.Frontend.getTExecRequest(Frontend.java:2010)
at org.apache.impala.service.Frontend.createExecRequest(Frontend.java:1834)
at org.apache.impala.service.JniFrontend.createExecRequest(JniFrontend.java:164)
I0608 13:14:31.535951 1106693 status.cc:129] ee43b616d65cfd21:081e9bf500000000] AnalysisException: Request pool: "" does not map to any known executor group set.
@ 0xfc1a83 impala::Status::Status()
@ 0x1800f48 impala::JniUtil::GetJniExceptionMsg()
@ 0x1563342 impala::JniCall::Call<>()
@ 0x15429ac impala::Frontend::GetExecRequest()
@ 0x218fa60 impala::QueryDriver::RunFrontendPlanner()
@ 0x15bb6b9 impala::ImpalaServer::ExecuteInternal()
@ 0x15bcb97 impala::ImpalaServer::Execute()
@ 0x17106e4 impala::ImpalaServer::ExecuteStatementCommon()
@ 0x1711dae impala::ImpalaServer::ExecuteStatement()
@ 0x16449b7 apache::hive::service::cli::thrift::TCLIServiceProcessorT<>::process_ExecuteStatement()
@ 0x168571d apache::hive::service::cli::thrift::TCLIServiceProcessorT<>::dispatchCall()
@ 0x1685cc2 impala::ImpalaHiveServer2ServiceProcessorT<>::dispatchCall()
@ 0xe966b1 apache::thrift::TDispatchProcessor::process()
@ 0x12d15be apache::thrift::server::TAcceptQueueServer::Task::run()
@ 0x12bde09 impala::ThriftThread::RunRunnable()
@ 0x12bfab5 boost::detail::function::void_function_obj_invoker0<>::invoke()
@ 0x18dd028 impala::Thread::SuperviseThread()
@ 0x18dde31 boost::detail::thread_data<>::run()
@ 0x23181e7 thread_proxy
@ 0x7f5204994609 start_thread
@ 0x7f52029c5133 clone {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org