# TTL functionality on transactional tables/Tables with a GSI

**URL:** <https://forum.yugabyte.com/t/ttl-functionality-on-transactional-tables-tables-with-a-gsi/372>\
**Category:** General\
**Created:** [May 30, 2019, 6:19pm UTC](https://forum.yugabyte.com/t/ttl-functionality-on-transactional-tables-tables-with-a-gsi/372 "2019-05-30T18:19:20Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sherwin\_Pinto](https://yyz1.discourse-cdn.com/flex027/user_avatar/forum.yugabyte.com/sherwin_pinto/32/101_2.png) [@Sherwin\_Pinto](https://forum.yugabyte.com/u/Sherwin_Pinto)\
**Post date:** [May 30, 2019, 6:19pm UTC](https://forum.yugabyte.com/t/ttl-functionality-on-transactional-tables-tables-with-a-gsi/372/1 "2019-05-30T18:19:20Z")

</div>

Hi all, can we confirm that the ttl functionality is supported on cassandra tables where we have a GSI and the table is marked as transactional ?

---

<div class="post-metadata">

**Author:** ![karthik](https://yyz1.discourse-cdn.com/flex027/user_avatar/forum.yugabyte.com/karthik/32/13_2.png) [@karthik](https://forum.yugabyte.com/u/karthik)\
**Post date:** [June 5, 2019, 5:31am UTC](https://forum.yugabyte.com/t/ttl-functionality-on-transactional-tables-tables-with-a-gsi/372/2 "2019-06-05T05:31:21Z")

</div>

Hi @Sherwin_Pinto,

The TTL functionality is not allowed on transactional tables in YCQL. This is because some rows would disappear automatically because of the TTL feature, and this causes unpredictable behavior in transactions.