PARTITION GROUP BY does not work for unsegmented tables
I found set of tables in prod with very high number of ROS. More checking show that user created unsegmented tables partitioned by date.
My first reaction was to add PARTITION GROUP BY and partition_table. I found that PARTITION GROUP BY does not have any effect on ROS for unsegmented tables.
Not sure if it is by design, I have not found any reference in docs.
If you think this is a defect, please file ticket to development. At least should be mentioned in docs.
(I addressed problem by converting tables to segmented).