Hi, you were not passing domain in the column list. Could you please try the below Sqoop command? Please let me know if you have any issues.
bin/sqoop export --connect jdbc:mysql://192.168.100.23:3303/IA \ --username "root" \ --password "password" \ --table "ALL_TYPES" \ --columns "bankcard,sex,HTTPStateCode,boolean,domain,ip,array,map,idcard, phone,email,post,date,uniform_date,int,double,string" \ --export-dir "/tmp/ALL_TYPES2.csv" \ -m 1 On Wed, Dec 27, 2017 at 11:36 AM, Ajana Chandiruthil Sathian < [email protected]> wrote: > Actually it is a misalignment, the values for the domain is in ip and > values for ip is in array. Did you see that? > > On Wed, Dec 27, 2017 at 11:32 AM, Ajana Chandiruthil Sathian < > [email protected]> wrote: > >> Yes, this is what I was asking. I just noticed that the column domain >> also null >> >> On Wed, Dec 27, 2017 at 2:26 AM, feng wang <[email protected]> >> wrote: >> >>> Did you mean this command? >>> >>> [image: 内嵌图片 1] >>> >>> 2017-12-27 14:43 GMT+08:00 Ajana Chandiruthil Sathian <[email protected] >>> >: >>> >>>> Okay! Can I see the screenshot of the describe tablename command ? >>>> >>> >>> >> >
