10/01/2021, 3:09 AM
I have parquet data placed in the S3 under prefix such as
. I want to use these partitions(year, month, day) to filter data by partition value in pinot. How can I do it?
10/01/2021, 3:22 AM
Currently, you need to push data to Pinot to be able to query it:
10/01/2021, 3:30 AM
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:
) eg here year, month and day
In Athena during table creation we can pass partitioned by and it will handle it. Please check scenario 1 in below doc. I am looking for a way to do it in pinot.
10/01/2021, 8:52 AM
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.
This also applies to CSV, Json, Text, ... not just parquet
Anybody has any solution for that.
10/15/2021, 4:15 AM
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.
Updating the thread with offline discussion. Essentially the ask here is to add derived columns for day/month/year by date partition. This can be achieved by using derived columns during ingestion:
while should work, it would be a good enhancement to have in the spark ingestion job, please file a github issue for the same.