Thank you for making time to answer this question.

I was recently working with spark and I read that it considers one partition from HDFS = one partition in spark. With that logic there are many cases where we might not use HDFS as source. So, if we use CSV or any other file-based format to read data from how the partition is or rather how that data is partitioned since there is no explicit partitioning.