hdfs dfs -mkdir -p /external/sr/sr_created
hdfs dfs -mkdir -p /external/sr/sr_assign
hdfs dfs -mkdir -p /external/sr/sr_cancelled
hdfs dfs -mkdir -p /external/sr/sr_handle
hdfs dfs -mkdir -p /external/sr/sr_received
hdfs dfs -put sr_created.txt /external/sr/sr_created/
hdfs dfs -put sr_assign.txt /external/sr/sr_assign/
hdfs dfs -put sr_cancelled.txt /external/sr/sr_cancelled/
hdfs dfs -put sr_handle.txt /external/sr/sr_handle/
hdfs dfs -put sr_received.txt /external/sr/sr_received/
create external table sr_created(
ticket_id string,
phone string,
event_time string
)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' location '/external/sc/sr_created';
create external table sr_assgin(
ticket_id string,
phone string,
event_time string
)
ROW FORMAT DELIMITED FIELDS TERMINATED BY
hdfs dfs -mkdir -p /external/sr/sr_assign
hdfs dfs -mkdir -p /external/sr/sr_cancelled
hdfs dfs -mkdir -p /external/sr/sr_handle
hdfs dfs -mkdir -p /external/sr/sr_received
hdfs dfs -put sr_created.txt /external/sr/sr_created/
hdfs dfs -put sr_assign.txt /external/sr/sr_assign/
hdfs dfs -put sr_cancelled.txt /external/sr/sr_cancelled/
hdfs dfs -put sr_handle.txt /external/sr/sr_handle/
hdfs dfs -put sr_received.txt /external/sr/sr_received/
create external table sr_created(
ticket_id string,
phone string,
event_time string
)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' location '/external/sc/sr_created';
create external table sr_assgin(
ticket_id string,
phone string,
event_time string
)
ROW FORMAT DELIMITED FIELDS TERMINATED BY