Questions tagged [polybase]
Microsoft SQL Server product to allow SQL queries against relational, Hadoop and Azure blob storage.
27 questions
1
vote
0
answers
60
views
How to let multiple SQL Server instances use PolyBase (best practice with ?Linked Servers)?
I know PolyBase can only be installed on one SQL Server instance per host.
In my setup:
Instance A already uses PolyBase for its own external data queries.
Instance B (on the same server) also needs ...
- 21
1
vote
1
answer
143
views
How do I get wildcard partition pruning in mssql 2022 , polybase and a s3-storage to work
Executing an OPENROWSET query with wildcards in the bulk path and the arguments in the WHERE clause seems not to work when using PolyBase to connect to S3-compatible storage.
I have an on-premises SQL ...
- 11
0
votes
1
answer
200
views
SQL Server 2022 - Polybase External Tables - Create a master key
SQL Server 2022, CU 10 on Windows 2022.
I am migrating a SQL Server 2019 database to a new SQL Server 2022 and when attempting to SELECT rows from an external Polybase driven table, I get the ...
user4659
1
vote
0
answers
490
views
Polybase In SQL server 2019 and 2022 take so long time
I'm using polybase to load data from PostgreSQL and have some problem
The PostgreSQl database and SQL server (for my case is SQL server 2022) are in same machine. I create an external table in SQL ...
- 11
1
vote
1
answer
745
views
ETL table from one SQL Server to another SQL Server
I would like to ETL a table from one instance of SQL Server to another instance of SQL Server. I do not want to create an SSIS package.
I have tried
to extract the data using an External Table on the ...
- 827
2
votes
0
answers
88
views
Does polybase support having a table to represent a REST API?
I have customer information in a SQL server table, and the billing information is exposed via REST web api (with customer_id as parameter).
I am exploring using polybase to create the polybase table ...
- 3,610
0
votes
1
answer
596
views
Does polybase bring entire external table data onto sql server?
I'm exploring sql polybase using Azure blob storage and other data sources.
For blob storage sql server brings the entire blob onto the server and then performs where/join.
What is the behaviour when ...
- 3,610
-2
votes
1
answer
417
views
External tables: Why create statistics?
The documentation for Polybase says that creating statistics for External Tables will help getting better execution plans. This question is about when the External Data Source is another SQL Server.
I ...
- 827
2
votes
1
answer
2k
views
PolyBase :: How to setup EXTERNAL DATA SOURCE through ODBC?
Microsoft states that:
[...You can also use the generic ODBC connector to connect to additional
providers using third-party ODBC drivers.]
The reality is much far away form that.
I've been trying to ...
- 1,705
0
votes
1
answer
812
views
PolyBase :: Changed database context to 'DWQueue'
I'm installing PolyBase on the latest SQL Server 2019.
During the installation I'm incurring in this error: https://www.youtube.com/watch?v=Oxd8yeiBfig (sorry for the video quality)
The proposed new ...
- 1,705
1
vote
0
answers
284
views
Polybase converts getdate() to the wrong format
We have two SQL Servers (both running Enterprise version on 15.0.4083.2) where we use queries to External tables via Polybase from one server to the other.
We have encountered a strange error when we ...
- 613
1
vote
2
answers
2k
views
SQL Server 2019 Polybase installation error "The proposed new database owner is already a user or aliased in the database"
I've recently performed an in-place upgrade of the default instance of a SQL Server 2016 to SQL Server 2019 (CU11).
I'm trying to add the Polybase feature but am unable to resolve this error that ...
- 146
0
votes
1
answer
882
views
Polybase with SQL Server 2019 on Linux or Containers
I would like to install SQL Server 2019 on Linux either a full Linux server (Ubuntu 18.04) or on a Docker container with Polybase. Installing MSSQL 2019 on a Linux Server or a container is relatively ...
- 21
1
vote
2
answers
373
views
Query to polybase external table giving error "Access to the remote server is denied because no login-mapping exists."
we have successfully created all pre-requisite of creating external tables using SQL Server 2017 Standard Edition CU22 Polybase.
The issue we have is the non-sysadmin login can't query those external ...
- 11
4
votes
4
answers
17k
views
Why is Microsoft SQL Server creating a ton of dump files?
How to determine what is causing Microsoft SQL Server to create dump files over and over taking up 170 GB of disk space? How do I troubleshoot what is causing the dumps?
The path of the dump files is
...
