Hi Fawze,   what version of the Impala JDBC driver are you using? What did you already try? The documentation of the latest version of the JDBC driver does not mention a "SID" parameter, but your connection string does. However, the documentation describes a "UID" parameter. Can you try using that one instead?   Cheers, Lars ... View more

Sure thing, I'm glad you found the culprit. 🙂 ... View more

@thewayofthinkin - I don't know for sure, but I don't think metadata is flushed periodically. There also don't seem to be any configuration options of catalogd around metadata caching. Instead, the catalog should flush metadata when requested by "invalidate metadata" or by "refresh" or when a DDL statement makes changes to a table's metadata. Such changes should show up in the logfiles however. ... View more

@thewayofthinkin   This page has information on various timeout settings for Impala: http://www.cloudera.com/documentation/enterprise/latest/topics/impala_timeouts.html   If you're using CM, then all queries should be logged and you can search for long running queries in CM. Without CM I don't know of any convenient helper, so you may have to search/filter the logfiles yourself. ... View more

That version should have been downloaded from Cloudera and as such the downloaded file comes with its own version number. The current version is 2.5.36 and can be found here: http://www.cloudera.com/downloads/connectors/impala/jdbc/2-5-36.html   Please have a look at the documentation contained in that download ("Cloudera-JDBC-Driver-for-Impala-Install-Guide.pdf"), especially at the section "Using User Name" and the "UID" parameter.   Cheers, Lars ... View more

Hi dsss,   Can you tell us which application issues the Cancel command (JDBC, ODBC)? Can you also check the log files to see what's going on? Usually grepping the logs for the query id may lead to stuck fragments or similar.   Cheers, Lars ... View more

Hi guarang,   Can you post the version of CDH and Impala you're using?   Thanks, Lars ... View more

Hi Fawze,   which JDBC driver are you using? And which version of it?   Cheers, Lars ... View more