Fascinating! I did not see that. Thanks, Udara. On Fri, Jan 8, 2016 at 6:40 PM, Udara Rathnayake <[email protected]> wrote:
> > > On Fri, Jan 8, 2016 at 7:30 PM, Udara Rathnayake <[email protected]> wrote: > >> 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, .......... " >> > This Eg is a bit confusing... so following is something which I have > tried, > CREATE TEMPORARY TABLE lasthour_login_info_001 using CarbonAnalytics > options (tableName "LASTHOUR_LOGIN_INFO_001", schema "*username STRING -i*, > timestamp STRING"); > > >> >> 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 >> > > > > -- > 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
