Probably local resegmentation takes a time:
Why you have segmentation on one node?Locally Resegment By: ((((((100 \<*\> 69069) \<+\> internal_strhash(a.storid)) \<*\> 69069) \<+\> internal_numhash(a.tempid)) \<*\> 69069) \<+\> a.tempid1)
More interesting why Vertica performs resegmentation? 'internal_numhash' and 'internal_strhash' - its UDF or SQL functions? Are they stable, immutable?