Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more here.

Jovan Popovic

My feedback

  1. 23 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Azure Synapse Analytics » SQL/Polybase  ·  Flag idea as inappropriate…  ·  Admin →
    Jovan Popovic shared this idea  · 
  2. 154 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
  3. 452 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    37 comments  ·  Azure Synapse Analytics » SQL/Polybase  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
  4. 1,529 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    58 comments  ·  SQL Database  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Jovan Popovic commented  · 

    Polybase is not supported in Azure SQL, but there are few workarounds:
    - Use OPENROWSET function that reads file form Azure Blob Storage: https://docs.microsoft.com/en-us/archive/blogs/sqlserverstorageengine/loading-files-from-azure-blob-storage-into-azure-sql-database
    - Use External table TYPE=RDBMS to read Azure Data Lake files using Synapse SQL: https://devblogs.microsoft.com/azure-sql/read-azure-storage-files-using-synapse-sql-external-tables/
    - Use linked server (Azure SQL managed instance only) to read Azure Data Lake files using Synapse SQL: https://devblogs.microsoft.com/azure-sql/linked-server-to-synapse-sql-to-implement-polybase-like-scenarios-in-managed-instance/

  5. 5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  2 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Jovan Popovic commented  · 

    Could you include data that you used. I cannot reproduce this:

    declare @t as table (COLUMN_NAME varchar(100))
    insert into @t values('a'), ('b'), ('c'), ('d')
    SELECT STRING_AGG(COLUMN_NAME,',') WITHIN GROUP (ORDER BY COLUMN_NAME DESC) FROM @t
    --d,c,b,a
    SELECT STRING_AGG(COLUMN_NAME,',') WITHIN GROUP (ORDER BY COLUMN_NAME ASC) FROM @t
    --a,b,c,d

  6. 6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL Database  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Jovan Popovic commented  · 

    BULK INSERT statement is available in Azure SQL DB see https://docs.microsoft.com/en-us/sql/t-sql/statements/bulk-insert-transact-sql . you can specify FORMAT='CSV' option to parse CSV files.

  7. 29 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  SQL Database » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Jovan Popovic commented  · 

    Are you using user defined TVF dbo.string_split or new system TVF string_split? In your code you are using dbo.string_split that is user defined function and not built-in.
    I tried to repro this and I cannot create function dbo.tt if I don't have user defined function dbo.string_split. If I have user defined dbo.string_split or if I replace dbo.string_split with string split, export works. Example:

    alter database MyDB SET COMPATIBILITY_LEVEL = 130

    /* MUST HAVE THIS IF USING dbo.string_split below
    drop function if exists dbo.string_split
    go
    create function dbo.string_split
    (@string varchar(max), @separator varchar(1))
    returns table
    return select '1' as value
    */

    drop function if exists dbo.tt
    go
    create function dbo.tt
    (@id varchar(max))
    returns table
    return select value from dbo.string_split(@id,',')

    Note that I had to simplify example because I don't have your numbers table.

Feedback and Knowledge Base