CID and TDEF columns are not returned when you reload tables in Kerberos-enabled Hive data sources

The results of the CID and TDEF columns are not returned when you reload tables in Kerberos-enabled Hive data sources.

Symptoms

You add a connection to a Kerberos-enabled Hive data source and then run dvsys.reloadtables on databases or schemas in the data source. The results of the CID and TDEF columns are not returned.

Resolving the problem

To solve this issue, complete the following steps to set the server parameter on the Hive data source:
  1. Go to the hive_site.xml file on the server of the Hive data source.
  2. Set the following parameter in the hive_site.xml file.
    metastore.storage.schema.reader.impl=org.apache.hadoop.hive.metastore.SerDeStorageSchemaReader​
  3. Restart the Hive data source.
  4. Run dvsys.reloadtables again.