## tender wang (tndrwang(at)gmail(dot)com):
> But I want to know why we don't prune when just have latter partition key
> in whereClause.
Start with the high level documentation
https://stream.boxwatch.ru/docs/current/sql-createtable.html#SQL-CREATETABLE-PARTITION
where the 5th paragraph points you to
https://stream.boxwatch.ru/docs/current/functions-comparisons.html#ROW-WISE-COMPARISON
which has a detailed explanation of row comparison.
Regards,
Christoph
--
Spare Space.