This is the documentation for Cloudera ODBC Connector for Microstrategy 2.0.
Documentation for other versions is available at Cloudera.com.

Limitations of the Cloudera Connector for MicroStrategy

Users of this ODBC driver should take the time to familiarize themselves with the SQL dialects, data types, and limitations of Cloudera Impala and Apache Hive. These Big Data components are not relational database products, and do not support many of the features that are typically found in relational database systems. Missing features include the following:
  • No support for transactions.
  • No support for cursors or scrollable cursors.
  • No support for row-level inserts, updates, or deletes.
  • No explicit support for canceling a running query.
  • No support for prepared statements.

Users should also be aware that Cloudera Impala and Apache Hive implement their own dialects of SQL. These SQL dialects do not satisfy any of the ANSI SQL standards, and also include extensions to SQL that are not compatible with the ANSI standard. Apache Hive's limitations affect the driver in two ways: (1) many types of SQL statements cannot be executed through the driver because the underlying system does not support them, and (2) many functions in the ODBC API cannot be supported on top of Impala or Hive because those components do not provide the required infrastructure.

The following ODBC functions are not supported by the driver:
  • SQLBindParameter
  • SQLBrowseConnect
  • SQLBulkOperations
  • SQLCancel
  • SQLCloseCursor
  • SQLColumnPrivileges
  • SQLCopyDesc
  • SQLDataSources
  • SQLDrivers
  • SQLEndTrans
  • SQLForeignKeys
  • SQLGetCursorName
  • SQLGetDescField
  • SQLGetDescRec
  • SQLGetTypeInfo
  • SQLMoreResults
  • SQLNativeSQL
  • SQLParamOptions
  • SQLPrepare
  • SQLPrimaryKeys
  • SQLProcedureColumns
  • SQLProcedures
  • SQLSetCursorName
  • SQLSetDescField
  • SQLSetDescRec
  • SQLSetPos
  • SQLSetScrollOptions
  • SQLSpecialColumns
  • SQLStatistics
  • SQLTablePrivileges
  • SQLTransact
The driver provides support for the following ODBC functions, though bugs may be present:
  • SQLAllocConnect
  • SQLAllocEnv
  • SQLAllocHandle
  • SQLAllocStmt
  • SQLBindCol
  • SQLColAttribute
  • SQLColAttributes
  • SQLColumns
  • SQLConnect
  • SQLDescribeCol
  • SQLDescribeParam
  • SQLDisconnect
  • SQLDriverConnect
  • SQLError
  • SQLExecDirect
  • SQLExecute
  • SQLFetch
  • SQLFreeConnect
  • SQLFreeEnv
  • SQLFreeHandle
  • SQLFreeStmt
  • SQLGetConnectAttr
  • SQLGetConnectOption
  • SQLGetConnectionOption
  • SQLGetData
  • SQLGetDiagField
  • SQLGetDiagRec
  • SQLGetEnvAttr
  • SQLGetFunctions
  • SQLGetInfo
  • SQLGetStmtAttr
  • SQLGetStmtOption
  • SQLNumParams
  • SQLNumResultCols
  • SQLParamData
  • SQLPutData
  • SQLRowCount (Always returns -1)
  • SQLSetConnectAttr
  • SQLSetEnvAttr
  • SQLSetParam
  • SQLSetStmtAttr
  • SQLSetStmtOption
  • SQLTables