drop table if exists nation;
create external table nation (N_NATIONKEY INT,
 N_NAME text,
 N_REGIONKEY INT,
 N_COMMENT text)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' STORED AS TEXTFILE
LOCATION