...
ODBC is one of the most established and widely supported APIs for connecting to and working with databases. The Kyvos ODBC Driver is used for Spark SQL access to the Kyvos BI Server, enabling business intelligence, analytics, and reporting.The driver is currently available for Microsoft Windows® 64-bit platform. This Driver complies with the ODBC 3.80 data standard.
Click here to download the Kyvos ODBC driver.
...
Spark Type | SQL Type |
BIGINT | SQL_BIGINT |
CHAR | SQL_CHAR |
DATE | SQL_TYPE_DATE |
DOUBLE | SQL_DOUBLE |
INT | SQL_INTEGER |
SMALLINT | SQL_SMALLINT |
STRING | SQL_VARCHAR |
TIMESTAMP | SQL_TYPE_TIMESTAMP |
TINYINT | SQL_TINYINT |
VARCHAR | SQL_VARCHAR |
BOOLEAN | SQL_BIT |
BINARY | SQL_VARBINARY |
Kyvos ODBC Driver
Windows
Mac
...
On the Kyvos ODBC Driver DSN Setup dialog, in the Properties Advance Options section, for the Rows Fetched Per Column fieldBlock property, you need to can specify the number of rows fetched in each chunk. The default value of the Rows Fetched Per Block property is 200000.
...
Windows
...
...
Note
You must provide a value ranging from 1 to 100000
To choose Mac
...
To increase the limit for the chunk size that is more than 100000at Kyvos BI Server, you need to add a the sql.hive.server2.thrift.resultset.max.fetch.size property at the connection level.
Windows
...
Mac
...
To add a property, perform the following steps.
...