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.
