Hi Alex
Trimmed out some items to keep it brief, but the log doesn't shed too much
light on it either
I'm presuming it's impala::HBaseTableScanner::GetValue() ?
I0116 15:18:48.676244 4501 impala-beeswax-server.cc:140] query():
query=select * from tablename where to_col like '%......%' limit 25
I0116 15:18:48.676326 4501 impala-beeswax-server.cc:459] query: Query {
01: query (string) = "select * from tablename where to_col like
'%......%' limit 25",
03: configuration (list) = list[0] {
},
04: hadoop_user (string) = "impala",
}
I0116 15:18:48.676379 4501 impala-beeswax-server.cc:472]
TClientRequest.queryOptions: TQueryOptions {
01: abort_on_error (bool) = false,
02: max_errors (i32) = 0,
03: disable_codegen (bool) = false,
04: batch_size (i32) = 0,
05: num_nodes (i32) = 0,
06: max_scan_range_length (i64) = 0,
07: num_scanner_threads (i32) = 0,
08: max_io_buffers (i32) = 0,
09: allow_unsupported_formats (bool) = false,
10: default_order_by_limit (i64) = -1,
11: debug_action (string) = "",
12: mem_limit (i64) = 0,
13: abort_on_default_limit_exceeded (bool) = false,
14: parquet_compression_codec (i32) = 5,
15: hbase_caching (i32) = 0,
16: hbase_cache_blocks (bool) = false,
17: parquet_file_size (i64) = 0,
19: sync_ddl (bool) = false,
}
I0116 15:18:48.684437 4501 Frontend.java:443] analyze query select * from
tablename where to_col like '%.....%' limit 25
I0116 15:18:48.686939 4501 Frontend.java:472] create plan
I0116 15:18:48.752929 4501 HBaseScanNode.java:168] computeStats HbaseScan:
cardinality=24410
I0116 15:18:48.753049 4501 HBaseScanNode.java:172] computeStats HbaseScan:
#nodes=100
I0116 15:18:48.754093 4501 Planner.java:137] create plan fragments
I0116 15:18:48.754194 4501 Planner.java:139] memlimit=0
I0116 15:18:48.754351 4501 Planner.java:159] finalize plan fragments
I0116 15:18:48.754590 4501 Frontend.java:497] get scan range locations
I0116 15:18:48.761533 4501 Planner.java:1896] Estimated per-host peak
memory requirement: 1073741824
I0116 15:18:48.761615 4501 Planner.java:1897] Estimated per-host virtual
cores requirement: 1
I0116 15:18:48.762096 4501 Frontend.java:536] create result set metadata
I0116 15:18:48.762217 4501 JniFrontend.java:115] Estimated Per-Host
Requirements: Memory=1024.00MB VCores=1
PLAN FRAGMENT 0
PARTITION: UNPARTITIONED
1:EXCHANGE
limit: 25
cardinality: 25
per-host memory: unavailable
tuple ids: 0
PLAN FRAGMENT 1
PARTITION: RANDOM
STREAM DATA SINK
EXCHANGE ID: 1
UNPARTITIONED
0:SCAN HBASE
table:emaildetails
predicates: to_col LIKE '%......%'
table stats: unavailable
column stats: unavailable
limit: 25
cardinality: 24410
per-host memory: 1024.00MB
tuple ids: 0
I0116 15:18:48.763273 4501 coordinator.cc:298] Exec()
query_id=234419a5d6e26f33:685020a1f89fe59e
I0116 15:18:48.763373 4501 plan-fragment-executor.cc:80] Prepare():
query_id=234419a5d6e26f33:685020a1f89fe59e
instance_id=234419a5d6e26f33:685020a1f89fe59f
I0116 15:18:48.774529 4501 plan-fragment-executor.cc:113] descriptor table
for fragment=234419a5d6e26f33:685020a1f89fe59f
tuples:
.....
I0116 15:18:48.956434 4501 coordinator.cc:401] starting 1 backends for
query 234419a5d6e26f33:685020a1f89fe59e
I0116 15:18:48.956995 6287 impala-server.cc:1528] ExecPlanFragment()
instance_id=234419a5d6e26f33:685020a1f89fe5a0
coord=hadoop-int.dev.epals.net:22000 backend#=0
I0116 15:18:48.957034 6287 plan-fragment-executor.cc:80] Prepare():
query_id=234419a5d6e26f33:685020a1f89fe59e
instance_id=234419a5d6e26f33:685020a1f89fe5a0
I0116 15:18:48.969158 6287 plan-fragment-executor.cc:113] descriptor table
for fragment=234419a5d6e26f33:685020a1f89fe5a0
I0116 15:18:49.079332 9799 plan-fragment-executor.cc:213] Open():
instance_id=234419a5d6e26f33:685020a1f89fe5a0
I0116 15:18:49.080628 9800 plan-fragment-executor.cc:213] Open():
instance_id=234419a5d6e26f33:685020a1f89fe59f
I0116 15:18:49.182373 4501 impala-beeswax-server.cc:270]
get_results_metadata(): query_id=234419a5d6e26f33:685020a1f89fe59e
I0116 15:18:51.360126 9799 jni-util.cc:154]
java.lang.ArrayIndexOutOfBoundsException
I0116 15:18:51.400778 9799 status.cc:44] ArrayIndexOutOfBoundsException:
null
@ 0x6d800c impala::Status::Status()
@ 0x7e7a2f impala::JniUtil::GetJniExceptionMsg()
@ 0x6de2b4 impala::HBaseTableScanner::GetValue()
@ 0x9ce6ef impala::HBaseScanNode::GetNext()
@ 0x97e359 impala::PlanFragmentExecutor::GetNextInternal()
@ 0x97f0a3 impala::PlanFragmentExecutor::OpenInternal()
@ 0x97f856 impala::PlanFragmentExecutor::Open()
@ 0x732b34 impala::ImpalaServer::FragmentExecState::Exec()
@ 0x733fc4 impala::ImpalaServer::RunExecPlanFragment()
@ 0x7f039c impala::Thread::SuperviseThread()
@ 0x7f0cae boost::detail::thread_data<>::run()
@ 0xa37424 thread_proxy
@ 0x7fa80c52be9a start_thread
@ 0x7fa80b1d2cbd (unknown)
I0116 15:18:51.401486 6296 coordinator.cc:926] Cancel()
query_id=234419a5d6e26f33:685020a1f89fe59e
I0116 15:18:51.401515 6296 plan-fragment-executor.cc:415] Cancel():
instance_id=234419a5d6e26f33:685020a1f89fe59f
I0116 15:18:51.401525 6296 data-stream-mgr.cc:307] cancelling all streams
for fragment=234419a5d6e26f33:685020a1f89fe59f
I0116 15:18:51.401538 6296 data-stream-mgr.cc:175] cancelled stream:
fragment_instance_id_=234419a5d6e26f33:685020a1f89fe59f node_id=1
I0116 15:18:51.401628 6296 coordinator.cc:489] Query
id=234419a5d6e26f33:685020a1f89fe59e failed because fragment
id=234419a5d6e26f33:685020a1f89fe5a0 failed.
I0116 15:18:51.401746 4501 impala-server.cc:1192] UnregisterQuery():
query_id=234419a5d6e26f33:685020a1f89fe59e
I0116 15:18:51.401764 4501 impala-server.cc:1279] Cancel():
query_id=234419a5d6e26f33:685020a1f89fe59e
I0116 15:18:51.402464 4501 impala-server.cc:1036] Final profile for
query_id=...........
...........
I0116 15:18:51.402803 4501 data-stream-mgr.cc:279] DeregisterRecvr():
fragment_instance_id=234419a5d6e26f33:685020a1f89fe59f, node=1
I0116 15:18:51.453861 4501 impala-beeswax-server.cc:308] close():
query_id=234419a5d6e26f33:685020a1f89fe59e
I0116 15:18:51.453933 4501 impala-server.cc:1192] UnregisterQuery():
query_id=234419a5d6e26f33:685020a1f89fe59e
I0116 15:18:51.453950 4501 impala-server.cc:1279] Cancel():
query_id=234419a5d6e26f33:685020a1f89fe59e
I0116 15:18:51.503994 4501 status.cc:44] Invalid or unknown query handle
@ 0x6d800c impala::Status::Status()
@ 0x734e55 impala::ImpalaServer::CancelInternal()
@ 0x73fc62 impala::ImpalaServer::UnregisterQuery()
@ 0x78adc1 impala::ImpalaServer::close()
@ 0x8a7d4d beeswax::BeeswaxServiceProcessor::process_close()
@ 0x8a0496 beeswax::BeeswaxServiceProcessor::dispatchCall()
@ 0x750276 apache::thrift::TDispatchProcessor::process()
@ 0x132002d
apache::thrift::server::TThreadPoolServer::Task::run()
@ 0x130c42f
apache::thrift::concurrency::ThreadManager::Task::run()
@ 0x130ee89
apache::thrift::concurrency::ThreadManager::Worker::run()
@ 0x6faddb impala::ThriftThread::RunRunnable()
@ 0x6fc661
boost::detail::function::void_function_obj_invoker0<>::invoke()
@ 0x7f039c impala::Thread::SuperviseThread()
@ 0x7f0cae boost::detail::thread_data<>::run()
@ 0xa37424 thread_proxy
@ 0x7fa80c52be9a start_thread
@ 0x7fa80b1d2cbd (unknown)
I0116 15:18:51.504153 4501 impala-server.cc:1202] unknown query id:
234419a5d6e26f33:685020a1f89fe59e
Thanks
Patrick
On Wednesday, January 15, 2014 9:47:59 PM UTC-5, Alex Behm wrote:Hi Patrick,
do you mind inspecting the Impala log and see if there's a more complete
stack trace? Hard to tell what's going on.
Point your browser to impalahost:25000 and have a look under "logs".
Thanks!
Alex
On Wed, Jan 15, 2014 at 12:28 PM, Patrick o'leary <pj...@pjaol.com<javascript:>
wrote:
Performing a regular query in Impala 1.2.3-1.p0.97
select * from table where to_col like "%value%"
Returns
Bad status for request TFetchResultsReq(operationHandle=TOperationHandle(hasResultSet=True, modifiedRowCount=None, operationType=0, operationId=THandleIdentifier(secret='1J\xf7$\x1d\xa3JO\xa17\x02rZ\\zt', guid='1J\xf7$\x1d\xa3JO\xa17\x02rZ\\zt')), orientation=0, maxRows=100):
TFetchResultsResp(status=TStatus(errorCode=None, errorMessage='ArrayIndexOutOfBoundsException: null', sqlState='HY000', infoMessages=None, statusCode=3), results=None, hasMoreRows=None)
Running from impala-shell I get
ERROR: ArrayIndexOutOfBoundsException: null
ERROR: Invalid query handle
Any idea what the issue / resolution is?
To unsubscribe from this group and stop receiving emails from it, send an
email to impala-user...@cloudera.org <javascript:>.
To unsubscribe from this group and stop receiving emails from it, send an email to impala-user+unsubscribe@cloudera.org.
