We can't set SQL_ATTR_MAX_ROWS via Business Objects.  We've now generated the log file - I don't see a way to attach it here.  The only error is as follows:   Oct 30 11:06:42 INFO 392800576 Connection::SQLSetConnectAttr: Attribute: Unknown Attribute (11003) Oct 30 11:06:42 INFO 392800576 ConnectionAttributes::SetAttribute: Invalid attribute: 11003 Oct 30 11:06:42 ERROR 392800576 Connection::SQLSetConnectAttr: [Cloudera][ODBC] (10210) Attribute identifier invalid or not supported: 11003 Oct 30 11:06:42 INFO 392800576 Statement::SQLColAttributeW: FieldIdentifier: SQL_DESC_TYPE_NAME (14) Oct 30 11:06:42 INFO 392800576 Statement::SQLColAttributeW: FieldIdentifier: SQL_DESC_UNSIGNED (8) Oct 30 11:06:42 INFO 392800576 Statement::SQLSetStmtAttrW: Attribute: SQL_ATTR_ROW_ARRAY_SIZE (27)   However, this exact same error is thrown regardless of whether or not the problem occurs.  It isn't clear - to me at least - what this invalid attribute actually is.  I can post the full 300 lines from the log file but assume no one want to wade through that.  We used loglevel=5 so all we miss are TRACE statements. ... View more

I appreciate you asking and passing the information on.   I will look to see how we can set SQL_ATTR_MAX_ROWS attribute and enable logging.  If anything is output I'll see if it can be attached here.  Thanks again. ... View more

Hi, the reason we aren't using JDBC.....is it doesn't work either!  It works for us locally, but when we try server-side the error is "Fail to create an instance of Job : com/cloudera/impala/jdbc41/Driver : Unsupported major.minor version 51.0" We understand this to mean work with Java 7 not 6....so our admin has made the appropriate change but it made no difference.   So, ODBC because we have got further than we have with JDBC! ... View more

Hi, thanks for your reply.  Yes 2.5.29.   The error is "Your session timed out.  Close the Java interface and log on again"   This is slightly misleading as if you limit the number of rows to 8191 or less it will run successfully.  So an 8k row limit?  Wondering if it relates to the UTF-8 / UTF-16 / UTF-32 settings in cloudera_impalaodbc.ini and odbc.ini....we just tested changes but they were sabotaged by some empty tables. ... View more