and the other question - is it allowed to download Cloudera ODBC Driver for Apache Hive from the cloudera web-site and install for commercial use? ... View more

2.7.0 ... View more

like i said in the beginning - this one doesn't work: "-- Request ID: 4b9a2e0a-e250-45b7-b9cc-0915f20f848f SELECT * FROM (-- Request ID: 4b9a2e0a-e250-45b7-b9cc-0915f20f848f select version()) AS Subquery__9 LIMIT 1" however, this one works fine: "SELECT * FROM (-- Request ID: 4b9a2e0a-e250-45b7-b9cc-0915f20f848f select version()) AS Subquery__9 LIMIT 1 -- Request ID: 4b9a2e0a-e250-45b7-b9cc-0915f20f848f" Though our team found a workaround, but I'm afraid this thread can't set this as resolved as the original issue still exists, i.e. any valid multi-line query starting with a comment line - returns empty response. And like i also said - this is not the case when the query is sent through JDBC. ... View more

when a comment line is in a middle of the query or at the end - it works fine. the only issue is when the commend is in the first line. ... View more

here's what i can see in the driver log: 01:09:15.229 INFO 1431732928 Simba::DSI::SharedSingletonManager::LogVersionsAndLocation: SDK Version: 10.02.03.1020 01:09:15.229 INFO 1431732928 Simba::DSI::SharedSingletonManager::LogVersionsAndLocation: DSII Version: 2.7.0.1002 01:09:15.229 INFO 1431732928 Simba::DSI::SharedSingletonManager::LogVersionsAndLocation: Executing binary located at /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so 01:09:15.229 INFO 1431732928 Simba::ODBC::Driver::Initialize: Default Database CHAR Encoding: UTF-8 01:09:15.229 INFO 1431732928 Simba::ODBC::Driver::Initialize: Default Database WCHAR Encoding: UTF-8 01:09:15.229 INFO 1431732928 Simba::ODBC::Driver::Initialize: Driver ANSI CHAR Encoding: UTF-8 01:09:15.229 INFO 1431732928 Simba::ODBC::Driver::Initialize: Driver Manager WCHAR Encoding: UTF-16LE 01:09:15.229 INFO 1431732928 Simba::ODBC::Driver::Initialize: Detected Driver Manager: unixODBC, 2.2.14 or 2.3.x branch 01:09:15.229 INFO 1431732928 Simba::ODBC::Driver::Initialize: Locale name: en_US 01:09:15.229 INFO 1431732928 Simba::ODBC::Driver::Initialize: Bitness: 64-bit 01:09:15.229 INFO 1431732928 ::CInterface::SQLAllocHandle: Allocating environment handle. 01:09:15.230 INFO 1431732928 Simba::ODBC::Environment::SQLSetEnvAttr: Attribute: SQL_ATTR_ODBC_VERSION (200) 01:09:15.230 INFO 1431732928 Simba::ODBC::EnvironmentAttributes::SetAttribute: Setting ODBC version to: 3 01:09:15.230 INFO 1431732928 Simba::ODBC::Environment::SQLGetEnvAttr: Attribute: SQL_ATTR_ODBC_VERSION (200) 01:09:15.230 INFO 1431732928 ::CInterface::SQLAllocHandle: Allocating connection handle. 01:09:15.439 INFO 1431732928 ::CInterface::SQLAllocHandle: Allocating statement handle. 01:09:15.787 INFO 1431732928 ::CInterface::SQLFreeHandle: Freeing statement handle. 01:09:15.801 INFO 1431732928 ::CInterface::SQLFreeHandle: Freeing connection handle. 01:09:15.801 INFO 1431732928 ::CInterface::SQLFreeHandle: Freeing environment handle. Does it explain anything? PS: later on i'll try to get to the hive server logs. ... View more

unfortunately  UseNativeQuery=1 hasn't helped. the issue is still reproducible. ... View more