[
https://issues.apache.org/jira/browse/IMPALA-7012?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16489930#comment-16489930
]
Tianyi Wang edited comment on IMPALA-7012 at 5/24/18 10:44 PM:
---------------------------------------------------------------
This is the output at commit 4bd7cc8dbf2f07db3468e1feb595cd16a7cd81e3, the
parent of IMPALA-3916 on master:
{noformat}
ERROR: AnalysisException: Syntax error in line 1:
...nth) stored as parquet as /* +noclustered */select at1...
^
Encountered: Unknown last token with id: 212
Expected: SELECT, VALUES, WITH
CAUSED BY: Exception: Syntax error
{noformat}
The query that breaks it can be as simple as:
{noformat}
/*+*/;{noformat}
was (Author: tianyiwang):
This is the output at commit 4bd7cc8dbf2f07db3468e1feb595cd16a7cd81e3, the
parent of IMPALA-3916 on master:
{noformat}
Encountered: Unknown last token with id: 212
Expected: ALTER, COMPUTE, CREATE, DELETE, DESCRIBE, DROP, EXPLAIN, GRANT,
INSERT, INVALIDATE, LOAD, REFRESH, REVOKE, SELECT, SET, SHOW, TRUNCATE, UPDATE,
UPSERT, USE, VALUES, WITH
{noformat}
The query that breaks it can be as simple as:
{noformat}
/*+*/;{noformat}
> NullPointerException with CTAS query
> ------------------------------------
>
> Key: IMPALA-7012
> URL: https://issues.apache.org/jira/browse/IMPALA-7012
> Project: IMPALA
> Issue Type: Bug
> Components: Frontend
> Affects Versions: Impala 3.1.0
> Reporter: Tim Armstrong
> Assignee: Tianyi Wang
> Priority: Critical
>
> {noformat}
> [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
> {noformat}
> {noformat}
> 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
> {noformat}
> This is on commit hash 3e736450354e55244e16924cfeb223a30629351d . It looks
> like the code was added by IMPALA-3916
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
