Hello,
this is my first post in here. I have some issues with writing back to Hive table using odbc.
More specific, I have configured unixodbc with the Cloudera's Hive ODBC Driver (Simba). the odbc connection is fine. ODBC query load exec describe work fine, but I have some issues with `odbc insert`.
* When var is integer, the odbc insert with create, fails because the create table statement, is using `integer` which is not valid in Hive. The correct is `int`. I can bypass this issue by create the table in advance, with `odbc exec` and then try to insert data. If there is a flag or mapping table that I can modify , to change integer to int, please let me know.
* Second, and most important, is that insert fails always. The error I snot helpful ( r(682) ), so I had to turn on trace in driver and run Stata in command line. Anyway, the error is
Nov 10 09:14:03.211 TRACE 34121024 ::CInterface::SQLSetConnectAttr: +++++ enter +++++
Nov 10 09:14:03.211 TRACE 34121024 Simba::ODBC::Connection::SQLSetConnectAttr: +++++ enter +++++
Nov 10 09:14:03.211 INFO 34121024 Simba::ODBC::Connection::SQLSetConnectAttr: Attribute: SQL_ATTR_AUTOCOMMIT (102)
Nov 10 09:14:03.211 TRACE 34121024 Simba::ODBC::ConnectionState::SQLSetConnectAttr: +++++ enter +++++
Nov 10 09:14:03.219 ERROR 34121024 Simba::ODBC::Connection::SQLSetConnectAttr: [Cloudera][ODBC] (11470) Transactions are not supported.

Is there something I can tune on Stata side, to make it work?

Thanks in advance for your support.

Information:
Stata/IC 16.1 for Unix - Revision 29 Sep 2020
unixODBC: 2.3.4
OS: Ubuntu 18.04
Cloudera Hive ODBC: 2.6.9