当mysql有这样的记录时,sqoop如何决定数据分割?

cbeh67ev  于 2021-05-29  发布在  Hadoop
关注(0)|答案(0)|浏览(160)
select * from EMP_TEST order by EMPNO asc;
+------------+-------+----------+------+-------------+------+------+--------+
| EMPNO      | ENAME | JOB      | MGR  | HIREDATE    | SAL  | COMM | DEPTNO |
+------------+-------+----------+------+-------------+------+------+--------+
| 6765423233 | WARD  | SALESMAN | 7698 | 22-FEB-1981 | 1250 |  500 |     30 |
| 6767891234 | WARD  | SALESMAN | 7698 | 22-FEB-1981 | 1250 |  500 |     30 |
| 6767891236 | WARD  | SALESMAN | 7698 | 22-FEB-1981 | 1250 |  500 |     30 |
| 7767891234 | WARD  | SALESMAN | 7698 | 22-FEB-1981 | 1250 |  500 |     30 |
| 8767891230 | WARD  | SALESMAN | 7698 | 22-FEB-1981 | 1250 |  500 |     30 |
| 8767891233 | WARD  | SALESMAN | 7698 | 22-FEB-1981 | 1250 |  500 |     30 |
| 9765423233 | WARD  | SALESMAN | 7698 | 22-FEB-1981 | 1250 |  500 |     30 |
| 9767891234 | WARD  | SALESMAN | 7698 | 22-FEB-1981 | 1250 |  500 |     30 |

在我的例子中,如果我参考下面的例子,如何计算分割*
例如:假设:min=0,max=400,no\u of\u mappers=4 split\u size=(400–0)/4=100
所以,拆分:[0100],[100200],[200300],[300400]

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题