hadoop - sqoop data from oracle to hive ERROR -

-

i'm trying sqoop data oracle hdfs. i'm using sqoop purpose. downloaded ojdbc6.jar , put in /usr/hdp/2.2.0.0-2041/sqoop/lib path , executed following command check whether i'm able connect oracle database.

    sqoop list-databases --connect jdbc:oracle:thin:@hostname:port/service --username xxxx --password xxxx --verbose;

i'm getting following error.

warning: /usr/hdp/2.2.0.0-2041/accumulo not exist! accumulo imports fail. please set $accumulo_home root of accumulo installation. 15/05/29 15:24:42 info sqoop.sqoop: running sqoop version: 1.4.5.2.2.0.0-2041 15/05/29 15:24:42 debug tool.basesqooptool: enabled debug logging. 15/05/29 15:24:42 warn tool.basesqooptool: setting password on command-line insecure. consider using -p instead. 15/05/29 15:24:43 debug sqoop.connfactory: loaded manager factory: org.apache.sqoop.manager.oracle.oraoopmanagerfactory 15/05/29 15:24:43 debug sqoop.connfactory: loaded manager factory: com.cloudera.sqoop.manager.defaultmanagerfactory 15/05/29 15:24:43 debug sqoop.connfactory: trying managerfactory: org.apache.sqoop.manager.oracle.oraoopmanagerfactory 15/05/29 15:24:44 debug oracle.oraoopmanagerfactory: data connector oracle , hadoop can called sqoop! 15/05/29 15:24:44 info oracle.oraoopmanagerfactory: data connector oracle , hadoop disabled. 15/05/29 15:24:44 debug sqoop.connfactory: trying managerfactory: com.cloudera.sqoop.manager.defaultmanagerfactory 15/05/29 15:24:44 debug manager.defaultmanagerfactory: trying scheme: jdbc:oracle:thin:@hostname 15/05/29 15:24:45 debug manager.oraclemanager$conncache: instantiated new connection cache. 15/05/29 15:24:45 info manager.sqlmanager: using default fetchsize of 1000 15/05/29 15:24:45 debug sqoop.connfactory: instantiated connmanager org.apache.sqoop.manager.oraclemanager@2f37e8bc 15/05/29 15:24:46 debug manager.oraclemanager: creating new connection jdbc:oracle:thin:@hostname:port/service, using username: username 15/05/29 15:24:46 debug manager.oraclemanager: no connection paramenters specified. using regular api making connection. 15/05/29 15:25:07 error sqoop.sqoop: got exception running sqoop: java.lang.nullpointerexception java.lang.nullpointerexception         @ org.apache.sqoop.manager.oraclemanager.listdatabases(oraclemanager.java:695)         @ org.apache.sqoop.tool.listdatabasestool.run(listdatabasestool.java:49)         @ org.apache.sqoop.sqoop.run(sqoop.java:143)         @ org.apache.hadoop.util.toolrunner.run(toolrunner.java:70)         @ org.apache.sqoop.sqoop.runsqoop(sqoop.java:179)         @ org.apache.sqoop.sqoop.runtool(sqoop.java:218)         @ org.apache.sqoop.sqoop.runtool(sqoop.java:227)         @ org.apache.sqoop.sqoop.main(sqoop.java:236)

is error because of grant permissions? need t grant permissions? or connection error?

i worked around sqoop command , found solution. worked me. pinged hostname cmd , found out ip address pinging to. replaced hostname ipaddress in sqooop execution command , working.


Comments

Post a Comment

Popular posts from this blog

Java 3D LWJGL collision -

-
i making 3d java game lwjgl library, , wondering how add collision detection, player not go through models. i using obj models. here objloader class, loads models: package renderengine; import java.io.bufferedreader; import java.io.file; import java.io.filenotfoundexception; import java.io.filereader; import java.util.arraylist; import java.util.list; import models.rawmodel; import org.lwjgl.util.vector.vector2f; import org.lwjgl.util.vector.vector3f; public class objloader { public static rawmodel loadobjmodel(string filename, loader loader){ filereader fr = null; try { fr = new filereader(new file("res/"+filename+".obj")); } catch (filenotfoundexception e) { system.err.println("couldn't load file!"); e.printstacktrace(); } bufferedreader reader = new bufferedreader(fr); string line; list<vector3f> vertices = new arraylist<vector3f...
Read more

spring - SubProtocolWebSocketHandler - No handlers -

-
i have ugly error during deploying spring app on jboss. 18:11:16,025 error [org.apache.catalina.core.containerbase.[jboss.web].[default-host].[/consumer]] (msc service thread 1-7) exception sending context initialized event listener instance of class org.springframework.web.context.contextloaderlistener: org.springframework.context.applicationcontextexception: failed start bean 'subprotocolwebsockethandler'; nested exception java.lang.illegalargumentexception: no handlers @ org.springframework.context.support.defaultlifecycleprocessor.dostart(defaultlifecycleprocessor.java:176) [spring-context-4.1.3.release.jar:4.1.3.release] @ org.springframework.context.support.defaultlifecycleprocessor.access$200(defaultlifecycleprocessor.java:51) [spring-context-4.1.3.release.jar:4.1.3.release] @ org.springframework.context.support.defaultlifecycleprocessor$lifecyclegroup.start(defaultlifecycleprocessor.java:346) [spring-context-4.1.3.release.jar:4.1.3.release] @ org.s...
Read more

methods - python can't use function in submodule -

-
my folder structure this: pythonstuff/ program.py modulea/ __init__.py foo.py bar.py here's code bar.py : def hello(): print("hello, world!") here's code program.py : #!/usr/bin/env python3 modulea import bar bar.hello() i run $ python3 program.py somehow error: file "program.py", line 3, in <module> bar.hello() attributeerror: 'module' object has no attribute 'hello' edit: __init__.py file empty. edit2: after trying realized had bar.py in root directory contained hello() method. bar.py in modulea/ directory empty. add it import os __all__ = [] module in os.listdir(os.path.dirname(__file__)): if module != '__init__.py' , module[-3:] == '.py': __all__.append(module[:-3]) the init .py files required make python treat directories containing packages; done prevent directories common name, such string, unintentionally hiding v...
Read more