Question
We are using a shared Hive Metastore (HMS) database and see errors when trying to create datasets through the Okera Portal. How can we fix this problem?
Answer
Errors communicating with an existing HMS database are often related to the version of its schema. You can find out by connecting to the HMS database and print the content of the
VERSION table. For example:mysql> use hms_db;
mysql> select * from VERSION;
+--------+-----------------+------------------------------+
| VER_ID | SCHEMA_VERSION | VERSION_COMMENT |
+--------+-----------------+------------------------------+
| 1 | 2.3.0 | Hive release version 2.3.0 |
+--------+-----------------+------------------------------+
1 row in set (0.10 sec)
Okera must be configured to use an HMS version of 2.0 or later by setting the additional environment variable
ENABLE_HMS_2_SCHEMA. This can be done within the cluster configmap.
Comments
0 comments
Please sign in to leave a comment.