Hi Udara, Yes I also thought about this, the only problem is let's say we have 10 column table, and if I want to sort columns of this table, I need to create 20 tempory tables two temp tables per one column (ASC/DESC). BTW, I think this is the only solution we got so far. :)
-Roshan On Tue, Dec 29, 2015 at 9:44 PM, Udara Rathnayake <[email protected]> wrote: > Hi Roshan, > > If you are querying a temporary table, you can initially store data within > temporary table in the particular order. Then you don't need to worry about > the order while querying. > Eg:- You can have ORDER BY, DESC/ASC within your SELECT (INSERT > INTO/OVERWRITE TABLE <table_name> *<SELECT_query>*)[1] > > BTW I haven't tried this method, May be someone from DAS team can point a > better solution. > > [1] https://docs.wso2.com/display/DAS300/Spark+Query+Language > > On Tue, Dec 29, 2015 at 10:22 PM, Roshan Wijesena <[email protected]> wrote: > >> Hi, >> >> Do we have a REST API for this? How could I sort a data set by ascending >> or descending order when retrieving from the data source? >> >> -Roshan >> >> -- >> Roshan Wijesena. >> Senior Software Engineer-WSO2 Inc. >> Mobile: *+94719154640 <%2B94719154640>* >> Email: [email protected] >> *WSO2, Inc. :** wso2.com <http://wso2.com/>* >> lean.enterprise.middleware. >> > > > > -- > Regards, > UdaraR > -- Roshan Wijesena. Senior Software Engineer-WSO2 Inc. Mobile: *+94719154640* Email: [email protected] *WSO2, Inc. :** wso2.com <http://wso2.com/>* lean.enterprise.middleware.
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
