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