LOAD DATA
CHARACTERSET UTF8
infile "<path of the input file>"  
INTO TABLE us_address_fabric FIELDS TERMINATED BY "\t" 
TRAILING NULLCOLS
(
pbkey,
add_number,
streetname,
unit_des,
unit_num,
city,
state,
zipcode,
plus4,
loc_code,
geoid,
lat,
lon,
parent,
prop_type,
fips
)