question about query SparkSQL

[Eli Super]

Hi

I try to save parts of large table as csv files

I use following commands :

sqlContext.sql("select * from my_table where trans_time between '2015/12/18
12:00' and '2015/12/18
12:06'").write.format("com.databricks.spark.csv").option("header",
"false").save('00_06')

and

sqlContext.sql("select * from my_table where trans_time between '2015/12/18
12:07' and '2015/12/18
12:12'").write.format("com.databricks.spark.csv").option("header",
"false").save('07_12')

a question is how to avoid gap of a min between two files .

Thanks !