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.
Answers
-
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.
-
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. -
Pleaes help!
-
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.