Some minor issues when using MariaDB's Connect ODBC Table_Type Engine with Microsoft Parallel Data Warehouse (PDW):
When using a Table Definition such as the following for importing a Table:
The Query works perfectly (10/10), and I am able to import my tables easily to MariaDB. However, an observed limitation is that in TABNAME option, I can only specify my table as:
- And not [db name].[schema name].[table name], which is common syntax for database / schema / table with spaces in TRANSACT-SQL.
With Microsoft PDW, using "SQL Server Native Client 11.0" it is not possible to use SRCDEF table option, as otherwise, we would obtain error:
"SQLNumResultCols: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Cursor support is not an implemented feature for SQL Server Parallel DataWarehousing TDS endpoint".
This limitation could be avoided with first method, but we are not able create table definitions as the following by means of the Table Discovery Process:
Previous Table definition would only work if we specified manually the Column Definitions.
Another issue is Datetime Precission (CONNECT Data Types), which can also be handled with querys such as:
Although a little verbose, works.
- Could TABNAME accept `[`, `]` Characters?
- Any way to make work SRCDEF with Microsoft PDW and the Discovery Process?
- Any more comfortable way to handle dates in the way shown without losing precision?