FAQ
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+unsubscribe@cloudera.org.

Search Discussions

  • Alex Behm at Jan 16, 2014 at 2:48 am
    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 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+unsubscribe@cloudera.org.
    To unsubscribe from this group and stop receiving emails from it, send an email to impala-user+unsubscribe@cloudera.org.
  • Patrick o'leary at Jan 16, 2014 at 3:41 pm
    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.
  • Lenni Kuff at Jan 16, 2014 at 6:45 pm
    Hi,
    I believe you are hitting this issue:
    https://issues.cloudera.org/browse/IMPALA-715 which has been fixed
    recently. If you are interested in what the code change was that fixed the
    bug, look here:
    https://github.com/cloudera/Impala/commit/7c5ab558d15139c13f8d2385833bc16184bd243f

    This fix will be included in our upcoming v1.2.4 release, which will be out
    within the next 2 weeks if everything goes as planned.

    Sorry for the inconvenience.

    Thanks,
    Lenni

    On Thu, Jan 16, 2014 at 7:40 AM, Patrick o'leary wrote:

    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 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.
    To unsubscribe from this group and stop receiving emails from it, send
    an email to impala-user+unsubscribe@cloudera.org.
    To unsubscribe from this group and stop receiving emails from it, send an email to impala-user+unsubscribe@cloudera.org.
  • Patrick o'leary at Jan 16, 2014 at 8:18 pm
    Ok great, I'm going to hold off rolling my own, managed installs are the
    way to go.
    Looking forward to the release !

    Thanks
    Patrick
    On Thursday, January 16, 2014 1:45:38 PM UTC-5, lskuff wrote:

    Hi,
    I believe you are hitting this issue:
    https://issues.cloudera.org/browse/IMPALA-715 which has been fixed
    recently. If you are interested in what the code change was that fixed the
    bug, look here:
    https://github.com/cloudera/Impala/commit/7c5ab558d15139c13f8d2385833bc16184bd243f

    This fix will be included in our upcoming v1.2.4 release, which will be
    out within the next 2 weeks if everything goes as planned.

    Sorry for the inconvenience.

    Thanks,
    Lenni


    On Thu, Jan 16, 2014 at 7:40 AM, Patrick o'leary <pj...@pjaol.com<javascript:>
    wrote:
    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 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.
    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.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupimpala-user @
categorieshadoop
postedJan 15, '14 at 8:28p
activeJan 16, '14 at 8:18p
posts5
users3
websitecloudera.com
irc#hadoop

People

Translate

site design / logo © 2022 Grokbase