How to troubleshoot a partitioned table 1

[rogers42]

Hi Folks,

Given a "Range" or a "List" partitioned table, how can I find out if the data really ended up in the correct partition ? Put another way, how can I get a dump of a specific partition ?

The solution that I have come up is to

1, create a table with "List" partition
2, populate table with test data to ensure that all partitions are populated
3, Observe any changes in data while truncating one partition at a time

But, is there a more elegant solution ?

Thanks in advance

rogers42

 

[Dagon]

I think a simpler solution might be to specify the partition name in a query e.g.

select * from table
partition (xxxxxxx)

You can then see what data is in it.