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
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
