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
