Hi Roshan, REST APIs do not provide a way to sort data in DAS. The only option is to use spark queries to create sorted temporary tables.
On Wed, Dec 30, 2015 at 9:25 AM, Roshan Wijesena <[email protected]> wrote: > 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 <%2B94719154640>* > Email: [email protected] > *WSO2, Inc. :** wso2.com <http://wso2.com/>* > lean.enterprise.middleware. > -- Gimantha Bandara Software Engineer WSO2. Inc : http://wso2.com Mobile : +94714961919
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
