答复: 问题咨询

[周欢磊总部IT <hu...@bkchina.cn>]

Hello：

   How do I add sqoop parameters to kylin？

for example ：Sqoop parameter -relaxed-isolation

thanks

________________________________
发件人: Yaqian Zhang <Ya...@126.com>
发送时间: 2020年5月18日 16:29:28
收件人: user@kylin.apache.org <us...@kylin.apache.org>
主题: Re: 问题咨询

Hi harry:

Maybe you can turn to the Sqoop community for help.

在 2020年5月15日，15:31，harry <hu...@bkchina.cn>> 写道：

你好，我在用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还是报错
能帮忙看一下吗？谢谢！