300

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

查看全部
qq_35509767
承天之重
2020/09/25 15:24
  • java
  • 点赞
  • 收藏
  • 回答
    私信

2个回复