Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
adiey_26
Contributor
Contributor

Sorting of data

Hey everyone i have a query and i am struck on this can someone help me regarding this .

Can i sort QVD without taking resident load and order by ??

can we use the concept of Bit stuffed pointers and symbol table in this ??

 

Labels (2)
3 Replies
MendyS
Partner - Creator III
Partner - Creator III

vinieme12
Champion III
Champion III

No, data cannot be sorted while it is being loaded in-memory

This is same as order or execution of a SQL, sort by is the second last clause to be executed 

imagine this   

Sorting after loading row1, then sort row1 ,2 after loading row2, then sort row1,2,3 after loading row 3 !!

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
marcus_sommer

Why not sorting the data before they are stored within the qvd?

- Marcus