Impala Failed to load metadata for table

Error

Failed to load metadata for table: <tableName>
CAUSED BY: TableLoadingException: Failed to load metadata for table: <tableName>
CAUSED BY: TTransportException: java.net.SocketException: Broken pipe
CAUSED BY: SocketException: Broken pipe

Solution

Execute refresh via the impala shell

or

Restart the impala service

or

Execute refreshschema via the ODBC driver

Reference

http://knowledgebase.progress.com/articles/Article/000041831