I have parquet data placed in the S3 under prefix such as s3://my_bucket/logs/year=2018/month=01/day=23/*. I want to use these partitions(year, month, day) to filter data by partition value in pinot. How can I do it?

Currently, you need to push data to Pinot to be able to query it: https://docs.pinot.apache.org/users/tutorials/ingest-parquet-files-from-s3-using-spark

Yes I am able to push parquet files but during push I want to create partition based on S3 prefix (data is already partitioned in s3 and i want to take benefit of that: s3://my_bucket/logs/year=2018/month=01/day=23/*) eg here year, month and day

This is general path format supported by spark, it won't store folder path values (partition values like year, month, day, country) in parquet file. https://spark.apache.org/docs/latest/sql-data-sources-parquet.html#partition-discovery

@User @User for time column, as long as you are pushing partitioned data into Pinot, it will be used to prune out segments for better query performance.