Oh, sorry, I misunderstood what you meant. If you want to add --relaxed-isolation for sqoop, you need to set the transaction isolation level of HIVE to TRANSACTION_READ_COMMITTED or
TRANSACTION_READ_UNCOMMITTED. Kylin will set --relaxed-isolation for sqoop only when HIVE transaction isolation level is set. You can see more from JdbcHiveInputBase.java ------------------- Best wishes, Rupeng Wang 发件人: Rupeng Wang <[email protected]> 答复: <[email protected]> 日期: 2020年5月19日 星期二 16:16 收件人: <[email protected]> 主题: Re: 答复: 问题咨询 Hi, You can override scoop property in kylin.properties like this“kylin.source.jdbc.sqoop-config-override.${scoop-property}=${value}” 发件人: 周欢磊总部IT <[email protected]> 答复: <[email protected]> 日期: 2020年5月18日 星期一 16:35 收件人: "[email protected]" <[email protected]> 主题: 答复: 问题咨询 Hello： How do I add sqoop parameters to kylin？ for example ：Sqoop parameter -relaxed-isolation thanks 发件人: Yaqian Zhang <[email protected]> 发送时间: 2020年5月18日 16:29:28 收件人: [email protected] <[email protected]> 主题: Re: 问题咨询 Hi harry: Maybe you can turn to the Sqoop community for help. 在 2020年5月15日，15:31，harry <[email protected]> 写道： 你好，我在用kylin连接sql server数据库时遇到这样一错误： 20/05/15 07:20:55 ERROR manager.SqlManager: Error executing statement: com.microsoft.sqlserver.jdbc.SQLServerException: Setting IsolationLevel to ReadCommitted is not supported. com.microsoft.sqlserver.jdbc.SQLServerException: Setting IsolationLevel to ReadCommitted is not supported. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:258) at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:256) at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:108) at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:28) at com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(SQLServerConnection.java:2519) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7151) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2478) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(SQLServerConnection.java:2524) at com.microsoft.sqlserver.jdbc.SQLServerConnection.setTransactionIsolation(SQLServerConnection.java:2858) at org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:910) at org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:59) at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:763) at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:786) at org.apache.sqoop.manager.SqlManager.getColumnInfoForRawQuery(SqlManager.java:289) at org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:260) at org.apache.sqoop.manager.SqlManager.getColumnTypesForQuery(SqlManager.java:253) at org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:336) at org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1872) at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1671) at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:106) at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:501) at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:628) at org.apache.sqoop.Sqoop.run(Sqoop.java:147) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76) at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:234) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:243) at org.apache.sqoop.Sqoop.main(Sqoop.java:252) 20/05/15 07:20:55 ERROR tool.ImportTool: Import failed: java.io.IOException: No columns to generate for ClassWriter at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1677) at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:106) at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:501) at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:628) at org.apache.sqoop.Sqoop.run(Sqoop.java:147) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76) at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:234) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:243) at org.apache.sqoop.Sqoop.main(Sqoop.java:252) 查询了一下，感觉像是sqoop那边的错误： 查询的连接 https://issues.apache.org/jira/browse/SQOOP-2349 但是加了这个连接给出的参数--relaxed-isolation还是报错 能帮忙看一下吗？谢谢！
