question

PalashAich-7056 avatar image
0 Votes"
PalashAich-7056 asked SumanthMarigowda-MSFT edited

Create External Table Query Taking Long Time

Hello there,

I downloaded SQL Server 2019 evaluation version and configured PolyBase to connect ADLS Gen 2 storage account.
I enabled PolyBase, created external data sources and file format. While trying to create external table, it is taking huge time. In fact the query keeps running and never succedded. Can you please suggest where to tweak.

Please refer screenshot.
84079-imgpoly.jpg

Thanks,
Palash


sql-server-generalsql-server-transact-sqlazure-data-lake-storage
imgpoly.jpg (283.1 KiB)
· 9
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Do you have the CSV directly in container? Maybe try removing first slash / in the location

0 Votes 0 ·

Thanks @VaibhavChaudhari

Please refer the screenshot for container structure.

I am using below Query to create external source and file format.

CREATE EXTERNAL DATA SOURCE AzureStorage WITH
(
TYPE = HADOOP,
LOCATION = 'wasbs://processed-data@salesplatformcds2.blob.core.windows.net',
CREDENTIAL = AzurePolyBase
);

CREATE EXTERNAL FILE FORMAT TextFile
WITH (
FORMAT_TYPE = DelimitedText,
FORMAT_OPTIONS (FIELD_TERMINATOR = ',')
);

Do I need to make any change?

84129-storageaccount.jpg


0 Votes 0 ·
storageaccount.jpg (93.1 KiB)

Are both polybase services running?

84165-image.png


0 Votes 0 ·
image.png (25.6 KiB)
Show more comments

0 Answers