SYMPTOM
If Strategy 10.x users look for a parameter for HIVE in ODBCConfig.ini file, none will be found.
If you have parametrized queries enable for HIVE you will see that 32 rows are inserted at a time. Users would like to know if there is a change that can be made to the number of rows.
CAUSE
In case of parameterized queries, the driver only processes parameters which are passed on by the application to the driver. In this example, ODBC 2.0 was used to communicate with the driver and for the parameterized queries, after sending the parameterized query, the application is making a call to SQLParamOptions(). This is an ODBC 2.0 function which is equivalent to following calls in ODBC 3.
SQLSetStmtAttr(hstmt, SQL_ATTR_PARAMSET_SIZE, crow, 0);
SQLSetStmtAttr(hstmt, SQL_ATTR_PARAMS_PROCESSED_PTR, piRow, 0);
The application is calling SQLParamOptions() with value 32 which means 32 values of each parameter. This means that application is only sending 32 rows to be inserted at a time. es.
The number of values to be inserted at a time is related to the parameter PARAM_QUERY_ROWSET_SIZE.
ACTION
Change the value of the PARAM_QUERY_ROWSET_SIZE.
To change the parameter PARAM_QUERY_ROWSET_SIZE, add the lines below (adjusting for a number of rows to insert at a time) to ODBCConfig.ini file which is located at <Installation Path>\Common Files\MicroStrategy\ (Windows platform) or <Installation Path>/MicroStrategy/install (Linux platform)
<DB_SECTION ID="3100">
<DATABASE>Hive</DATABASE>
<ODBC20>
<ROWSET_SIZE>160</ROWSET_SIZE>
<PARAM_QUERY_ROWSET_SIZE>327680</PARAM_QUERY_ROWSET_SIZE>
</ODBC20>
<ODBC35>
<ROWSET_SIZE>160</ROWSET_SIZE>
<PARAM_QUERY_ROWSET_SIZE>327680</PARAM_QUERY_ROWSET_SIZE>
<SCROLLABLE_CURSOR>DEFAULT</SCROLLABLE_CURSOR>
</ODBC35>
</DB_SECTION>
The parameter is an unsigned integer which means the max value is 2^32 -1 (4G).
The Strategy Internal Reference number is KB441111
