ERR_HIVE_TABLE_NOT_SYNCHRONIZED

goku
Level 1
ERR_HIVE_TABLE_NOT_SYNCHRONIZED

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.

0 Kudos
4 Replies
CatalinaS
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.

0 Kudos
goku
Level 1
Author

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.

0 Kudos
CatalinaS
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.

0 Kudos
goku
Level 1
Author

Pleaes help!

0 Kudos