FAQ
I was trying to execute very simple query "show tables;" through JDBC on
AWS cluster.
I can execute "show tables;" using impala-shell

I0522 21:11:05.550109 15964 impala-hs2-server.cc:231] OpenSession():
request=TOpenSessionReq {
   01: client_protocol (i32) = 0,
}
I0522 21:11:05.580314 15964 impala-hs2-server.cc:312] ExecuteStatement():
request=TExecuteStatementReq {
   01: sessionHandle (struct) = TSessionHandle {
     01: sessionId (struct) = THandleIdentifier {
       01: guid (string) = "\x0fs\xf4Fj+J~\x93 N\x86\x059\xbd[",
       02: secret (string) = "F\x979l\n\x93C\xd7\xb5+O\x1ch\x9a X",
     },
   },
   02: statement (string) = "show tables;",
   03: confOverlay (map) = map<string,string>[0] {
   },
}
I0522 21:11:05.580406 15964 impala-hs2-server.cc:206] TExecuteStatementReq:
TExecuteStatementReq {
   01: sessionHandle (struct) = TSessionHandle {
     01: sessionId (struct) = THandleIdentifier {
       01: guid (string) = "\x0fs\xf4Fj+J~\x93 N\x86\x059\xbd[",
       02: secret (string) = "F\x979l\n\x93C\xd7\xb5+O\x1ch\x9a X",
     },
   },
   02: statement (string) = "show tables;",
   03: confOverlay (map) = map<string,string>[0] {
   },
}
I0522 21:11:05.580587 15964 impala-hs2-server.cc:222]
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,
}
INFO0522 21:11:05.581000 Thread-73 com.cloudera.impala.service.Frontend]
analyze query show tables;
I0522 21:11:05.617367 15964 status.cc:42] Error: Error: could not match
input
     @ 0x81012e impala::Status::Status()
     @ 0x6aad07 impala::ImpalaServer::GetExecRequest()
     @ 0x6c075c impala::ImpalaServer::ExecuteInternal()
     @ 0x6c0c8f impala::ImpalaServer::Execute()
     @ 0x6f0851 impala::ImpalaServer::ExecuteStatement()
     @ 0x857cfe
  apache::hive::service::cli::thrift::TCLIServiceProcessor::process_ExecuteStatement()
     @ 0x846576
  apache::hive::service::cli::thrift::TCLIServiceProcessor::dispatchCall()
     @ 0x6c20d6 apache::thrift::TDispatchProcessor::process()
     @ 0x128ba2d
  apache::thrift::server::TThreadPoolServer::Task::run()
     @ 0x127bdaf
  apache::thrift::concurrency::ThreadManager::Task::run()
     @ 0x127e809
  apache::thrift::concurrency::ThreadManager::Worker::run()
     @ 0x1290f06
  apache::thrift::concurrency::PthreadThread::threadMain()
     @ 0x7f065568de9a start_thread
     @ 0x7f06545934bd (unknown)
I0522 21:11:05.639767 15964 impala-hs2-server.cc:281] CloseSession():
request=TCloseSessionReq {
   01: sessionHandle (struct) = TSessionHandle {
     01: sessionId (struct) = THandleIdentifier {
       01: guid (string) = "\x0fs\xf4Fj+J~\x93 N\x86\x059\xbd[",
       02: secret (string) = "F\x979l\n\x93C\xd7\xb5+O\x1ch\x9a X",
     },
   },
}

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupimpala-user @
categorieshadoop
postedMay 22, '13 at 9:28p
activeMay 22, '13 at 9:28p
posts1
users1
websitecloudera.com
irc#hadoop

1 user in discussion

Anton: 1 post

People

Translate

site design / logo © 2022 Grokbase