Questions tagged [polybase]

Microsoft SQL Server product to allow SQL queries against relational, Hadoop and Azure blob storage.

Filter by
Sorted by
Tagged with
0
votes
0answers
85 views

User, group, or role … already exists in the current database. Changed database context to 'DWConfiguration'. Error code: 0x84BB0001

Most of the question is in the title. My case concerns MS SQL Server 2017 - Developer Edition. The error happens during SQL Server 2017 installation process. While searching for answer online I ...
0
votes
0answers
61 views

SQL Polybase - Connect to MySQL ODBC - Issue with decimal data type

hope someone has a clue about this... I'm using SQL 2019 Polybase to connect to a MySQL 8 Server using an ODBC (MySQL 8.0.20 ODBC Driver). CREATE EXTERNAL DATA SOURCE eds_test1 WITH ( LOCATION = '...
0
votes
0answers
32 views

Problem with installation Polybase in SQL SERVER 2019 on local instance

I am trying to install Polybase on SQL Server 2019 but in process of instalation I got following error: [ZARZĄDANIE NT\USŁUGA SIECIOWA] is [NT AUTHORITY\SERVICE]. I was also trying [NT AUTHORITY\...
2
votes
0answers
82 views

SQL Server Polybase Data Movement Service stopping after few seconds

I have been scratching my head for a while now on how to fix this issue, SQL Server Polybase Data Movement Service starts successfully however after a few seconds it just stops. The OS on our server ...
1
vote
0answers
41 views

How to install PolyBase in an availability groups architecture for high availability?

Background: I’m designing a 2 node SQL 2019 availability groups installation hosted in VMs. We would have limited (single node) usage of PolyBase. The Microsoft Docs don’t reference installation for ...
1
vote
1answer
89 views

How to ignore columns in parquet/polybase import?

I'm using polybase to import a parquet file. Over time, it is likely we may add or remove named columns in the file. When I add an additional column, I get the below error: External file access ...
4
votes
1answer
655 views

Performance of Polybase

We've been experimenting with Polybase on a SQL Server 2019 (CU2) box, using SQL Server external data sources and the performance has not been good - in most cases a 1400% increase. In each case all ...
0
votes
1answer
72 views

SQL 2019 - Polybase -> Cosmos DB (MongoDB Mode) Error with dates

Im new to polybase. I have linked my SQL 2019 server to a third parties Azure cosmos and i am able to query data out of my collection. I am getting an error out when i try to query date fields though. ...
2
votes
0answers
229 views

PolyBase to CSV File

I'm trying to see if it's possible to create a PolyBase connection to a .CSV file. I'm using the Microsoft Access Text Driver and have set up a system DSN to the folder where the csv file is located. ...
1
vote
2answers
370 views

Missing Polybase enable configuration on SQL Server 2017

I installed SQL Server 2017 Enterprise (14.0.3162.1) on my box. With the polybase (Scale-out Group). But when I try to enable through: exec sp_configure @configname = 'polybase enabled', @configvalue ...
2
votes
0answers
296 views

Reading decimal mark comma with an external table

SQL-server 2016, SQL server management studio (SSMS). Creating external tables with transact-SQL and Polybase. How can we read decimals with a decimal mark, comma instead of dot? When using float and ...
5
votes
3answers
1k views

Azure SQL Warehouse - Data Ingestion - Convert a huge fixed width (with commas) file to delimited

I am not even sure if I am framing this question right, but I will try - I have a bunch of huge text files generated from an Oracle export on a Linux system. Each file is about 30 GB in size, and I ...
3
votes
1answer
3k views

Can't stop “SQL Server Polybase Data Movement”

When I start Windows the "SQL Server Polybase Data Movement" service is in the "Change pending..." state and I can't close it. When I try to stop it mmc crashes. In Windows services, the status = ...
0
votes
1answer
114 views

Polybase with Cloudera 5.9

We are working on a Proof Of Concept using Polybase with Cloudera. In the polybase documentation it says we can connect to Cloudera 5.5: https://msdn.microsoft.com/en-us/library/mt143174.aspx We ...
3
votes
1answer
803 views

How does PolyBase collect statistics from external tables?

Books online has this to say about query optimisation in PolyBase: The query optimizer makes a cost-based decision to push computation to Hadoop when doing so will improve query performance. It ...