Skip to Main Content
AVEVA Product Feedback


Status No status
Categories General
Created by Guest
Created on Aug 20, 2022

Polybase Support with PI SQL Client

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.
  • Attach files