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
