The issue is because the person compiling the query does not have select privilege on the HISTOGRAMS table so statistics are not retrieved.
Histograms are being retrieved on behalf of the compilation. We support a special interface to allow metadata tables to be accessed without privs for operations performed during compilations. However, this interface is not being used for HISTOGRAMS tables during query compilation.
The issue is because the person compiling the query does not have select privilege on the HISTOGRAMS table so statistics are not retrieved.
Histograms are being retrieved on behalf of the compilation. We support a special interface to allow metadata tables to be accessed without privs for operations performed during compilations. However, this interface is not being used for HISTOGRAMS tables during query compilation.