mysql - 将存储库和策略从 xasecure 迁移到 ranger

Question

我想问一下如何将存储库和策略从 xasecure 迁移到 HDP 中的 ranger。我正在使用 HDP 2.2 并将 ambari 从 1.7 升级到 2.1，然后将 xasecure 升级到 ranger。 Ranger 在 mysql 中创建名为“ranger”的新数据库。如果我从名为“xasecure”的 xasecure 将我的转储数据库恢复为“ranger”数据库，当我想编辑我的策略“找不到页面”时，我收到了一个错误，并且来自 xa_portal_sql.log:

ERROR net.sf.log4jdbc.Slf4jSpyLogDelegator (Slf4jSpyLogDelegator.java:130) - 1. PreparedStatement.executeQuery() FAILED! SELECT DISTINCT ID AS a1, ADDED_BY_ID AS a2, ASSET_ID AS a3, RES_COL_FAMS AS a4, COL_TYPE AS a5, RES_COLS AS a6, CREATE_TIME AS a7, RES_DBS AS a8, DESCR AS a9, IS_ENCRYPT AS a10, IS_RECURSIVE
AS a11, RES_NAME AS a12, PARENT_ID AS a13, PARENT_PATH AS a14, POLICY_NAME AS a15, RES_GROUP AS a16, RES_STATUS AS a17, RES_TYPE AS a18, RES_SERVICES AS a19, TABLE_TYPE AS a20, RES_TABLES AS a21, RES_TOPOLOGIES AS a22, RES_UDFS AS a23, UPDATE_TIME AS a24, UPD_BY_ID AS a25 FROM x_resource WHERE ((1 = 1) AND (ASSET_ID = 1)) ORDER BY ID ASC LIMIT 0, 25 ; {FAILED after 0 msec} com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'POLICY_NAME' in 'field list'

有人能帮帮我吗？提前谢谢你

Answer 1

好吧，如果其他人遇到这个问题，您应该将列“POLICY_NAME”添加到表“x_resource”，并将更多列添加到其他一些表。你会在 xa_portal_sql.log 中找到它