I guess the following error message is inaccurate, as column car_zip is set to DEFAULT NULL...
Please correct me if I'm wrong. I don't know what the problem could be... I had misleading error messages before in loadercli. User DBA connected to database GC on local host. DATALOAD TABLE DBA.cars_used dealer_name 2 DEFAULT NULL car_city 4 DEFAULT NULL car_state 5 DEFAULT NULL car_zip 6 DEFAULT NULL user_phone 7 DEFAULT NULL car_year 9 DEFAULT NULL car_make_display 10 DEFAULT NULL car_model_display 11 DEFAULT NULL car_vin 13 DEFAULT NULL car_mileage 14 DEFAULT NULL car_price 15 DEFAULT NULL car_color_ext_display 16 DEFAULT NULL car_color_int_display 17 DEFAULT NULL car_description 20 DEFAULT NULL INFILE 'cars_used.txt' COMPRESSED ASCII SEPARATOR '|' DELIMITER '' Error during execution -->-25319 Missing data for specified column CAR_ZIP. Defined maximum number of errors (1) reached
