ranger_core_db_mysql.sql file import failed

薛定谔的猫不吃猫粮

于 2022-04-01 10:42:12 发布

阅读量901

点赞数 1

分类专栏：大数据组件文章标签：大数据 hadoop hive

本文链接：https://blog.youkuaiyun.com/weixin_52918377/article/details/123891982

版权

大数据组件专栏收录该内容

8 篇文章

订阅专栏

在尝试安装Ranger时遇到了一个数据库错误，具体表现为执行SQL函数CREATEFUNCTION时出现异常。错误信息指出函数声明中缺少DETERMINISTIC, NOSQL或READS SQL DATA，并提示可能需要设置log_bin_trust_function_creators变量为1。解决此问题的方法是设置全局变量log_bin_trust_function_creators为1。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

异常信息：

Error executing: CREATE FUNCTION `getXportalUIdByLoginId`(input_val VARCHAR(100)) RETURNS int(11) BEGIN DECLARE myid INT; SELECT x_portal_user.id into myid FROM x_portal_user WHERE x_portal_user.login_id = input_val; RETURN myid; END  
java.sql.SQLException: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
SQLException : SQL state: HY000 java.sql.SQLException: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable) ErrorCode: 1418
2022-02-24 18:24:06,439  [E] ranger_core_db_mysql.sql file import failed!
2022-02-24 18:24:06,439  [I] Unable to create DB schema, Please drop the database and try again

...
2022-02-24 18:24:08,667  [E] CORE_DB_SCHEMA import failed!

Ranger 安装的时候报这个错

解决办法

SET GLOBAL log_bin_trust_function_creators = 1;