Partitioned table shows Partially Loaded and Fully Load

[joseph_gonzales]

Hi Hana Friends:

I'm trying to understand the ramifications of having a partitioned table that shows some partitions as Partially Loaded and others as Fully Loaded.

Is this a problem?

Should I be try to force it to be fully loaded?

Can someone help me understand this?

Regards,

Joe Gonzales

1 856 912 1136

[patrickbachmann]

Hi Joseph,

I'm assuming you are referring to when you go into the table definition and click on the last tab 'Runtime information'.  The column named LOADED is referring to if the partition is fully loaded from disk into memory.  Basically when somebody runs a view that uses the table, only the data that is queried is loaded into the memory for that partition.  So no it's not a problem. It does not mean that the partition has not been fully written to disk, rather it means that what is contained in the partition is not fully in memory.  Incidentally if you were to right click on the table and choose LOAD the entire table would be loaded into memory and you would then see FULL next to each and every partition. 

Hope that clears it up for you.

-Patrick