Hi, I'm trying to query DB2 database using nifi processor and getting below error as per the screen shot attached. Can some one please suggest and let if me know is you have any resolution. Thanks in advance. ... View more

Hi, I have DB2 database in which secutiry mechanism was enabled and we are using Server authentication. I'm using the sqoop to establish the connection using JDBC with below command and getting error. error says Invalid database URL syntax. so i'm not sure how to pass the parameter. Can someone please suggest how to precisely pass the securityMechanism in the sqoop CLI. sqoop list-tables --connect jdbc:db2://xxxxxxxxm11.xxxx.com:50501/xxxmd11:securityMechanism=13 --username xxxxxx--password xxxxxxxxxxxx SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/usr/hdp/2.6.2.0-205/hadoop/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/usr/hdp/2.6.2.0-205/accumulo/lib/slf4j-log4j12.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory] 18/01/02 21:43:22 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6.2.6.2.0-205 18/01/02 21:43:22 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead. 18/01/02 21:43:22 INFO manager.SqlManager: Using default fetchSize of 1000 18/01/02 21:43:23 ERROR manager.SqlManager: Error reading database metadata: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10165][10051][4.19.72] Invalid database URL syntax:jdbc:db2://xxxxxxxxm11.xxxx.com:50501/xxxmd11:securityMechanism=13. ERRORCODE=-4461, SQLSTATE=42815 com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10165][10051][4.19.72] Invalid database URL syntax: jdbc:db2://xxxxxxxxm11.xxxx.com:50501/xxxmd11:securityMechanism=13. ERRORCODE=-4461, SQLSTATE=42815 at com.ibm.db2.jcc.am.b4.a(b4.java:747) at com.ibm.db2.jcc.am.b4.a(b4.java:66) at com.ibm.db2.jcc.am.b4.a(b4.java:93) at com.ibm.db2.jcc.DB2Driver.tokenizeURLProperties(DB2Driver.java:948) at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:413) at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:112) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247) at org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:904) at org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52) at org.apache.sqoop.manager.SqlManager.listTables(SqlManager.java:539) at org.apache.sqoop.tool.ListTablesTool.run(ListTablesTool.java:49) 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:225) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:234) at org.apache.sqoop.Sqoop.main(Sqoop.java:243) Caused by: java.util.NoSuchElementException at java.util.StringTokenizer.nextToken(StringTokenizer.java:349) at java.util.StringTokenizer.nextToken(StringTokenizer.java:377) at com.ibm.db2.jcc.DB2Driver.tokenizeURLProperties(DB2Driver.java:936) ... 14 more Could not retrieve tables list from server ... View more

Hi Team, We have installed HDP on our Azure VM and looking to integrate Azure Datalake store. I know this can be done using Cloudbreak and with the help of Hortonworks documents below. http://hortonworks.github.io/cloudbreak-docs/latest/onprem/ http://hortonworks.github.io/cloudbreak-docs/latest/azure/ But took approach of manually installing the cloud break deployer and I want exact Azure platform-specific single binaries to deploy the cloud break. I Don't have info on that and not able to find and get them. So can some one help in providing the details. Thanks in advance. regards Mahesh. ... View more