Hi, Please provide the script/test case you are using, I can try it.
Regards, Ravindra On Fri, 12 Jul 2019 at 16:55, Deepak Kulkarni <[email protected]> wrote: > thx. We tried this example but we did not get the similar output for > EXPLAIN PLAN command. Can yo help? > i > > On Fri, Jul 12, 2019 at 4:08 PM Ravindra Pesala <[email protected]> > wrote: > >> Hi, >> >> You want to use pre-aggregate datamaps, please try the example >> `org.apache.carbondata.examples.PreAggregateDataMapExample` to understand >> how it works. Please note that we are going to obsolete pre-aggregate >> datamaps from next version and make MV(materialized view ) datamaps going >> to replace it. >> >> Regards, >> Ravindra. >> >> On Thu, 11 Jul 2019 at 17:40, Deepak Kulkarni <[email protected]> >> wrote: >> >>> Thx. However we want to tame sure that the queries are using >>> pre-aggregate datamaps . We tried using explain plan but the output showed >>> in this link https://carbondata.apache.org/datamap-management.html we >>> are not getting. >>> >>> Can you help? >>> >>> BR, >>> Deepak >>> >>> On Tue, Jul 9, 2019 at 8:51 AM Ravindra Pesala <[email protected]> >>> wrote: >>> >>>> Hello, >>>> >>>> 1. Currently there is no way to impose primary key indexes on carbon. >>>> We may consider it in future. >>>> >>>> 2. We have datamaps interface opened for implementing secondary >>>> indexes. Right now we have implemented for min/max , bloom indexes. User >>>> can add there own implementations as well. >>>> >>>> 3. There is no constraints supported on carbon right now. >>>> >>>> 4. Spark/hive has many predefined functions and also user can have >>>> there own user defined function and register to spark and use them carbon. >>>> >>>> Regards, >>>> Ravindra. >>>> >>>> On Tue, 2 Jul 2019 at 2:52 PM, Deepak Kulkarni <[email protected]> >>>> wrote: >>>> >>>>> Hi, >>>>> >>>>> >>>>> >>>>> We are evaluating the Carbondata for following alternative to Oracle >>>>> βand hit following issues when achieving this migration - >>>>> >>>>> >>>>> >>>>> 1. Primary Key Indexes β how we can avoid duplicate records on >>>>> Carbon? >>>>> 2. Secondary Indexes >>>>> 3. Constraints such as NULL, NOT NULL β how can we set this at >>>>> column levels in carbon? >>>>> 4. Functions such as DECODE β what alternatives we have in Carbon >>>>> to use these SQL functions? >>>>> >>>>> >>>>> >>>>> Appreciate the response. >>>>> >>>>> >>>>> >>>>> -- >>>>> Regards, >>>>> Deepak >>>>> >>>> -- >>>> Thanks & Regards, >>>> Ravi >>>> >>> >>> >>> -- >>> Regards, >>> Deepak >>> >> >> >> -- >> Thanks & Regards, >> Ravi >> > > > -- > Regards, > Deepak > -- Thanks & Regards, Ravi
