[IMPALA-7012] NullPointerException with CTAS query

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: Impala 3.1.0
• Fix Version/s: Impala 3.1.0
• Component/s: Frontend
• Target Version: Impala 2.13.0, Impala 3.1.0
• Epic Color: ghx-label-1
• Assignee: Tianyi Wang
• Reporter: Tim Armstrong
• Created: 10/May/18 20:48
• Updated: 07/Jun/18 00:24
• Resolved: 06/Jun/18 00:42

Description

[localhost:21000] default> create table alltypesinsert partitioned by (year, month) stored as parquet as /* +noclustered */select at1.id, at1.bool_col, at1.tinyint_col, at1.smallint_col, at1.int_col, at1.bigint_col,                                                                                      at1.float_col, at1.double_col, at1.date_string_col, at1.string_col, at1.timestamp_col,                           
  at1.year, at2.id as month
from  functional.alltypes at1, functional.alltypes at2;
Query: create table alltypesinsert partitioned by (year, month) stored as parquet as /* +noclustered */
select at1.id, at1.bool_col, at1.tinyint_col, at1.smallint_col, at1.int_col, at1.bigint_col,
  at1.float_col, at1.double_col, at1.date_string_col, at1.string_col, at1.timestamp_col,
  at1.year, at2.id as month
from  functional.alltypes at1, functional.alltypes at2
Query submitted at: 2018-05-10 13:46:02 (Coordinator: http://tarmstrong-box:25000)
ERROR: NullPointerException: null

I0510 13:46:02.977249  4238 Frontend.java:987] Analyzing query: create table alltypesinsert partitioned by (year, month) stored as parquet as /* +noclustered */
select at1.id, at1.bool_col, at1.tinyint_col, at1.smallint_col, at1.int_col, at1.bigint_col,
  at1.float_col, at1.double_col, at1.date_string_col, at1.string_col, at1.timestamp_col,
  at1.year, at2.id as month
from  functional.alltypes at1, functional.alltypes at2
I0510 13:46:03.025013  4238 jni-util.cc:230] java.lang.NullPointerException
        at org.apache.impala.analysis.SqlScanner.isReserved(SqlScanner.java:725)
        at org.apache.impala.analysis.SqlParser.getErrorMsg(SqlParser.java:1532)
        at org.apache.impala.service.Frontend.parse(Frontend.java:975)
        at org.apache.impala.service.Frontend.createExecRequest(Frontend.java:990)
        at org.apache.impala.service.JniFrontend.createExecRequest(JniFrontend.java:156)
I0510 13:46:03.124739  4238 status.cc:125] NullPointerException: null
    @          0x18782ef  impala::Status::Status()
    @          0x1e55652  impala::JniUtil::GetJniExceptionMsg()
    @          0x1d133ed  impala::JniUtil::CallJniMethod<>()
    @          0x1d10047  impala::Frontend::GetExecRequest()
    @          0x1d3205a  impala::ImpalaServer::ExecuteInternal()
    @          0x1d31ba2  impala::ImpalaServer::Execute()
    @          0x1d9be70  impala::ImpalaServer::query()
    @          0x2ee378e  beeswax::BeeswaxServiceProcessor::process_query()
    @          0x2ee34dc  beeswax::BeeswaxServiceProcessor::dispatchCall()
    @          0x2ebcf9d  impala::ImpalaServiceProcessor::dispatchCall()
    @          0x1836690  apache::thrift::TDispatchProcessor::process()
    @          0x1b9649d  apache::thrift::server::TAcceptQueueServer::Task::run()
    @          0x1b8d9c5  impala::ThriftThread::RunRunnable()
    @          0x1b8f0c9  boost::_mfi::mf2<>::operator()()
    @          0x1b8ef5f  boost::_bi::list3<>::operator()<>()
    @          0x1b8ecab  boost::_bi::bind_t<>::operator()()
    @          0x1b8ebbe  boost::detail::function::void_function_obj_invoker0<>::invoke()
    @          0x1bd3b1a  boost::function0<>::operator()()
    @          0x1ebec51  impala::Thread::SuperviseThread()
    @          0x1ec6ded  boost::_bi::list5<>::operator()<>()
    @          0x1ec6d11  boost::_bi::bind_t<>::operator()()
    @          0x1ec6cd4  boost::detail::thread_data<>::run()
    @          0x31b3a4a  thread_proxy
    @     0x7fcf12d536ba  start_thread
    @     0x7fcf12a8941d  clone
I0510 13:46:03.124944  4238 impala-server.cc:1010] UnregisterQuery(): query_id=6b4791bb7a54de54:16bdcba700000000
I0510 13:46:03.124948  4238 impala-server.cc:1097] Cancel(): query_id=6b4791bb7a54de54:16bdcba700000000

This is on commit hash 3e736450354e55244e16924cfeb223a30629351d . It looks like the code was added by IMPALA-3916

Issue Links

• relates to: IMPALA-3916 Reserve SQL:2016 keywords