Set allow polybase export configuration option
Applies to: SQL Server 2016 (13.x) and later versions
The allow polybase export
server configuration option allows the export of data out of SQL Server. The functionality of this configuration option is different starting with SQL Server 2022 (16.x) compared to previous versions:
- Introduced in SQL Server 2022 (16.x), the CREATE EXTERNAL TABLE AS SELECT (CETAS) statement requires the option
allow polybase export
to be enabled by usingsp_configure
. This allows for data to be exported to a CSV or Parquet file. For examples, see Use CREATE EXTERNAL TABLE AS SELECT exporting data as parquet. - In previous versions of SQL Server, enabling
allow polybase export
allows HADOOP to export data out of SQL Server to an external table. For more information, see PolyBase connectors and Export data.
The possible values are described in the following table:
Value | Meaning |
---|---|
0 | Disabled, the default setting. |
1 | Enabled |
This change takes effect immediately.
Example
The following example enables this setting.
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'allow polybase export', 1;
GO
RECONFIGURE;
GO
Next steps
Pripomienky
https://aka.ms/ContentUserFeedback.
Pripravujeme: V priebehu roka 2024 postupne zrušíme službu Problémy v službe GitHub ako mechanizmus pripomienok týkajúcich sa obsahu a nahradíme ju novým systémom pripomienok. Ďalšie informácie nájdete na stránke:Odoslať a zobraziť pripomienky pre