title: Date partition size 10GB read efficiently
body: <p>We are using Cassandra DataStax 6.0 and Spark enabled. We have 10GB of data coming every day. All queries are based on date. We have one huge table with 40 columns. We are planning to generate reports using Spark. What is the best way to setup this data. Since we keep getting data every day and save data for around 1 year in one table. </p>
  
  <p>We tried to use different partition but most of our keys are based on date. </p>
  
  <p>No code just need suggestion</p>
  
  <p>Our query should be fast enough. We have 256GB Ram with 9 nodes. 44 core CPU.</p>