hi everyone,
I have a so big db2 table which contains many char type columns.[see
1.png]
I've always been tring to extract datas to hive via sqoop to fullfill
different demands.
In the past time, I try to manually trim all the char type colums when
write Hivesql[see 2.png]
There are so many colums to trim that I always forget some of them,just
like following:
suppose BANK_TABLE is the target table of hive,and 2323423232323 is an
existing card number in the table.
---------------------------------------------------------------------------------------
if I execute: hive -e "select * from BANK_TABLE where
card_no='2323423232323' "
---------------------------------------------------------------------------------------
The result is nothing owning to I forget to trim the column: card_no
when I write sql to import data to hive.
So I wonder is there a good way for sqool or for hive to do the 'trim'
automatically?
Thank you all!
Yuqing Fang
UnionPay
[email protected]
Description: Binary data
[email protected]
Description: Binary data
1.png
Description: Binary data
2.png
Description: Binary data
