hadoop - error while using sqoop for data transfer to hdfs -

-

i have used sqoop transfer data between hdfs , oracle shown below :

hadoop@jiogis-cluster-jiogis-master-001:~$ sqoop import --connect jdbc:oracle:gis-scan.ril.com/sat --username=r4g_viewer --password=viewer_123 --table=r4g_osp.enodeb --hive-import  --hive-table=enodeb --target-dir=user/hive/warehouse/proddb/jiocenterboundary -- direct

and error shown below when use sqoop show above

warning: /volumes/disk1/sqoop-1.4.6.bin__hadoop-2.0.4-alpha/../hbase not exist! hbase imports fail. please set $hbase_home root of hbase installation. warning: /volumes/disk1/sqoop-1.4.6.bin__hadoop-2.0.4-alpha/../hcatalog not exist! hcatalog jobs fail. please set $hcat_home root of hcatalog installation. warning: /volumes/disk1/sqoop-1.4.6.bin__hadoop-2.0.4-alpha/../accumulo not exist! accumulo imports fail. please set $accumulo_home root of accumulo installation. 16/05/09 11:11:19 info sqoop.sqoop: running sqoop version: 1.4.6 16/05/09 11:11:19 warn tool.basesqooptool: setting password on command-line insecure. consider using -p instead. 16/05/09 11:11:19 info tool.basesqooptool: using hive-specific delimiters output. can override 16/05/09 11:11:19 info tool.basesqooptool: delimiters --fields-terminated-by, etc. 16/05/09 11:11:19 info oracle.oraoopmanagerfactory: data connector oracle , hadoop disabled.  16/05/09 11:11:19 error tool.basesqooptool: got error creating database manager: java.io.ioexception: no manager connect string: jdbc:oracle:gis-scan.ril.com/sat         @ org.apache.sqoop.connfactory.getmanager(connfactory.java:191)         @ org.apache.sqoop.tool.basesqooptool.init(basesqooptool.java:256)         @ org.apache.sqoop.tool.importtool.init(importtool.java:89)         @ org.apache.sqoop.tool.importtool.run(importtool.java:593)         @ 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)

your jdbc connection string not correct. can try in format:

--connect jdbc:oracle:thin:@//hostname:port/servicename

in case, probably:

--connect jdbc:oracle:thin:@//gis-scan.ril.com:1521/sat

you may want double check port number correct scan listener may not on default 1521 port.


Comments

Post a Comment

Popular posts from this blog

javascript - Laravel datatable invalid JSON response -

-
everything work fine on code below fetch user logs: js: <script> $(document).ready(function () { var table =$('#systemlogs').datatable({ responsive: true, processing: true, serverside: true, "language": { "url": "/datatables/media/plug-in/persian.json" }, ajax: '{!! url('/admin/systemlogs/data/systemlogsdatatable') !!}', columns: [ { data: 'name', name: 'name' }, { data: 'message_text', name: 'message_text' }, { data: 'remote_addr', name: 'remote_addr' }, { data: 'log_created_at', name: 'management_logs.created_at' }, { data: 'log_updated_at', name: 'management_logs.updated_at' }, ] }); }); </script> routes: route::get('/systemlogs/data/systemlogsdatatable','systemlogscontrolle...
Read more

java - Exception in thread "main" org.springframework.context.ApplicationContextException: Unable to start embedded container; -

-
i getting error when run spring application: exception in thread "main" org.springframework.context.applicationcontextexception: unable start embedded container; nested exception org.springframework.context.applicationcontextexception: unable start embeddedwebapplicationcontext due missing embeddedservletcontainerfactory bean. @ org.springframework.boot.context.embedded.embeddedwebapplicationcontext.onrefresh(embeddedwebapplicationcontext.java:124) @ org.springframework.context.support.abstractapplicationcontext.refresh(abstractapplicationcontext.java:476) @ org.springframework.boot.context.embedded.embeddedwebapplicationcontext.refresh(embeddedwebapplicationcontext.java:109) @ org.springframework.boot.springapplication.refresh(springapplication.java:691) @ org.springframework.boot.springapplication.run(springapplication.java:320) @ org.springframework.boot.springapplication.run(springapplication.java:952) @ org.springframework.boot.springa...
Read more

sql server 2008 - My Sql Code Get An Error Of Msg 245, Level 16, State 1, Line 1 Conversion failed when converting the varchar value '8:45 AM' to data type int -

-
msg 245, level 16, state 1, line 1 conversion failed when converting varchar value '8:45 am' data type int. script declare @specimenid bigint = 0, @script varchar(max); declare @starttime int = (select convert(int,substring(start_time,0,charindex(':', start_time)) - 12) appt appt._id=112601) --select @starttime set @script = 'select distinct ptlast_name + '', '' + pt.first_name patient_name, dbo.formatdate(pt.dob,''mm/dd/yyyy'') dob, (convert(varchar, (datediff(yy, dob, appt_date) - case when (month(dob) > month(appt_date)) or (month(dob) = month(appt_date) , day(dob) > day(appt_date)) 1 else 0 end)) + ''/'' + convert(varchar, (datediff(m, dateadd(yy, (datediff(yy, dob, appt_date) - case when (month(dob) > month(appt_date)) or (month(dob) = month(appt_date) , day(dob) > day(appt_date)) 1 else 0 end), d...
Read more