mysql - Datastax hadoop InvalidRequestException(why:You have not logged in) -
i have installed datastax enterprise "dse-4.0.1", when tried demo per below link
http://www.datastax.com/docs/datastax_enterprise2.0/sqoop/sqoop_demo, getting below error, can please me issue, facing, log file attached reference.
[root@chbslx0624 bin]# ./dse sqoop import --connect jdbc:mysql://127.0.0.1/npa_nxx_demo --username root --password poc123 --table npa_nxx --target-dir /npa_nxx 14/04/14 10:44:14 warn tool.basesqooptool: setting password on command-line insecure. consider using -p instead. 14/04/14 10:44:14 info manager.mysqlmanager: preparing use mysql streaming resultset. 14/04/14 10:44:14 info tool.codegentool: beginning code generation 14/04/14 10:44:14 info manager.sqlmanager: executing sql statement: select t.* `npa_nxx` t limit 1 14/04/14 10:44:14 info manager.sqlmanager: executing sql statement: select t.* `npa_nxx` t limit 1 14/04/14 10:44:14 info orm.compilationmanager: hadoop_home /opt/cassandra/dse-4.0.1/resources/hadoop/bin/.. note: /tmp/sqoop-root/compile/b0fc8093d30c07f252da42678679e461/npa_nxx.java uses or overrides deprecated api. note: recompile -xlint:deprecation details. 14/04/14 10:44:15 info orm.compilationmanager: writing jar file: /tmp/sqoop-root/compile/b0fc8093d30c07f252da42678679e461/npa_nxx.jar 14/04/14 10:44:15 warn manager.mysqlmanager: looks importing mysql. 14/04/14 10:44:15 warn manager.mysqlmanager: transfer can faster! use --direct 14/04/14 10:44:15 warn manager.mysqlmanager: option exercise mysql-specific fast path. 14/04/14 10:44:15 info manager.mysqlmanager: setting 0 datetime behavior converttonull (mysql) 14/04/14 10:44:15 info mapreduce.importjobbase: beginning import of npa_nxx 14/04/14 10:44:17 info snitch.workload: setting workload cassandra 14/04/14 10:44:18 error security.usergroupinformation: priviledgedactionexception as:root cause:java.io.ioexception: invalidrequestexception(why:you have not logged in) 14/04/14 10:44:18 error tool.importtool: encountered ioexception running import job: java.io.ioexception: invalidrequestexception(why:you have not logged in) @ com.datastax.bdp.util.cassandraproxyclient.initialize(cassandraproxyclient.java:453) @ com.datastax.bdp.util.cassandraproxyclient.<init>(cassandraproxyclient.java:376) @ com.datastax.bdp.util.cassandraproxyclient.newproxyconnection(cassandraproxyclient.java:259) @ com.datastax.bdp.util.cassandraproxyclient.newproxyconnection(cassandraproxyclient.java:306) @ com.datastax.bdp.hadoop.cfs.cassandrafilesystemthriftstore.initialize(cassandrafilesystemthriftstore.java:230) @ com.datastax.bdp.hadoop.cfs.cassandrafilesystem.initialize(cassandrafilesystem.java:73) @ org.apache.hadoop.fs.filesystem.createfilesystem(filesystem.java:1386) @ org.apache.hadoop.fs.filesystem.access$200(filesystem.java:66) @ org.apache.hadoop.fs.filesystem$cache.get(filesystem.java:1404) @ org.apache.hadoop.fs.filesystem.get(filesystem.java:254) @ org.apache.hadoop.fs.path.getfilesystem(path.java:187) @ org.apache.hadoop.mapreduce.jobsubmissionfiles.getstagingdir(jobsubmissionfiles.java:97) @ org.apache.hadoop.mapred.jobclient$2.run(jobclient.java:856) @ org.apache.hadoop.mapred.jobclient$2.run(jobclient.java:850) @ java.security.accesscontroller.doprivileged(native method) @ javax.security.auth.subject.doas(subject.java:415) @ org.apache.hadoop.security.usergroupinformation.doas(usergroupinformation.java:1121) @ org.apache.hadoop.mapred.jobclient.submitjobinternal(jobclient.java:850) @ org.apache.hadoop.mapreduce.job.submit(job.java:500) @ org.apache.hadoop.mapreduce.job.waitforcompletion(job.java:530) @ org.apache.sqoop.mapreduce.importjobbase.runjob(importjobbase.java:141) @ org.apache.sqoop.mapreduce.importjobbase.runimport(importjobbase.java:202) @ org.apache.sqoop.manager.sqlmanager.importtable(sqlmanager.java:475) @ org.apache.sqoop.manager.mysqlmanager.importtable(mysqlmanager.java:108) @ org.apache.sqoop.tool.importtool.importtable(importtool.java:403) @ org.apache.sqoop.tool.importtool.run(importtool.java:476) @ org.apache.sqoop.sqoop.run(sqoop.java:145) @ org.apache.hadoop.util.toolrunner.run(toolrunner.java:65) @ org.apache.sqoop.sqoop.runsqoop(sqoop.java:181) @ org.apache.sqoop.sqoop.runtool(sqoop.java:220) @ org.apache.sqoop.sqoop.runtool(sqoop.java:229) @ org.apache.sqoop.sqoop.main(sqoop.java:238) @ com.cloudera.sqoop.sqoop.main(sqoop.java:57) caused by: invalidrequestexception(why:you have not logged in) @ org.apache.cassandra.thrift.cassandra$describe_keyspaces_result$describe_keyspaces_resultstandardscheme.read(cassandra.java:31961) @ org.apache.cassandra.thrift.cassandra$describe_keyspaces_result$describe_keyspaces_resultstandardscheme.read(cassandra.java:31928) @ org.apache.cassandra.thrift.cassandra$describe_keyspaces_result.read(cassandra.java:31870) @ org.apache.thrift.tserviceclient.receivebase(tserviceclient.java:78) @ org.apache.cassandra.thrift.cassandra$client.recv_describe_keyspaces(cassandra.java:1181) @ org.apache.cassandra.thrift.cassandra$client.describe_keyspaces(cassandra.java:1169) @ com.datastax.bdp.util.cassandraproxyclient.initialize(cassandraproxyclient.java:425) ... 32 more
it looks have local running cassandra node username/password enable. can follow latest document, , start dse -t run import script.
Comments
Post a Comment