Hi Roshan, You can give - i within your schema while creating the temporary table to make it an indexed column.
Eg:- schema "user_name INT -i, .......... " https://docs.wso2.com/display/DAS300/Spark+Query+Language On Fri, Jan 8, 2016 at 7:24 PM, Roshan Wijesena <[email protected]> wrote: > 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 <%2B94719154640>* > Email: [email protected] > *WSO2, Inc. :** wso2.com <http://wso2.com/>* > lean.enterprise.middleware. > -- Regards, UdaraR
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
