oozie调用sqoop import任务,一直处于running状态 5C

sqoop import命令在窗口直接执行时没有问题的,但是通过oozie去调用就出现这种问题
oozie调用sqoop list-databases也是可以成功的
有没有大神给分析一下是哪些地方的问题,内存不足还是什么问题
workflow.xml

<action name="sqoop-node">
    <sqoop xmlns="uri:oozie:sqoop-action:0.3">
        <job-tracker>${jobTracker}</job-tracker>
        <name-node>${nameNode}</name-node>
        <configuration>
            <property>
                <name>mapred.job.queue.name</name>
                <value>${queueName}</value>
            </property>
        </configuration>
        <command>import --connect jdbc:mysql://10.148.1.100:3306/test --username root --password 123456 --table person --target-dir /user/root/testSqoop/output --fields-terminated-by "," --num-mappers 1 --direct</command>
    </sqoop>
    <ok to="end"/>
    <error to="fail"/>
</action>

<kill name="fail">
    <message>Sqoop failed, error message[${wf:errorMessage(wf:lastErrorNode())}]</message>
</kill>
<end name="end"/>


oozie console
图片说明

hadoop applacation
图片说明
图片说明
疑问为什么会起两个 MAPREDUCE任务

虚拟机内存情况
图片说明

日志信息
2018-06-14 11:08:20,625 [uber-SubtaskRunner] WARN org.apache.sqoop.tool.SqoopTool - $SQOOP_CONF_DIR has not been set in the environment. Cannot check for additional configuration.
2018-06-14 11:08:20,649 [uber-SubtaskRunner] INFO org.apache.sqoop.Sqoop - Running Sqoop version: 1.4.6
2018-06-14 11:08:20,664 [uber-SubtaskRunner] WARN org.apache.sqoop.tool.BaseSqoopTool - Setting your password on the command-line is insecure. Consider using -P instead.
2018-06-14 11:08:20,676 [uber-SubtaskRunner] WARN org.apache.sqoop.ConnFactory - $SQOOP_CONF_DIR has not been set in the environment. Cannot check for additional configuration.
2018-06-14 11:08:20,779 [uber-SubtaskRunner] INFO org.apache.sqoop.manager.MySQLManager - Preparing to use a MySQL streaming resultset.
2018-06-14 11:08:20,784 [uber-SubtaskRunner] INFO org.apache.sqoop.tool.CodeGenTool - Beginning code generation
2018-06-14 11:08:21,235 [uber-SubtaskRunner] INFO org.apache.sqoop.manager.SqlManager - Executing SQL statement: SELECT t.* FROM person AS t LIMIT 1
2018-06-14 11:08:21,261 [uber-SubtaskRunner] INFO org.apache.sqoop.manager.SqlManager - Executing SQL statement: SELECT t.* FROM person AS t LIMIT 1
2018-06-14 11:08:21,266 [uber-SubtaskRunner] INFO org.apache.sqoop.orm.CompilationManager - HADOOP_MAPRED_HOME is /opt/hadoop-2.6.0
2018-06-14 11:08:23,470 [uber-SubtaskRunner] INFO org.apache.sqoop.orm.CompilationManager - Writing jar file: /tmp/sqoop-root/compile/8750ac72c9db5da23fa902b0a16d1957/person.jar
2018-06-14 11:08:23,485 [uber-SubtaskRunner] INFO org.apache.sqoop.manager.DirectMySQLManager - Beginning mysqldump fast path import
2018-06-14 11:08:23,485 [uber-SubtaskRunner] INFO org.apache.sqoop.mapreduce.ImportJobBase - Beginning import of person
2018-06-14 11:08:23,486 [uber-SubtaskRunner] INFO org.apache.hadoop.conf.Configuration.deprecation - mapred.job.tracker is deprecated. Instead, use mapreduce.jobtracker.address
2018-06-14 11:08:23,491 [uber-SubtaskRunner] INFO org.apache.hadoop.conf.Configuration.deprecation - mapred.jar is deprecated. Instead, use mapreduce.job.jar
2018-06-14 11:08:23,505 [uber-SubtaskRunner] INFO org.apache.hadoop.conf.Configuration.deprecation - mapred.map.tasks is deprecated. Instead, use mapreduce.job.maps
2018-06-14 11:08:23,509 [uber-SubtaskRunner] WARN org.apache.sqoop.mapreduce.JobBase - SQOOP_HOME is unset. May not be able to find all job dependencies.
2018-06-14 11:08:23,559 [uber-SubtaskRunner] INFO org.apache.hadoop.yarn.client.RMProxy - Connecting to ResourceManager at study/10.148.1.100:8032
2018-06-14 11:08:23,928 [uber-SubtaskRunner] INFO org.apache.sqoop.mapreduce.db.DBInputFormat - Using read commited transaction isolation
2018-06-14 11:08:23,996 [uber-SubtaskRunner] INFO org.apache.hadoop.mapreduce.JobSubmitter - number of splits:1
2018-06-14 11:08:24,051 [uber-SubtaskRunner] INFO org.apache.hadoop.mapreduce.JobSubmitter - Submitting tokens for job: job_1528942657382_0005
2018-06-14 11:08:24,051 [uber-SubtaskRunner] INFO org.apache.hadoop.mapreduce.JobSubmitter - Kind: YARN_AM_RM_TOKEN, Service: , Ident: (appAttemptId { application_id { id: 4 cluster_timestamp: 1528942657382 } attemptId: 1 } keyId: 589196118)
2018-06-14 11:08:24,053 [uber-SubtaskRunner] INFO org.apache.hadoop.mapreduce.JobSubmitter - Kind: RM_DELEGATION_TOKEN, Service: 10.148.1.100:8032, Ident: (owner=root, renewer=oozie mr token, realUser=root, issueDate=1528945693299, maxDate=1529550493299, sequenceNumber=3, masterKeyId=2)
2018-06-14 11:08:24,211 [uber-SubtaskRunner] WARN org.apache.hadoop.mapreduce.v2.util.MRApps - cache file (mapreduce.job.cache.files) hdfs://study:9000/user/root/testSqoop/lib/sqoop-1.4.6-hadoop200.jar conflicts with cache file (mapreduce.job.cache.files) hdfs://study:9000/tmp/hadoop-yarn/staging/root/.staging/job_1528942657382_0005/libjars/sqoop-1.4.6-hadoop200.jar This will be an error in Hadoop 2.0
2018-06-14 11:08:24,213 [uber-SubtaskRunner] WARN org.apache.hadoop.mapreduce.v2.util.MRApps - cache file (mapreduce.job.cache.files) hdfs://study:9000/user/root/testSqoop/lib/mysql-connector-java.jar conflicts with cache file (mapreduce.job.cache.files) hdfs://study:9000/tmp/hadoop-yarn/staging/root/.staging/job_1528942657382_0005/libjars/mysql-connector-java.jar This will be an error in Hadoop 2.0
2018-06-14 11:08:24,265 [uber-SubtaskRunner] INFO org.apache.hadoop.yarn.client.api.impl.YarnClientImpl - Submitted application application_1528942657382_0005
2018-06-14 11:08:24,301 [uber-SubtaskRunner] INFO org.apache.hadoop.mapreduce.Job - The url to track the job: http://study:8088/proxy/application_1528942657382_0005/
2018-06-14 11:08:24,301 [uber-SubtaskRunner] INFO org.apache.hadoop.mapreduce.Job - The url to track the job: http://study:8088/proxy/application_1528942657382_0005/
2018-06-14 11:08:24,302 [uber-SubtaskRunner] INFO org.apache.hadoop.mapreduce.Job - Running job: job_1528942657382_0005
2018-06-14 11:08:24,302 [uber-SubtaskRunner] INFO org.apache.hadoop.mapreduce.Job - Running job: job_1528942657382_0005
2018-06-14 11:08:25,976 [communication thread] INFO org.apache.hadoop.mapred.TaskAttemptListenerImpl - Progress of TaskAttempt attempt_1528942657382_0004_m_000000_0 is : 1.0
2018-06-14 11:08:25,976 [communication thread] INFO org.apache.hadoop.mapred.TaskAttemptListenerImpl - Progress of TaskAttempt attempt_1528942657382_0004_m_000000_0 is : 1.0
Heart beat
2018-06-14 11:08:56,045 [communication thread] INFO org.apache.hadoop.mapred.TaskAttemptListenerImpl - Progress of TaskAttempt attempt_1528942657382_0004_m_000000_0 is : 1.0
2018-06-14 11:08:56,045 [communication thread] INFO org.apache.hadoop.mapred.TaskAttemptListenerImpl - Progress of TaskAttempt attempt_1528942657382_0004_m_000000_0 is : 1.0
Heart beat
2018-06-14 11:09:26,082 [communication thread] INFO org.apache.hadoop.mapred.TaskAttemptListenerImpl - Progress of TaskAttempt attempt_1528942657382_0004_m_000000_0 is : 1.0
2018-06-14 11:09:26,082 [communication thread] INFO org.apache.hadoop.mapred.TaskAttemptListenerImpl - Progress of TaskAttempt attempt_1528942657382_0004_m_000000_0 is : 1.0
Heart beat

3个回答

33763 [uber-SubtaskRunner] WARN org.apache.sqoop.hive.TableDefWriter - Column DB_TID had to be cast to a less precise type in Hive
33763 [uber-SubtaskRunner] WARN org.apache.sqoop.hive.TableDefWriter - Column PROD_TID had to be cast to a less precise type in Hive
33763 [uber-SubtaskRunner] WARN org.apache.sqoop.hive.TableDefWriter - Column TM_TID had to be cast to a less precise type in Hive
33763 [uber-SubtaskRunner] WARN org.apache.sqoop.hive.TableDefWriter - Column STATE had to be cast to a less precise type in Hive
这个是因为导入的数据类型和被导入的数据类型,二者不一致,需要使用cast转换下。
比如时间time,在hive里面需要转换为时间戳。

sqoop import --connect "jdbc:sqlserver://xxxx:1433;DatabaseName=test" --username xxx --password 123456 --query 'SELECT 。。。。。。。 CAST (DB_TID AS hivetype), ... FROM AU_User WHERE $CONDITIONS'也就是将DB_TID 转换为hive的数据类型。

yulongxy
生命在于扯淡 是不是回答错问题了...感觉答非所问啊
一年多之前 回复

这是因为导入的数据类型和被导入的数据类型,二者不一致,需要使用cast转换下。
比如时间time,在hive里面需要转换为时间戳。

yulongxy
生命在于扯淡 是不是回答错问题了...感觉答非所问啊
一年多之前 回复

问题已经解决了,写完这个问题之后,发现下面有个相关推荐给解决了这个问题

具体链接如下:https://blog.csdn.net/u010770993/article/details/70312473

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
其他相关推荐
maven搭建一直处于running:..状态
用maven搭建项目时,到最后一直处于加载状态,如图: 上网查资料得出解决办法,在此记录,为后效 1、File--&amp;gt;setting--&amp;gt;Build,Execution,Deployment--&amp;gt;Maven--&amp;gt;running   VM Options:处填写:-DarchetypeCatalog=internal 更改如图:  (完成后 点击Apply 、OK) ...
oozie的定时spark2任务出现一直running的状态,并且查看任务发现有异常
具体任务的日志:2018-06-30 17:18:06,936 ERROR [RMCommunicator Allocator] org.apache.hadoop.mapreduce.v2.app.rm.RMCommunicator: ERROR IN CONTACTING RM. rnjava.lang.ArithmeticException: / by zerorn at org.apache.hadoop.mapreduce.v2.app.rm.ResourceCalculatorUtils.computeAvailableContainers(ResourceCalculatorUtils.java:38)rn at org.apache.hadoop.mapreduce.v2.app.rm.RMContainerAllocator$ScheduledRequests.assign(RMContainerAllocator.java:1028)rn at org.apache.hadoop.mapreduce.v2.app.rm.RMContainerAllocator$ScheduledRequests.access$200(RMContainerAllocator.java:920)rn at org.apache.hadoop.mapreduce.v2.app.rm.RMContainerAllocator.heartbeat(RMContainerAllocator.java:258)rn at org.apache.hadoop.mapreduce.v2.app.rm.RMCommunicator$AllocatorRunnable.run(RMCommunicator.java:281)rn at java.lang.Thread.run(Thread.java:745)rn2018-06-30 17:18:07,938 INFO [RMCommunicator Allocator] org.apache.hadoop.mapreduce.v2.app.rm.RMContainerAllocator: Before Scheduling: PendingReds:0 ScheduledMaps:1 ScheduledReds:0 AssignedMaps:0 AssignedReds:0 CompletedMaps:0 CompletedReds:0 ContAlloc:1 ContRel:0 HostLocal:0 RackLocal:0rn
oozie在执行coordinator job的时候,一直处于waiting状态
问题: oozie在执行coordinator job的时候,一直处于waiting状态 解决方式: 1.oozie在执行coordinator job的时候,会初始化标签中的参数, 首先查看是不是url路径配置错误。 2.查看日志: 1)oozie job -oozie http://localhost:11000/oozie -log 0000047-180528113614146-...
Hadoop运行wordcount,一直处于Running job状态
症状:rn1.命令行中一直处于rnINFO mapreduce.Job:Running job:job_14271093...这种状态rnrn2.日志一直处于打印rnINFO .....blockmanagement.CacheReplicationMonitor.Scanned 0 directive(s) and 0 block(s) in 0 millisecond(s)这种状态。rnrn求高手啊。。
Android Studio 一直处于 Gradle Build Running 状态
起因是系统提示出现渲染器问题:n![图片说明](https://img-ask.csdn.net/upload/201511/10/1447135296_931916.jpg)n新建工程后就一直处于 Gradle Build Running 状态:n![图片说明](https://img-ask.csdn.net/upload/201511/10/1447135395_265059.jpg)n已挂VPN...我的 Android Studio 还没有成功运行过,求大神指教是哪里配置有问题?nJDK的版本是1.8.0.65,gradle2.4。
datastage抽取hdfs文件,job为什么一直处于running状态?
今天凌晨5点左右跑了一个从hdfs文件加载数据到数据库的job,该作业一直处于运行状态(持续了4个多小时,到9点中左右人工干预把job给kill掉了)。正常情况下该作业只需要几分种就可以跑完。下图是作业两次运行的日志,红色标记1是有问题时的日子,标记2是正常的日志。对比2次日志,发现有问题的日志一直停留在查找148rows的文件,按照我的理解该份数据在hdfs上是存储在两个节点上,问题1只找到了一个节点的数据,另一个节点的数据一直找不到?不知道是不是这样,为什么会出现这种现象?请各位大神解释下。rn[img=https://img-bbs.csdn.net/upload/201804/12/1523519185_88553.png][/img]
datastage 问题请教job一直处于running状态
环境rnds 7.5.3 版本rn操作系统 Linuxrndsjob使用load方式加载数据rnrnjob偶尔会一直在running状态,并且不能停掉。查看日志数据已经全部加载完毕。日志停止在提示加载了多少条数据哪里。rnrn这种情况可能出现在任何一个job上,有些job会报一个警告Job control process (pid 2757) has failed,但是有些job不会报这个警告。rnrn求高手指教,谢谢rnrn因本人非负责这一块,对ds不是很懂,现在是项目的擦屁股阶段,我只能硬着头皮找答案,希望知道解决办法的能给详细点的解决方法rn
Oozie分布式任务的工作流——Sqoop篇
Oozie分布式任务的工作流——Sqoop篇 Sqoop的使用应该是Oozie里面最常用的了,因为很多BI数据分析都是基于业务数据库来做的,因此需要把mysql或者oracle的数据导入到hdfs中再利用mapreduce或者spark进行ETL,生成报表信息。 因此本篇的Sqoop Action其实就是运行一个sqoop的任务而已。 同样ac...
DSEE7—LDAP import导入数据不成功,一直处于导入状态
正在初始化后缀 xxxxxxxxx 正在执行操作...   使用 LDIF 文件 /opt/xxxx.ldif 的内容启动后缀 xxxxx 的导入操作 . . . . . 完成。  导入 LDIF 日志: Index buffering enabled with bucket size 40 Beginning import job... Starting to process and
谷歌浏览器一直处于加载状态
页面在火狐和IE下显示正常,加载速度很快。rnrn在chrome下功能一切正常,开发工具显示脚本也加载正常,rn但是选项卡的图标一直呈现加载状态。rnrn左下角信息有时候什么都没有,有时显示:等待XXX响应、等待写入缓存。rn这时按F12打开控制台就好了,F5刷新问题依旧。rnrn页面用到了百度编辑器,其他没什么特殊的,rn不知道有人碰到过类似问题么?rn
tomcat一直处于deploying状态。
今天写了个ssh项目。但tomcat无论如何都启动不起来。始终是deploying状态。 用MyEclipse6.6 和idea14都不好用。 最后当我安装idea15的时候,提示 “netsh advfirewall set global StatefulFTP disable” 当我按照提示在CMD 执行如下命令后,可以正常启动了。(仅供参考,具体原因未知) netsh advfire
显示器一直处于待机状态?
开机后显示器指示灯不会变绿,怀疑是显卡问题,更换后问题依旧。把显示器和电脑连线拔掉后,屏幕会出现“no singnal",应该不是显示器坏了。不知是何原因,请指教。
页面一直处于加载状态
找了个日历,修改了以下,以前无法盖住select控件,现在利用iframe遮住了,可问题也来了,只要是打开页面,状态栏一直显示正处于打开状态,永远也不会加载完 ,这是怎么回事呢 这个例子在 [url=http://d.namipan.com/d/20c615160d841876bf29a6286df570867997da11f9230000][/url] 希望大家帮帮忙~
tomcat一直处于stopped的状态
配置也配置好了,localhost:8080也都能打开,就是打开Tomcat启动不了,一直是Service Status: Stopped,Start点了也没用,怎么启动啊?
页面一直处于加载状态?
用了第三方控件ExtAspNet,当用到Grid控件时,信息显示不出来,一直处于加载状态,刷不出来,为什么会这样?
一直处于读硬盘状态
本人计算机处于使用状态时,没有任何问题,但是,如果超过10分钟不对计算机进行任何操作,再次进行操作后,就会出现一直在读硬盘的情况而且不停止,请问这时为什么,应该怎样处理?
Sqoop import
本次课程让学员全面系统地学习大数据平台运维,开发的操作。课程内容涉及到大数据生态系统的各项工具,内容全面,讲解细致,助您全面掌握大数据平台运维及开发工具的作用
oozie 调用 sqoop,出现这个错误 Failing Oozie Launcher
Sqoop command arguments :rn importrn --connectrn jdbc:mysql://cdh5.hadoop.com:3306/testrn --usernamern rootrn --passwordrn 123456rn --tablern epc_partgrouprn --num-mappersrn 1rn --fields-terminated-byrn "\t"rn --delete-target-dirrn --hive-databasern hive_garyrn --hive-importrn --hive-tablern epc_partgrouprn=================================================================rnrn>>> Invoking Sqoop command line now >>>rnrn4924 [main] WARN org.apache.sqoop.tool.SqoopTool - $SQOOP_CONF_DIR has not been set in the environment. Cannot check for additional configuration.rn4971 [main] INFO org.apache.sqoop.Sqoop - Running Sqoop version: 1.4.5-cdh5.3.6rn5000 [main] WARN org.apache.sqoop.tool.BaseSqoopTool - Setting your password on the command-line is insecure. Consider using -P instead.rn5025 [main] WARN org.apache.sqoop.ConnFactory - $SQOOP_CONF_DIR has not been set in the environment. Cannot check for additional configuration.rn5172 [main] INFO org.apache.sqoop.manager.MySQLManager - Preparing to use a MySQL streaming resultset.rn5180 [main] INFO org.apache.sqoop.tool.CodeGenTool - Beginning code generationrn5864 [main] INFO org.apache.sqoop.manager.SqlManager - Executing SQL statement: SELECT t.* FROM `epc_partgroup` AS t LIMIT 1rn5958 [main] INFO org.apache.sqoop.manager.SqlManager - Executing SQL statement: SELECT t.* FROM `epc_partgroup` AS t LIMIT 1rn5966 [main] INFO org.apache.sqoop.orm.CompilationManager - HADOOP_MAPRED_HOME is /opt/soft/cdh5/hadoop-2.5.0-cdh5.3.6rn13088 [main] INFO org.apache.sqoop.orm.CompilationManager - Writing jar file: /tmp/sqoop-gary/compile/7eb5d287f10f01ef33f03384f9dcf6b5/epc_partgroup.jarrn13167 [main] INFO org.apache.sqoop.tool.ImportTool - Destination directory epc_partgroup deleted.rn13167 [main] WARN org.apache.sqoop.manager.MySQLManager - It looks like you are importing from mysql.rn13168 [main] WARN org.apache.sqoop.manager.MySQLManager - This transfer can be faster! Use the --directrn13168 [main] WARN org.apache.sqoop.manager.MySQLManager - option to exercise a MySQL-specific fast path.rn13168 [main] INFO org.apache.sqoop.manager.MySQLManager - Setting zero DATETIME behavior to convertToNull (mysql)rn13172 [main] INFO org.apache.sqoop.mapreduce.ImportJobBase - Beginning import of epc_partgrouprn13225 [main] WARN org.apache.sqoop.mapreduce.JobBase - SQOOP_HOME is unset. May not be able to find all job dependencies.rn14223 [main] INFO org.apache.sqoop.mapreduce.db.DBInputFormat - Using read commited transaction isolationrnHeart beatrn48069 [main] INFO org.apache.sqoop.mapreduce.ImportJobBase - Transferred 2.6914 KB in 34.8306 seconds (79.1259 bytes/sec)rn48113 [main] INFO org.apache.sqoop.mapreduce.ImportJobBase - Retrieved 102 records.rn48220 [main] INFO org.apache.sqoop.manager.SqlManager - Executing SQL statement: SELECT t.* FROM `epc_partgroup` AS t LIMIT 1rn48323 [main] INFO org.apache.sqoop.hive.HiveImport - Loading uploaded data into HivernIntercepting System.exit(1)rnrn<<< Invocation of Main class completed <<
解决azkaban执行任务一直Running状态
1 、修改exec-server/plugins/jobtypes/commonprivate.properties文件,添加memCheck.enabled=false这一行,关闭内存检测 2 、如果还是一直Running,查看exec中的执行日志 发现虽然修改了不检测内存,但是还是在报内存不足,这时需要去看一下exec中的配置 3、修改exec-server/conf/azkaban.pro...
Oozie中Sqoop的配置及应用
Todo
图文并茂 —— 基于Oozie调度Sqoop
利用大数据来做BI分析的时候,必不可少需要设置一些调度任务。 本篇就讲述一下如何利用hue来编辑shell操作,这里面的很多操作在其他的调度操作里面也是可以借鉴的。 如果是linux里面可以直接执行的脚本,那么可以直接在hue里面使用,比如: 如果有参数,可以点击Arguments添加 如果你使用了${value}变量,那么在执行任务的时候,就需要指定value参数 点击启动时: 如果...
oozie调sqoop job报错
我创建了一个sqoop job 增量从oracle导数到hive:rnsqoop job --create stujob -- import --hive-import --connect jdbc:oracle:thin:@192.168.1.8:1521:ORCL --username SCOTT --password tiger -m 1 --table STUDENT --check-column SID --incremental append --last-value 0rnrn然后执行 bin/sqoop job --exec stujob 可以正常运行,但是在oozie里面调度就遇到以下错误rn rnController.doPrivileged(AccessController.java:310)rn at javax.security.auth.Subject.doAs(Subject.java:573)rn at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1149)rn at org.apache.hadoop.mapred.Child.main(Child.java:249)rn2098 [main] ERROR org.apache.sqoop.manager.OracleManager - Failed to list columnsrnjava.sql.SQLException: ORA-01005: null password given; logon deniedrnrn at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)rn at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:391)rn at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:383)rn at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:638)rn at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:433)rn at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:459)rn at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:193)rn at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:365)rn at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:804)rn at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:386)rn at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:535)rn at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:218)rn at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:29)rn at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528)rn at java.sql.DriverManager.getConnection(DriverManager.java:402)rn at java.sql.DriverManager.getConnection(DriverManager.java:450)rn at org.apache.sqoop.manager.OracleManager.makeConnection(OracleManager.java:310)rn at org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52)rn at org.apache.sqoop.manager.OracleManager.getColumnNames(OracleManager.java:751)rn at org.apache.sqoop.orm.ClassWriter.getColumnNames(ClassWriter.java:1207)rn at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1062)rn at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)rn at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:390)rn at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:476)rn at org.apache.sqoop.tool.JobTool.execJob(JobTool.java:228)rn at org.apache.sqoop.tool.JobTool.run(JobTool.java:283)rn at org.apache.sqoop.Sqoop.run(Sqoop.java:145)rn at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)rn at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)rn at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)rn at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)rn at org.apache.sqoop.Sqoop.main(Sqoop.java:238)rn at org.apache.oozie.action.hadoop.SqoopMain.runSqoopJob(SqoopMain.java:205)rn at org.apache.oozie.action.hadoop.SqoopMain.run(SqoopMain.java:174)rn at org.apache.oozie.action.hadoop.LauncherMain.run(LauncherMain.java:37)rn at org.apache.oozie.action.hadoop.SqoopMain.main(SqoopMain.java:47)rn at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)rn at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)rn at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)rn at java.lang.reflect.Method.invoke(Method.java:611)rn at org.apache.oozie.action.hadoop.LauncherMapper.map(LauncherMapper.java:467)rn at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:50)rn at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:435)rn at org.apache.hadoop.mapred.MapTask.run(MapTask.java:371)rn at org.apache.hadoop.mapred.Child$4.run(Child.java:255)rn at java.security.AccessController.doPrivileged(AccessController.java:310)rn at javax.security.auth.Subject.doAs(Subject.java:573)rn at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1149)rn at org.apache.hadoop.mapred.Child.main(Child.java:249)rn2100 [main] ERROR org.apache.sqoop.tool.ImportTool - Imported Failed: Attempted to generate class with no columns!rnIntercepting System.exit(1)rnrn貌似是说oozie执行时识别不了job里面的oracle的密码,但是sqoop1.4.3官方文档里有讲: rnyou have to set sqoop.metastore.client.record.password to true if you are executing saved jobs via Oozie because Sqoop cannot prompt the user to enter passwords while being executed as Oozie tasks.rn我已经设置了 sqoop.metastore.client.record.password to be truernthe sqoop-site.xml :rnrn rn rn rn rn rn rn rn rn rn rn sqoop.metastore.client.enable.autoconnectrn truern If true, Sqoop will connect to a local metastorern for job management when no other metastore arguments arern provided.rn rn rn rn rn rn rn rn rn rn rn sqoop.metastore.client.record.passwordrn truern If true, allow saved passwords in the metastore.rn rn rn rn rn rn rn rn rn sqoop.metastore.server.portrn 16000rn Port that this metastore should listen on.rn rn rnrn我把sqoop.metastore.client.record.password =true设置到workflow.xml里面也解决不了问题,哪位大侠帮忙指点一下?rn
服务器对ajax调用一直处于“正在加载”状态的问题
我遇到这样一个问题:在使用ajax(直接使用XMLHttpRequest对象,不使用任何封装后的ajax类)发送异步请求后,服务器的响应存在这样一个规律:当重启了IIS后,一切正常,而当仅重新启动了应用程序而未重启IIS时,再执行调用时,服务器就不能正确响应,在客户端取得的readyState值为1,即表示正在加载,无论等多久都这样,且越久电脑反应越迟钝。请问高手这是怎么回事?rnrn补充:服务端代码大致如下:rnContext.Response.Cache.SetCacheability(HttpCacheability.NoCache)rnResponse.ContentType = "text/plain"rnDim oldpass As String = Request.QueryString("oldpass")rnDim newpass As String = Request.QueryString("newpass")rn...rnIf ... Thenrn Response.Write("密码修改成功!")rnElsern Response.Write("数据库操作失败! 请重新登录后再试。")rnEnd IfrnResponse.Flush()rnResponse.Close()rn
gitlab-runner一直处于pending状态原因分析
项目触发runner,一直处于pending 初步怀疑是runner卡住了,也有可能是因为服务器资源不足,在服务器上执行gitlab-ci-multi-runner list发现runer还在, 在执行gitlab-ci-multi-runner verify,发现runer还活着,但是就是一直不执行流程 有两个方法解决:     1、执行gitlab-ci-multi-runner ru...
gitlab-runner一直处于挂起/pedding状态
在Docker部署GitLab后,使用持续集成提交到GitLab开始几次正常通过测试,后来发现每次都是任务排队,重启Docker也不行,后来想到gitlab是和gitlab-runner是分在两个容器中的(为了GitLab压力考虑,gitlab-runner耗性能),在runner容器里执行 gitlab-ci-multi-runner restart 进行重启runner操作,刷新GitLab...
NextCloud一直处于维护状态解决方法
更新后NextCloud一直处于维护状态,无法自动解除。 解决方法: Ubuntu 在next cloud的目录下,对着occ脚本运行 sudo -u www-data php occ maintenance:mode --off 不过有提示错误,无权修改config文件夹 其实运行这条命令主要修改的也是config/config.php,如果命令不行,直接修改该文件 把'm...
怎样使进程一直处于检测状态
例如我要到预定时间要弹出对话框,怎么使进程一直处于检测状态?
MySQL服务器一直处于正在启动状态
打开服务,MySQL状态一直都是正在启动,任务管理器进程里面没有MySQL相关进程,也没办法停掉,折磨我三四天了,正在学Java,学到JDBC,结果自己电脑一直启动不了MySQL,求问大神怎么办???[img=https://forum.csdn.net/PointForum/ui/scripts/csdn/Plugin/001/face/9.gif][/img]rnrn我的my.ini配置:rn[client]rnport=3306rndefault-character-set=utf8rn[mysqld]rnport=3306rncharacter_set_server=utf8rnbasedir=D:\mysql-5.6.25-win32rn#解压目录rndatadir=D:\mysql-5.6.25-win32\datarn#解压目录下data目录rn#sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLESrn[WinMySQLAdmin]rnD:\mysql-5.6.25-win32\bin\mysqld.exe
为什么hadoop集群一直处于安全模式状态?
每次启动hadoop集群,经过几个小时以后集群还处于安全模式rn 我已经在core-site中设置rn dfs.safemode.threshold.pct 的value 为0.800f rn还是不起作用,请问是不是我设置错了?rn 我的数据节点有三个,dfs.replication 设置为2
Ubuntu一直提示处于离线状态的解决方法
在自己的系统下安装了虚拟机,在虚拟机中安装了12.04版本的ubuntu,插上校园网的网线是显示可以上网,无论是桥接模式和NAT模式UBUNTU都显示联网状态。但是把网线拔掉之后插上连接着开发板(我用的是ARM9的开发板,Linux系统)的网线,就会显示处于离线状态,使Ubuntu的终端查询不到IP地址,导致我不能通过串口助手对开放板进行IP配置,导致我不能让开发板和Ubuntu进行ping通信。...
C# 让串口一直处于接收状态
我想让串口一直处于接收信息状态,比如持续1分钟,但是接收内容的大小未知。不知道该怎么来写,请大虾们帮帮忙,最好有个例程,谢谢!
Qtopia一直处于启动状态怎么回事?
用的是MINI2440 开机后 就一直显示Starting Qtopia ... 然后就一直是这个界面 没反应了 这怎么回事 各位大神???
系统一直处于频繁重起状态
有哪些原因会导致这个情况啊,谢谢!
kubernates删除pod一直处于terminating状态
使用命令kubectl delete pods --all --grace-period=0 –force强制删除
导入项目时AS一直处于Gradle状态
解决办法一:             查看\gradle\wrapper\gradle-wrapper.properties中gradle版本,下载对应版本压缩文件,放置到\gradle\wrapper目录下。 解决办法二:          打开一个本地一个项目下的gradle\wrapper\gradle-wrapper.properties,复制distributionUrl内容到需要
Android Studio一直处于Refreshing状态的解决方法
最近在更新AndroidStudio时,发现项目一直处于Refreshing的状态,而且项目中用的第三方API都出现报红的状态中,持续有十多分钟都一直处在刷新当中,最后发现是gradle版本不对,其他项目gradle都是2.xxx,报红的项目gradle是4.xxx,调整以后,项目恢复正常,具体如下图: 图一 图二
怎样使按钮一直处于按下状态?
想要这样一种效果:rn一个位图按钮,点击一下,即鼠标左键按下再放开,按钮一直处于按下状态,再次点击按钮,按钮弹起。
k8s-loadbalancer一直处于pending状态原因分析
现象 原因分析 service type 目前有两种,如果使用 gce 的 kubernetes,可以直接使用LoadBalancer类型,gce 会自动帮忙生成一个对外的 ip,并帮你做负载均衡 如果不是在 gce 平台,可以选择使用NodePort的类型,这样会在 node 里面添加一个对外的端口号,可以通过 nodeIP:nodePORT 来访问。可以自己搭建nginx 或者使用云服务商的...
怎么让button一直处于mousedown的状态
如题
如何让窗体一直处于非激活状态?
我做了一个类似于Office助手那样的不规则窗体(其实就是一个子窗体),根据需要每0。5秒就要改变一下外型,但是每次改变完外型后它总是处于激活状态,严重影响了主窗体(主窗体一直处于非激活状态)。我用SetActiveWindow或者是WM_ACTIVE,WM_NCACTIVE效果都不太好(主窗体0。5秒就会闪一次),我看OFFICE开启助手之后也没有出现这种情况呀,如何能实现它的那种效果呢?rn高手赐教,请尽量说的详细些,我菜,多谢了。
相关热词 c# login 居中 c# 考试软件 c# 自然语言分析 c# 分段读取文件 c# 泛型反射 c#打断点 c# 时间转多少秒 c# 线程函数加参数 c# modbus 读取 c#查询集合表