Creating a Polybase External Table with a PI SQL Client connection via ODBC causes query errors showing only it only supports column-wise binding. Polybase attempts to utilize row-wise binding which is not supported. Developers and customers have shown that Polybase is unable to be instructed to utilize column-wise binding instead.
When querying against an External Polybase Table the following errors are shown:
Function "SQLSetStmtAttr(0x2485bf85640, 5, 0x1d1f, 0)" was called.
Function "SQLSetStmtAttr" exited with an error code -1.
Error: [PI SQL Client] Only 'SQL_BIND_BY_COLUMN' is supported.