AnsweredAssumed Answered

Using TTL and secondary indexes in MapRDB

Question asked by arp4504 on May 20, 2018
Latest reply on May 21, 2018 by MichaelSegel

Hi All,

 

As of MapR 6.0, functionality of secondary index was introduced. However, as per MapR docs(Setting TTL for Data ), MapR tables cannot have both secondary index and ttl on a single table at the same time. Is there any work around, i.e is there any way we can leverage both secondary index and ttl functionalities on a table? Does MapR have any plans to make these functionalities work together on a single table, in any future release?

 

Additional Observation(s) : We were able to change "deletettl" field(i.e ttl of the maprdb json table) using maprcli on a table which has secondary index. The maprcli did not throw any error, and maprcli table info command indicates that ttl was changed successfully. (Without any exceptions/errors in CLI execution.).

However, we are unable to set ttl on default column family of the table having secondary index. Setting ttl on default column family of a table having a secondary index shows the following exception:

 

ERROR (10003) - Failed to modify columnfamily on table: /data/random_volume/random_tbl3_path/random_tbl_7 with name default, Error: Invalid argument (22)
2018-05-21 06:57:12,8156 ERROR Client fs/client/fileclient/cc/dbclient.cc:422 Thread: 2866 ColumnFamilyModify failed for column family default, error Invalid argument(22) for fid 6391.32.131364

Outcomes