sqoop import --connect jdbc:mysql://ip/数据库 --username root --password 密码 --query "select p.bidNo as bidNo,p.interestTime as interestTime,p.status as status,p.planStatus as planStatus,

i.yield as yield,

i.startDate as startDate,

i.endDate as endDate,

i.cycle as cycle,

i.financedAmount as financedAmount,

e.interestType as interestType,

a.penaltyAmount as penaltyAmount,

(

case

when

(select count(1) from zx_standard_plan pp where pp.interestTime < p.interestTime and pp.bidNo = p.bidNo order by pp.interestTime desc limit 1) > 0

then (select TO_DAYS(date(from_unixtime(p.interestTime)))-TO_DAYS(date(from_unixtime((select pp.interestTime from zx_standard_plan pp where pp.interestTime < p.interestTime and pp.bidNo = p.bidNo order by pp.interestTime desc limit 1)))))

else (select TO_DAYS(date(from_unixtime(p.interestTime)))-TO_DAYS(date(from_unixtime(i.startDate))))

end) as days

from

zx_standard_plan p

left join zx_standard_informations i

on p.bidNo = i.bidNo

left join zx_standard_extra e

on e.bidNo = p.bidNo

left join zx_advance_repay a

on a.bidNo = p.bidNo

where

p.planStatus <> 'VOID' and

i.bidType <> 'GREEN' and

i.bidStatus <> 'FINISHED' and

\$CONDITIONS

order by p.interestTime asc" -m 1 --target-dir /zhongxin/standardPlanStatistics