Michael Rys

← Customer Feedback for ACE Community Tooling

My feedback

  1. Support for range partitioning in USQL

    3 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Forgot password?
    Create a password
    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  · 

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

    3 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    2 comments  ·  Data Lake  ·  Flag idea as inappropriate…  ·  Admin →
    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

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

    8 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Forgot password?
    Create a password
    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  · 

  4. Support of Column.Exists feature

    4 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Forgot password?
    Create a password
    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  · 

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

    4 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Forgot password?
    Create a password
    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 commented  · 

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

  6. Support SNAPPY compression and decompression

    4 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Forgot password?
    Create a password
    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 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?

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

    5 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Forgot password?
    Create a password
    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  · 

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

    6 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Forgot password?
    Create a password
    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  · 

  9. Support for Table.Exists Feature

    7 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Forgot password?
    Create a password
    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  · 

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

    8 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Forgot password?
    Create a password
    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 commented  · 

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

  11. Column Annotation Support

    10 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Forgot password?
    Create a password
    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  · 
    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.

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

    12 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Forgot password?
    Create a password
    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  · 

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

    11 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Forgot password?
    Create a password
    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  · 

  14. USQL catalog - support IDENTITY or SEQUENCE

    19 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    2 comments  ·  Data Lake  ·  Flag idea as inappropriate…  ·  Admin →
    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.

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

    43 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Forgot password?
    Create a password
    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  · 

  16. Support to Update & Delete operations are in USQL

    41 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Forgot password?
    Create a password
    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  · 
    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.

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

    15 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Forgot password?
    Create a password
    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  · 

  18. ADL Store connector for ML Studio

    13 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Forgot password?
    Create a password
    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 commented  · 

    I would suggest to file this in the ML Studio feedback section.

  19. Add support for R in a way similar to T-SQL

    16 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Forgot password?
    Create a password
    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 commented  · 

    We have R support as part of the U-SQL Extension libraries for a while now. I would be interested in hearing what you need in addition to this. Note that we recently increased the memory a vertex can use to 5GB.

  20. Excel Extractor

    48 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    under review  ·  7 comments  ·  Data Lake  ·  Flag idea as inappropriate…  ·  Admin →
    Michael Rys commented  · 

    Note that there is a community contributed Excel extractor available at https://github.com/Azure/AzureDataLake/tree/master/Samples/ExcelExtractor

    Michael Rys commented  · 

    Thanks Jayme

    Note that U-SQL can read most CSV and TSV files that are generated by Excel (without header and no CR/LF in content). XLSX files are harder to support: They are a compressed archive of XML files, so it makes it rather difficult to give you good performing processing.

    We will look into it though if there are enough votes.

← Previous 1 3

Feedback and Knowledge Base

(thinking…)
Hosted by UserVoice