Try using "refresh <table name>" instead of "invalidate metadata". This will incrementally update the specified table's metadata rather than clearing all cached metadata, so it should be faster. ... View more