Hi, The problem is I can not *search* sorted tempory tables because there are no indexes. Is there any way to create indexes in tempory tables?
-Roshan On Fri, Jan 1, 2016 at 12:12 PM, Gimantha Bandara <[email protected]> wrote: > 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 > -- 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
