Nandakishore created SQOOP-3137:
-----------------------------------
Summary: Sqoop not supporting Mainframe Sequential datasets,
kindly help
Key: SQOOP-3137
URL: https://issues.apache.org/jira/browse/SQOOP-3137
Project: Sqoop
Issue Type: Bug
Components: sqoop2-api, sqoop2-build, sqoop2-docs, sqoop2-framework,
sqoop2-jdbc-connector
Affects Versions: 1.4.6
Reporter: Nandakishore
I don't get information on this anywhere in net , if it is already fixed tell
me what needs to do to work ,its very urgent , 90 percent of mainframe files
are in sequentail , also kindly update in sqoop guide , so everyone will knows
this
Command Used in Hadoop:
sqoop import-mainframe --connect sysv.pershing.com --dataset
T.EBS.R100.GBKPDET3.ORTDE30 --username TSOMSUM --P --target-dir
/addh1060/nanda/TstSqop
Error (not detecting file ):
drwxr-xr-x - xbbl1wx addh1060 0 2017-01-06 04:48 addh1060/nanda/Copybook
bash-4.1$ sqoop import-mainframe --connect sysv.pershing.com --dataset
T.EBS.R100.GBKPDET3.ORTDE30 --username TSOMSUM --P --target-dir
/addh1060/nanda/TstSqop
Warning: /usr/hdp/2.4.2.0-258/accumulo does not exist! Accumulo imports will
fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
17/02/20 08:13:13 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6.2.4.2.0-258
Enter password:
17/02/20 08:14:02 INFO tool.CodeGenTool: Beginning code generation
17/02/20 08:14:02 INFO orm.CompilationManager: HADOOP_MAPRED_HOME is
/usr/hdp/2.4.2.0-258/hadoop-mapreduce
Note:
/tmp/sqoop-xbbl1wx/compile/8416e1c82ec6c0eb663fd0e48470c159/T_EBS_R100_GBKPDET3_ORTDE30.java
uses or overrides a deprecated API.
Note: Recompile with -Xlint:deprecation for details.
17/02/20 08:14:04 INFO orm.CompilationManager: Writing jar file:
/tmp/sqoop-xbbl1wx/compile/8416e1c82ec6c0eb663fd0e48470c159/T.EBS.R100.GBKPDET3.ORTDE30.jar
17/02/20 08:14:04 INFO mapreduce.ImportJobBase: Beginning import of
T.EBS.R100.GBKPDET3.ORTDE30
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in
[jar:file:/usr/hdp/2.4.2.0-258/hadoop/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in
[jar:file:/usr/hdp/2.4.2.0-258/zookeeper/lib/slf4j-log4j12-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
17/02/20 08:14:04 INFO Configuration.deprecation: mapred.jar is deprecated.
Instead, use mapreduce.job.jar
17/02/20 08:14:05 INFO Configuration.deprecation: mapred.map.tasks is
deprecated. Instead, use mapreduce.job.maps
17/02/20 08:14:05 WARN util.Jars: No such class available.
17/02/20 08:14:06 INFO impl.TimelineClientImpl: Timeline service address:
http://r37bn00.bnymellon.net:8188/ws/v1/timeline/
17/02/20 08:14:06 INFO hdfs.DFSClient: Created HDFS_DELEGATION_TOKEN token
246754 for xbbl1wx on ha-hdfs:myclustertesttpc
17/02/20 08:14:06 INFO security.TokenCache: Got dt for hdfs://myclustertesttpc;
Kind: HDFS_DELEGATION_TOKEN, Service: ha-hdfs:myclustertesttpc, Ident:
(HDFS_DELEGATION_TOKEN token 246754 for xbbl1wx)
17/02/20 08:14:06 WARN token.Token: Cannot find class for token kind kms-dt
17/02/20 08:14:06 INFO security.TokenCache: Got dt for hdfs://myclustertesttpc;
Kind: kms-dt, Service: 10.59.90.136:9292, Ident: 00 07 78 62 62 6c 31 77 78 07
64 73 68 6d 79 74 6d 00 8a 01 5a 5b a8 63 81 8a 01 5a 7f b4 e7 81 8e b8 20 1f
17/02/20 08:14:06 INFO client.ConfiguredRMFailoverProxyProvider: Failing over
to rm2
17/02/20 08:14:08 INFO mainframe.MainframeDatasetInputFormat: Datasets to
transfer from: T.EBS.R100.GBKPDET3.ORTDE30
17/02/20 08:14:08 INFO util.MainframeFTPClientUtils: Connected to
sysv.pershing.com on 21
17/02/20 08:14:08 INFO mapreduce.JobSubmitter: Cleaning up the staging area
/tmp/xbbl1wx/.staging/job_1485005128036_45849
17/02/20 08:14:08 ERROR tool.ImportTool: Encountered IOException running import
job: java.io.IOException:* Could not list datasets* from
T.EBS.R100.GBKPDET3.ORTDE30:java.io.IOException: Could not login to server
sysv.pershing.com:221 Quit command received. Goodbye.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
