Forum Discussion

Element115's avatar
Element115
Icon for Memorable Member rankMemorable Member
2 years ago

BUG::LAKEHOUSE PREVIEW::Sort Descending doesn't work

ISSUE: On first selecting the Sort Descending on an index column, the column gets sorted in ascending order.  Try a second time, and the order becomes descending BUT the sequence of value is not con...
data engineering
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Element115 ,

Team would like to understand what are you trying to achieve with a full sort in the Lakehouse UI? Why are you doing it? And why in the Lakehouse data preview?

Element115's avatar
Element115
Icon for Memorable Member rankMemorable Member
2 years ago

What does it matter?  Wrong questions all because this is how any DB client works:  You click on the sort widget of a column, and of course you expect the column (for whatever amount of rows are in view) to be sorted accordingly.  That's standard UI behavior, be it on a Power BI table, or a DB client such as DBeaver or DBForger etc...

 

So if you want to check what the latest index number is in a LH, thus this shows what came in from the most recent ingest, you can't because in the LH view the sort does not work and does not guarantee a consistent ordering.  For this, you need to drop down to the SQL Analytics endpoint.

 

Is that clearer?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Element115 ,

    I would to request to open a support ticket regarding this.

    Please reach out to our support team so they can do a more thorough investigation on why this it is happening: Link 

     

    After creating a Support ticket please provide the ticket number as it would help us to track for more information.

     

    Hope this helps. Please let us know if you have any other queries.