Does Cassandra Support Populating Reference Table from Master Table ?

[Shyam P <sh...@gmail.com>]

Hi,
 I have scenario where I need to ingest data into master table which has
many number of columns include few columns like "Country_Id"
"CountryName","Date"....etc.

Everytime I load data with new records this "Date" would change to the data
generation data. Every time each country data might not be loaded.
In millions of rows of the master table If I need to get last genration
"Date" for each country , I need to scan entire table everytime.
Instead I want to maintain a reference table with these three columns i.e.
""Country_Id" "CountryName","Date".
So that I can update the ,"Date" of those countries which loaded ,
remaining will be intact.

To achieve this what is the best design strategy ?
Do we have anything like Oracle Trigger concept in Cassandra? If not what
are the alternatives?

Please suggest me.

Thank you.