承天之重 2020-09-25 15:24 采纳率: 0%
浏览 130
已结题

sqoop2 的start job错误和create job的详细流程,求解

我创建的job报错了,想请大神们帮忙看看我的job哪错了,怎么改,顺便咨询下job创建流程

1、我的job
sqoop:000> show job -name job9
1 job(s) to show:
Job with name job9 (Enabled: true, Created by hadoop at 9/25/20 3:16 PM, Updated by hadoop at 9/25/20 3:16 PM)
Throttling resources
Extractors: 2
Loaders: 1
Classpath configuration
Extra mapper jars:
From link: ora1-link
From Oracle configuration
Table name: mobile_data_event_zouwt
Columns:
Consistent read:
Consistent read SCN:
Partitions:
Data chunk method:
Data chunk allocation method:
Where clause location:
Omit LOB columns: false
Query hint:
Conditions:
To link: hdfs-link
Target configuration
Override null value:
Null value:
File format: TEXT_FILE
Compression codec: NONE
Custom codec:
Output directory: /sqoop2/test1
Append mode:

2、报错
sqoop:000> start job -name job9
Exception has occurred during processing command
Exception: org.apache.sqoop.common.SqoopException Message: GENERIC_HDFS_CONNECTOR_0007:Invalid input/output directory - Unexpected exception

sqoop:000> start job -name job14
Exception has occurred during processing command
Exception: java.lang.RuntimeException Message: Could not determine columns in Oracle Table.

3、创建流程
sqoop:000> show link
+-----------+-----------------------+---------+
| Name | Connector Name | Enabled |
+-----------+-----------------------+---------+
| ora1-link | oracle-jdbc-connector | true |
| hdfs-link | hdfs-connector | true |
+-----------+-----------------------+---------+
sqoop:000> create job -f ora1-link -t hdfs-link
Creating job for links with from name ora1-link and to name hdfs-link
Please fill following values to create new job object
Name: job9

From Oracle configuration

Table name: mobile_data_event_zouwt
Columns:
There are currently 0 values in the list:
element#
Consistent read:
Consistent read SCN:
Partitions:
There are currently 0 values in the list:
element#
Data chunk method:
0 : ROWID
1 : PARTITION
Choose:
Data chunk allocation method:
0 : ROUNDROBIN
1 : SEQUENTIAL
2 : RANDOM
Choose:
Where clause location:
0 : SUBSPLIT
1 : SPLIT
Choose:
Omit LOB columns: SERV_ID,OFFER_ID4,CHARGE1,CHARGE2,CHARGE3,CHARGE4,CHARGE5,SUM_AMOUNT,DURATION
Query hint:
Conditions:

Target configuration

Override null value:
Null value:
File format:
0 : TEXT_FILE
1 : SEQUENCE_FILE
2 : PARQUET_FILE
Choose: 0
Compression codec:
0 : NONE
1 : DEFAULT
2 : DEFLATE
3 : GZIP
4 : BZIP2
5 : LZO
6 : LZ4
7 : SNAPPY
8 : CUSTOM
Choose: 0
Custom codec:
Output directory: /sqoop2/test1
Append mode:

Throttling resources

Extractors: 2
Loaders: 1

Classpath configuration

Extra mapper jars:
There are currently 0 values in the list:
element#
New job was successfully created with validation status OK and name job9

  • 写回答

2条回答 默认 最新

  • dabocaiqq 2020-09-25 16:40
    关注
    评论

报告相同问题?

悬赏问题

  • ¥30 这是哪个作者做的宝宝起名网站
  • ¥60 版本过低apk如何修改可以兼容新的安卓系统
  • ¥25 由IPR导致的DRIVER_POWER_STATE_FAILURE蓝屏
  • ¥50 有数据,怎么建立模型求影响全要素生产率的因素
  • ¥50 有数据,怎么用matlab求全要素生产率
  • ¥15 TI的insta-spin例程
  • ¥15 完成下列问题完成下列问题
  • ¥15 C#算法问题, 不知道怎么处理这个数据的转换
  • ¥15 YoloV5 第三方库的版本对照问题
  • ¥15 请完成下列相关问题!