Member since
09-17-2014
93
Posts
5
Kudos Received
6
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
33081 | 03-02-2015 12:47 PM | |
2721 | 02-03-2015 01:24 PM | |
4530 | 12-12-2014 08:19 AM | |
4537 | 11-07-2014 01:55 PM | |
2968 | 10-13-2014 06:47 PM |
12-08-2014
11:28 AM
Hi, I am trying to enable LDAP in impala but it gives me an error like this :- 12:04:40.393 PM INFO thrift-util.cc:105 TThreadPoolServer: TServerTransport died on accept: SASL(-13): user not found: Password verification failed 12:05:11.899 PM INFO thrift-util.cc:105 TThreadPoolServer: TServerTransport died on accept: invalid sasl status 12:13:09.242 PM INFO thrift-util.cc:105 TThreadPoolServer: TServerTransport died on accept: invalid sasl status 12:13:44.246 PM INFO authentication.cc:235 Trying simple LDAP bind for:xxxx 12:13:44.250 PM WARN authentication.cc:242 LDAP authentication failure for xxxx : Invalid credentials 12:13:44.250 PM ERROR authentication.cc:148 SASL message (LDAP): Password verification failed 12:13:44.251 PM INFO thrift-util.cc:105 TThreadPoolServer: TServerTransport died on accept: SASL(-13): user not found: Password verification failed 12:13:58.467 PM INFO authentication.cc:235 Trying simple LDAP bind for: xxxx 12:13:58.471 PM WARN authentication.cc:242 LDAP authentication failure for xxxx : Invalid credentials 12:13:58.471 PM ERROR authentication.cc:148 SASL message (LDAP): Password verification failed 12:13:58.472 PM INFO thrift-util.cc:105 TThreadPoolServer: TServerTransport died on accept: SASL(-13): user not found: Password verification failed Even though i am giving the correct credentials. I have enabled LDAP in IMpala by giving LDAP_url,Enable LDAP authentication,TLS checkbox(without this enabled Impala does not start) and added these properties in advanced command line impala code snippet in cloudera manager :- -ldap_domain= -base_dn= -bind_dn= -bind_password= Also,when i login through hue (LDAP enabled) ,i get impala error on the landing page even though the impala daemon is up and running and giving no error in log file:- Potential misconfiguration detected. Fix and restart Hue. Impala Editor No available Impalad to send queries to. I am using CDH 5.2 on RED hat linux 6.5
... View more
Labels:
12-05-2014
11:53 AM
1 Kudo
Accumulo is just a warning You need to put the sql connector jar in /var/lib/sqoop to make it work.
... View more
12-03-2014
02:18 PM
1 Kudo
Yes it worked but gave an error related to table name not correct. Also i changed the driver from ojdbc 6 to ojdbc 7 because java version is 1.7 ,with 1.6 when i removed driver it gave null pointer exception. Thanks,That was easy. 🙂
... View more
12-03-2014
01:57 PM
I am trying to import the data from oracle database. CDH5.2,java 1.7,Oracle jar file in /var/lib/sqoop/ojdbc7.jar The command is :- sqoop import --connect "jdbc:oracle:thin:@host:1684:servicename" --driver "oracle.jdbc.driver.OracleDriver" --username "xxxx" --password "xxxx" --table "testdta.F41021" --hive-import error i am getting is :- Warning: /apps/opt/cloudera/parcels/CDH-5.2.0-1.cdh5.2.0.p0.36/bin/../lib/sqoop/../accumulo does not exist! Accumulo imports will fail. Please set $ACCUMULO_HOME to the root of your Accumulo installation. 14/12/03 16:52:06 INFO sqoop.Sqoop: Running Sqoop version: 1.4.5-cdh5.2.0 14/12/03 16:52:06 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead. 14/12/03 16:52:06 INFO tool.BaseSqoopTool: Using Hive-specific delimiters for output. You can override 14/12/03 16:52:06 INFO tool.BaseSqoopTool: delimiters with --fields-terminated-by, etc. 14/12/03 16:52:06 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. 14/12/03 16:52:06 INFO manager.SqlManager: Using default fetchSize of 1000 14/12/03 16:52:06 INFO tool.CodeGenTool: Beginning code generation 14/12/03 16:52:12 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM testdta.F41021 AS t WHERE 1=0 14/12/03 16:52:12 ERROR manager.SqlManager: Error executing statement: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:776) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:897) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1034) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3867) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1502) at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:750) at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:759) at org.apache.sqoop.manager.SqlManager.getColumnInfoForRawQuery(SqlManager.java:269) at org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:240) at org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:226) at org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:295) at org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1829) at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1641) at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:96) at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:478) at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:605) at org.apache.sqoop.Sqoop.run(Sqoop.java:143) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:218) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227) at org.apache.sqoop.Sqoop.main(Sqoop.java:236) 14/12/03 16:52:12 ERROR tool.ImportTool: Encountered IOException running import job: java.io.IOException: No columns to generate for ClassWriter at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1647) at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:96) at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:478) at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:605) at org.apache.sqoop.Sqoop.run(Sqoop.java:143) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:218) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227) at org.apache.sqoop.Sqoop.main(Sqoop.java:236)
... View more
11-13-2014
11:58 AM
Yes ,It was a typo error, I meant the space should be there. 🙂 */admin@My-Realm.COM *
... View more
11-13-2014
09:40 AM
I was able to reolve it. The space should not be there between COM and * in kadm5.acl Thanks !! 🙂
... View more
11-11-2014
12:15 PM
My kadm5.acl is like this :- */admin@JNJ.COM* ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ "/var/kerberos/krb5kdc/kadm5.acl" 1L, 18C So you are suggesting is to add cloudera-scm/admin@JNJ.COM too right?
... View more
11-11-2014
11:37 AM
Its KDC 5 running on rhel 6.3 and my kadm5.acl file has admin@JNJ.COM
... View more
11-11-2014
11:12 AM
the latest 5.2 version of cloudera is used
... View more