Posts

Showing posts from October, 2020

hive sqoop increment

create database ccdm_mstr; use ccdm_mstr; create table clm_cvs_fact( clm_cvs_fact_ket varchar(30), dw_cret_aud_key int(25), dw_updt_aud_key int(30)); insert into clm_cvs_fact (clm_cvs_fact_ket, dw_cret_aud_key, dw_updt_aud_key) values ('123456700','12347771', '12347771'); insert into clm_cvs_fact (clm_cvs_fact_ket, dw_cret_aud_key, dw_updt_aud_key) values ('123456701','12347772', '12347772');  select * from clm_cvs_fact;    output: +------------------+-----------------+-----------------+ | clm_cvs_fact_ket | dw_cret_aud_key | dw_updt_aud_key | +------------------+-----------------+-----------------+ | 123456700        |        12347771 | 12347771        | | 123456701        |        12347772 | 12347772        | +------------------+-----------------+-----------------+ [cloudera@quickstart ~]$ sqoop import --connect jdbc:mysql://localhost/ccdm_mstr --usern...