Michael Rys

← Customer Feedback for ACE Community Tooling

My feedback

  1. Organize Synapse Studio scripts and notebooks using folder

    13 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    5 comments  ·  Azure Synapse Analytics » Workspace/Other  ·  Flag idea as inappropriate…  ·  Admin →
    Michael Rys supported this idea  · 

  2. Please support XML datatype and all related routines

    4 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Azure Synapse Analytics  ·  Flag idea as inappropriate…  ·  Admin →
    Michael Rys supported this idea  · 

  3. F# support in notebooks

    4 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1 comment  ·  Azure Synapse Analytics  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Michael Rys commented  · 

    Thanks for your request Geoff. Right now we are focusing on finalizing the C# notebook experience and if we see enough requests, we will take a closer look at enabling F# as well. If you have a specific production scenario in mind, feel free to reach out to me via my twitter @MikeDoesBigData.

  4. Support for range partitioning in USQL

    3 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Data Lake  ·  Flag idea as inappropriate…  ·  Admin →
    Michael Rys supported this idea  · 

  5. Add familiar functional keywords WHILE, TOP, EXCEPT & TRY-CATCH in USQL

    3 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    2 comments  ·  Data Lake  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Michael Rys commented  · 

    We just added CASE support: https://github.com/Azure/AzureDataLake/blob/master/docs/Release_Notes/2018/2018_Spring/USQL_Release_Notes_2018_Spring.md#u-sql-supports-ansi-sql-case-expression

  6. Portal should be able to preview ORC and PARQUET Files in human readable formats

    9 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Data Lake  ·  Flag idea as inappropriate…  ·  Admin →
    Michael Rys supported this idea  · 

  7. Support of Column.Exists feature

    4 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1 comment  ·  Data Lake  ·  Flag idea as inappropriate…  ·  Admin →
    Michael Rys supported this idea  · 

  8. Provide us metadata views on ADLA (Admin Dashboard view on Analytics)

    4 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1 comment  ·  Data Lake  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Michael Rys commented  · 

    Do you mean catalog views a la usql.tables? Or some visual tool experience?

  9. Support SNAPPY compression and decompression

    4 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1 comment  ·  Data Lake  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Michael Rys commented  · 

    Parquet support with snappy is now in public preview. See https://github.com/Azure/AzureDataLake/blob/master/docs/Release_Notes/2018/2018_Spring/USQL_Release_Notes_2018_Spring.md#built-in-parquet-extractor-and-outputter-is-in-public-preview

    ORC support is in private preview.

    Are there other places you need SNAPPY support?

  10. Automatic ADLA table rebuild (i.e. compact) like in Hive

    5 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Data Lake  ·  Flag idea as inappropriate…  ·  Admin →
    Michael Rys supported this idea  · 

  11. Support for object-level (e.g. table, view) ACL

    6 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1 comment  ·  Data Lake  ·  Flag idea as inappropriate…  ·  Admin →
    Michael Rys supported this idea  · 

  12. Support for Table.Exists Feature

    7 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1 comment  ·  Data Lake  ·  Flag idea as inappropriate…  ·  Admin →
    Michael Rys supported this idea  · 

  13. USQL - Allow Constants to be assigned to Columns in the JOIN Conditions

    8 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1 comment  ·  Data Lake  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Michael Rys commented  · 

    Why can't you just move the constant comparison into the WHERE clause?

  14. Column Annotation Support

    10 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    under review  ·  1 comment  ·  Data Lake  ·  Flag idea as inappropriate…  ·  Admin →
    Michael Rys supported this idea  · 
    An error occurred while saving the comment
    Michael Rys commented  · 

    Thanks for filing this request. since we currently do not want to go through the cost of enforcing PK/FK constraints (which could be very costly given tera byte sized tables) we would need to introduce some special syntax to support this. We are adding this now to our backlog.

  15. Add option to built-in Extractors to truncate or ignore values that are too long

    12 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    under review  ·  1 comment  ·  Data Lake  ·  Flag idea as inappropriate…  ·  Admin →
    Michael Rys supported this idea  · 

  16. Increase number of U-SQL table files/partitions that can be read in a job

    11 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Data Lake  ·  Flag idea as inappropriate…  ·  Admin →
    Michael Rys supported this idea  · 

  17. USQL catalog - support IDENTITY or SEQUENCE

    19 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    2 comments  ·  Data Lake  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Michael Rys commented  · 

    One of the problems in scale-out systems is to provide a scalable IDENTITY function to avoid the need to synchronize or serialize. One way to work around it is with ROW_NUMBER(), another is to use GUIDs instead of an integer value, since GUID creation does not need a global coordination.

  18. Allow rowset variables to be converted to scalar values in USQL

    43 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    7 comments  ·  Data Lake  ·  Flag idea as inappropriate…  ·  Admin →
    Michael Rys supported this idea  · 

  19. Support to Update & Delete operations are in USQL

    41 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    3 comments  ·  Data Lake  ·  Flag idea as inappropriate…  ·  Admin →
    Michael Rys supported this idea  · 
    An error occurred while saving the comment
    Michael Rys commented  · 

    Thanks for your request. Indeed row-level updates and deletes are useful and it is on our longterm roadmap. Given the current processing architecture, the current work-arounds are:

    1. Use partitioned tables to partition the data so that you can either drop partitions or at least minimize the reprocessing costs.
    2. Reprocess the data by creating a new version with the dropped data deleted.

  20. Extract datetime using built in extractors with a timezone other than UTC-7

    15 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Data Lake  ·  Flag idea as inappropriate…  ·  Admin →
    Michael Rys supported this idea  · 
← Previous 1 3

Feedback and Knowledge Base

(thinking…)
Hosted by UserVoice