5 Replies Latest reply: Jan 25, 2018 10:30 AM by Mykola Masis RSS

    Order By does not impact Distinct Load.

    Ankit Goyal



      PFA the test data (a single column) that is not getting sorted when we write the following code:




      LOAD x



      (biff, embedded labels, table is Sheet1$);


      load distinct * Resident D

      Order by x;

      drop Table D;


      Inline image 1

      I know that Order By executes before Load. Thus accordingly, Load Distinct should be applied on the sorted column x which should in turn return the sorted Distinct values.


      It would be really helpful if you could help me tell why it is not getting sorted.