ERR_HIVE_TABLE_NOT_SYNCHRONIZED

goku
goku Registered Posts: 16

i am getting this error while synchronizing the dataset to the metastore.

Hive table not synchronized with DSS schema

No fallback database name defined on connection, doing nothing. I am encountering this warning.

Is there anything i could do sync in macro.

Answers

  • Catalina
    Catalina Dataiker, Dataiku DSS Core Designer, Registered Posts: 135 Dataiker

    This error normally indicates that metastore synchronization is not enabled in the dataset, in the "Connection" field. "Auto-sync" must be enabled even for manual synchronization.

  • goku
    goku Registered Posts: 16

    actually in the connection for the dataset i have enabled the sync option of this dataset be synchronized to the active metastore catalog.

    When I manually clicked on the synchronize option it was throwing the warning as in the attached picture.
    Also the partitions are not stored in the metastore in aws.

  • goku
    goku Registered Posts: 16
  • Catalina
    Catalina Dataiker, Dataiku DSS Core Designer, Registered Posts: 135 Dataiker

    Based on the error there is no fallback database in your HDFS connection configuration. As your dataset does not have a database configured, DSS does not know where to synchronize the dataset to the Hive metastore. Please navigate to Administration > Connections > within the settings of your HDFS connection, and check if there's a database set under the "Fallback Hive DB" section. If not, then please set it to an existing database within Hive.

Setup Info
    Tags
      Help me…