I have a table with 1000+ partitions.
“Show partitions” command only lists a small number of partitions.
How can i show all partitions?
Update:
- I found “
show partitions” command only lists exactly 500 partitions. - “
select ... where ...” only processes the 500 partitions!