Re: Cassandra querying time stamps

2017-06-20 Thread sujeet jog
Correction. On Tue, Jun 20, 2017 at 5:27 PM, sujeet jog wrote: > , Below is the query, looks like from physical plan, the query is same as > that of cqlsh, > > val query = s"""(select * from model_data > where TimeStamp > \'$timeStamp+\' and TimeStamp <= >

Re: Cassandra querying time stamps

2017-06-20 Thread sujeet jog
, Below is the query, looks like from physical plan, the query is same as that of cqlsh, val query = s"""(select * from model_data where TimeStamp > \'$timeStamp+\' and TimeStamp <= \'$startTS+\' and MetricID = $metricID)""" println("Model query" + query) val df

Re: Cassandra querying time stamps

2017-06-20 Thread Riccardo Ferrari
Hi, Personally I would inspect how dates are managed. How does your spark code looks like? What does the explain say. Does TimeStamp gets parsed the same way? Best, On Tue, Jun 20, 2017 at 12:52 PM, sujeet jog wrote: > Hello, > > I have a table as below > > CREATE TABLE