[ https://issues.apache.org/jira/browse/IMPALA-7108?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16501571#comment-16501571 ]
Zoltán Borók-Nagy commented on IMPALA-7108: ------------------------------------------- Yes, this is also a valid workaround. In fact, earlier patch sets of IMPALA-6314 didn't have this precondition, but they set the LIMIT 2 on the child in the constructor of CardinalityCheckNode. I was just thinking that maybe it is more correct if we smart up returnsSingleRow(), but I guess it's much more difficult to get it right. Anyway, I'm OK with changing the precondition, I pushed it for review: https://gerrit.cloudera.org/#/c/10605/ > IllegalStateException hit during CardinalityCheckNode.<init> > ------------------------------------------------------------- > > Key: IMPALA-7108 > URL: https://issues.apache.org/jira/browse/IMPALA-7108 > Project: IMPALA > Issue Type: Bug > Components: Frontend > Affects Versions: Impala 3.1.0 > Reporter: Vincent Tran > Assignee: Zoltán Borók-Nagy > Priority: Major > > The following query produces an IllegalStateException: > {noformat} > [localhost:21000] tpch300_parquet> select i.* from lineitem i > where i.l_orderkey = ( select t.o_orderkey from ( select * from customer join > orders on customer.c_custkey = orders.o_custkey order by 1 limit 1) t ); > {noformat} > Could be related to the change in IMPALA-6314 > {noformat} > I0601 12:24:52.200441 6760 Frontend.java:997] Analyzing query: select i.* > from lineitem i where i.l_orderkey = ( select t.o_orderkey from ( select * > from customer join orders on customer.c_custkey = orders.o_custkey order by 1 > limit 1) t ) > I0601 12:24:52.206576 6760 Frontend.java:1009] Analysis finished. > I0601 12:24:52.210525 6760 jni-util.cc:230] java.lang.IllegalStateException > at > com.google.common.base.Preconditions.checkState(Preconditions.java:129) > at > org.apache.impala.planner.CardinalityCheckNode.<init>(CardinalityCheckNode.java:45) > at > org.apache.impala.planner.SingleNodePlanner.createInlineViewPlan(SingleNodePlanner.java:1104) > at > org.apache.impala.planner.SingleNodePlanner.createTableRefNode(SingleNodePlanner.java:1525) > at > org.apache.impala.planner.SingleNodePlanner.createTableRefsPlan(SingleNodePlanner.java:776) > at > org.apache.impala.planner.SingleNodePlanner.createSelectPlan(SingleNodePlanner.java:614) > at > org.apache.impala.planner.SingleNodePlanner.createQueryPlan(SingleNodePlanner.java:257) > at > org.apache.impala.planner.SingleNodePlanner.createSingleNodePlan(SingleNodePlanner.java:147) > at org.apache.impala.planner.Planner.createPlan(Planner.java:101) > at > org.apache.impala.service.Frontend.createExecRequest(Frontend.java:941) > at > org.apache.impala.service.Frontend.createExecRequest(Frontend.java:1062) > at > org.apache.impala.service.JniFrontend.createExecRequest(JniFrontend.java:156) > I0601 12:24:52.274375 6760 status.cc:125] IllegalStateException: null > @ 0x1891f69 impala::Status::Status() > @ 0x1e70be6 impala::JniUtil::GetJniExceptionMsg() > @ 0x1d2e909 impala::JniUtil::CallJniMethod<>() > @ 0x1d2b563 impala::Frontend::GetExecRequest() > @ 0x1d4d552 impala::ImpalaServer::ExecuteInternal() > @ 0x1d4d09a impala::ImpalaServer::Execute() > @ 0x1db742c impala::ImpalaServer::query() > @ 0x2f0641e beeswax::BeeswaxServiceProcessor::process_query() > @ 0x2f0616c beeswax::BeeswaxServiceProcessor::dispatchCall() > @ 0x2edfc2d impala::ImpalaServiceProcessor::dispatchCall() > @ 0x18502f0 apache::thrift::TDispatchProcessor::process() > @ 0x1bb1ac9 > apache::thrift::server::TAcceptQueueServer::Task::run() > @ 0x1ba90a9 impala::ThriftThread::RunRunnable() > @ 0x1baa7ad boost::_mfi::mf2<>::operator()() > @ 0x1baa643 boost::_bi::list3<>::operator()<>() > @ 0x1baa38f boost::_bi::bind_t<>::operator()() > @ 0x1baa2a2 > boost::detail::function::void_function_obj_invoker0<>::invoke() > @ 0x1bef122 boost::function0<>::operator()() > @ 0x1eda873 impala::Thread::SuperviseThread() > @ 0x1ee2a0f boost::_bi::list5<>::operator()<>() > @ 0x1ee2933 boost::_bi::bind_t<>::operator()() > @ 0x1ee28f6 boost::detail::thread_data<>::run() > @ 0x31ddbca thread_proxy > @ 0x7f1d612256ba start_thread > @ 0x7f1d60f5b41d clone > I0601 12:24:52.274433 6760 impala-server.cc:1011] UnregisterQuery(): > query_id=b64705fe2b9d154b:e7592d7800000000 > I0601 12:24:52.274439 6760 impala-server.cc:1098] Cancel(): > query_id=b64705fe2b9d154b:e7592d7800000000 > {noformat} -- This message was sent by Atlassian JIRA (v7.6.3#76005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org