Member since
12-29-2017
3
Posts
1
Kudos Received
0
Solutions
03-29-2018
02:48 AM
1 Kudo
I took the exam today and faced the same problems as above.About one and half hour the environment was very slow and unresponsive.The connection stopped many times I asked the proctor to cancel the exam .He said hortonworks is not responding, and my computer passed all the test . He did not give extra time as well. Have you all received the refund?Please reply .Its very stressful and my money and time is wasted . @certification team please refund my money. Totally disappointing of you to blame the candidates rather than correcting your environment.
... View more
03-13-2018
12:10 AM
Hi I am trying to attempt the practice exam in AWS but the community AMI for hortonworks exam is not available. I have mailed hortonworks regarding the same 10 days back still no response from them
... View more
12-29-2017
03:54 PM
AZURE MYSQL JDBC CONNECTION STRING LISTED AS BELOW IN THE DASHBOARD : String url ="jdbc:mysql://mysqlaruna.mysql.database.azure.com:3306/{your_database}?useSSL=true&requireSSL=false"; myDbConn = DriverManager.getConnection(url, "hedba@mysqlaruna", {your_password}); sqoop command : sqoop export --connect jdbc:mysql://mysqlaruna.mysql.database.azure.com:3306/hadoopexam_db1 --driver com.mysql.jdbc.Driver --username hedba@mysqlaruna --password <password> --table employee --direct --export-dir hadoopexam/employee.csv -m 1 Error facing: [root@sandbox ~]# sqoop export --connect jdbc:mysql://mysqlaruna.mysql.database.azure.com:3306/hadoopexam_db1 --driver com.mysql.jdbc.Driver --username hedba@mysqlaruna --password <password> --table employee --direct --export-dir hadoopexam/employee.csv -m 1 Warning: /usr/hdp/2.5.0.0-1245/accumulo does not exist! Accumulo imports will fail. Please set $ACCUMULO_HOME to the root of your Accumulo installation. 17/12/29 06:36:00 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6.2.5.0.0-1245 17/12/29 06:36:00 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead. 17/12/29 06:36:01 WARN sqoop.ConnFactory: Parameter --driver is set to an explicit driver however appropriate connection manager is not being set (via --connection-manager). Sqoop is going to fall back to org.apache.sqoop.manager.GenericJdbcManager. Please specify explicitly which connection manager should be used next time. 17/12/29 06:36:01 INFO manager.SqlManager: Using default fetchSize of 1000 17/12/29 06:36:01 INFO tool.CodeGenTool: Beginning code generation 17/12/29 06:36:01 ERROR manager.SqlManager: Error executing statement: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Got packets out of order com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Got packets out of order at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2619) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2569) at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1524) at com.mysql.jdbc.ConnectionImpl.loadServerVariables(ConnectionImpl.java:3865) at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3404) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2385) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2154) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:49) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305) 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.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.getColumnTypes(SqlManager.java:246) at org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:328) at org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1853) at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1653) at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:107) at org.apache.sqoop.tool.ExportTool.exportTable(ExportTool.java:64) at org.apache.sqoop.tool.ExportTool.run(ExportTool.java:100) 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) 17/12/29 06:36:01 ERROR tool.ExportTool: Encountered IOException running export job: java.io.IOException: No columns to generate for ClassWriter [root@sandbox ~]# To log in to MYSQL using the following details: mysql -h mysqlaruna.mysql.database.azure.com -u hedba@mysqlaruna -p After login MYSQL shows below: p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo; color: #000000; background-color: #ffffff}
p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo; color: #000000; background-color: #ffffff; min-height: 13.0px}
span.s1 {font-variant-ligatures: no-common-ligatures} mysql> SHOW VARIABLES WHERE Variable_name = 'hostname'; +---------------+--------+ | Variable_name | Value| +---------------+--------+ | hostname| CLIENT | +---------------+--------+ 1 row in set (0.00 sec) mysql> select user(); +----------------------+ | user() | +----------------------+ | hedba@104.214.113.78 | +----------------------+ 1 row in set (0.00 sec) mysql> SHOW VARIABLES WHERE Variable_name = 'port'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | port| 20142 | +---------------+-------+ 1 row in set (0.01 sec) mysql> select system_user(); +----------------------+ | system_user()| +----------------------+ | hedba@104.214.113.78 | +----------------------+ 1 row in set (0.01 sec) mysql> select @@port; +--------+ | @@port | +--------+ |20142 | +--------+ 1 row in set (0.00 sec) mysql> select @@hostname; +------------+ | @@hostname | +------------+ | CLIENT | +------------+ 1 row in set (0.00 sec) mysql> quit;
... View more
Labels:
