code11 - Githubissues

INSERT OVERWRITE TABLE dim_event_type SELECT event_code_id, event_code, event_name, case
when event_code = 24 THEN -1.1640421408740234 WHEN event_code = 26 THEN -1.049050208102383 WHEN event_code = 11501201 THEN -0.048345853901880904 WHEN event_code = 21 THEN 1.1579424696366698 WHEN event_code = 7 THEN -0.793530405730546 WHEN event_code = 5 THEN -0.5846876491292556 ELSE fuel_event_weights END as fuel_event_weights, safety_event_weights, score_type, event_type FROM
dim_event_type;

yangfan1995 commented 4 years ago

select '1','1','闯红灯','0.0','0.0','1','1' union all select '10','190034038','高速跟车过近','0.0','0.0','1','2' union all select '11','11501201','空挡滑行','-0.048345853901880904','-0.34615385','3','2' union all select '12','11','算法预留空挡滑行','0.0','0.0','0','0' union all select '13','31','超速','0.0','-0.5','0','0' union all select '14','19003239','安全带未系','0.0','-0.15384615','1','3' union all select '15','190032395','安全带未系急加速','0.0','0.0','1','3' union all select '16','190032396','安全带未系急减速','0.0','0.0','1','3' union all select '17','190032397','安全带未系急转弯','0.0','0.0','1','3' union all select '18','10801203','带速开门','0.0','0.0','1','3' union all select '19','9','未关门起步','0.0','0.0','1','3' union all select '2','2','不按规定车道行驶','0.0','0.0','1','1' union all select '20','10','转向灯不规范','0.0','0.0','1','3' union all select '21','107','急转弯时转向灯不规范','0.0','0.0','1','3' union all select '24','19003302','接打电话','0.0','0.0','NULL','4' union all select '25','19003303','抽烟','0.0','0.0','1','4' union all select '26','19003301','疲劳驾驶','0.0','0.0','1','4' union all select '27','190033015','疲劳驾驶急加速','0.0','0.0','1','4' union all select '28','190033016','疲劳驾驶急减速','0.0','0.0','1','4' union all select '29','190033017','疲劳驾驶急转弯','0.0','0.0','1','4' union all select '3','3','实线变道','0.0','0.0','1','1' union all select '30','19003304','注意力不集中','0.0','0.0','1','4' union all select '31','190033045','注意力不集中急加速','0.0','0.0','1','4' union all select '32','190033046','注意力不集中急减速','0.0','0.0','1','4' union all select '33','190033047','注意力不集中急转弯','0.0','0.0','1','4' union all select '35','36','切实线','0.0','0.0','NULL','4' union all select '36','37','吃东西','0.0','0.0','NULL','4' union all select '37','13','低油位行驶','0.0','0.0','0','5' union all select '38','34','胎压异常行驶','0.0','0.0','0','5' union all select '39','14','等级故障报警','0.0','0.0','0','5' union all select '4','4','其他违章','0.0','0.0','1','1' union all select '40','19','经济速度','0.0','0.0','2','6' union all select '41','38','平均时速','0.0','0.0','2','6' union all select '42','10401203','超长怠速','0.0','0.0','0','0' union all select '43','26','怠速','-1.049050208102383','0.0','2','6' union all select '44','21','带档滑行','1.1579424696366698','0.0','2','6' union all select '45','20','平稳驾驶','0.0','0.0','2','6' union all select '46','39','能耗超速','0.0','0.0','2','6' union all select '47','23','空调开启','0.0','0.0','2','7' union all select '48','25','加热器使用','0.0','0.0','2','7' union all select '49','24','怠速空调','-1.1640421408740234','0.0','2','7' union all select '5','5','急加速','-0.5846876491292556','0.0','3','2' union all select '50','27','怠速加热器','0.0','0.0','2','7' union all select '51','40','日间超速','0.0','0.0','1','2' union all select '52','41','夜间超速','0.0','0.0','1','2' union all select '53','42','违反夜间禁行行驶','0.0','0.0','1','2' union all select '6','6','急减速','0.0','0.0','3','2' union all select '7','7','急转弯','-0.793530405730546','0.0','3','2' union all select '8','8','安全超速','0.0','0.0','1','2' union all select '9','19003403','跟车过近','0.0','0.0','1','2'

yangfan1995 commented 4 years ago

insert overwrite into #app_da_dim_event_type select '1','1','闯红灯','0.0','0.0','1','1' union all select '10','190034038','高速跟车过近','0.0','0.0','1','2' union all select '11','11501201','空挡滑行','-0.048345853901880904','-0.34615385','3','2' union all select '12','11','算法预留空挡滑行','0.0','0.0','0','0' union all select '13','31','超速','0.0','-0.5','0','0' union all select '14','19003239','安全带未系','0.0','-0.15384615','1','3' union all select '15','190032395','安全带未系急加速','0.0','0.0','1','3' union all select '16','190032396','安全带未系急减速','0.0','0.0','1','3' union all select '17','190032397','安全带未系急转弯','0.0','0.0','1','3' union all select '18','10801203','带速开门','0.0','0.0','1','3' union all select '19','9','未关门起步','0.0','0.0','1','3' union all select '2','2','不按规定车道行驶','0.0','0.0','1','1' union all select '20','10','转向灯不规范','0.0','0.0','1','3' union all select '21','107','急转弯时转向灯不规范','0.0','0.0','1','3' union all select '24','19003302','接打电话','0.0','0.0','NULL','4' union all select '25','19003303','抽烟','0.0','0.0','1','4' union all select '26','19003301','疲劳驾驶','0.0','0.0','1','4' union all select '27','190033015','疲劳驾驶急加速','0.0','0.0','1','4' union all select '28','190033016','疲劳驾驶急减速','0.0','0.0','1','4' union all select '29','190033017','疲劳驾驶急转弯','0.0','0.0','1','4' union all select '3','3','实线变道','0.0','0.0','1','1' union all select '30','19003304','注意力不集中','0.0','0.0','1','4' union all select '31','190033045','注意力不集中急加速','0.0','0.0','1','4' union all select '32','190033046','注意力不集中急减速','0.0','0.0','1','4' union all select '33','190033047','注意力不集中急转弯','0.0','0.0','1','4' union all select '35','36','切实线','0.0','0.0','NULL','4' union all select '36','37','吃东西','0.0','0.0','NULL','4' union all select '37','13','低油位行驶','0.0','0.0','0','5' union all select '38','34','胎压异常行驶','0.0','0.0','0','5' union all select '39','14','等级故障报警','0.0','0.0','0','5' union all select '4','4','其他违章','0.0','0.0','1','1' union all select '40','19','经济速度','0.0','0.0','2','6' union all select '41','38','平均时速','0.0','0.0','2','6' union all select '42','10401203','超长怠速','0.0','0.0','0','0' union all select '43','26','怠速','-1.049050208102383','0.0','2','6' union all select '44','21','带档滑行','1.1579424696366698','0.0','2','6' union all select '45','20','平稳驾驶','0.0','0.0','2','6' union all select '46','39','能耗超速','0.0','0.0','2','6' union all select '47','23','空调开启','0.0','0.0','2','7' union all select '48','25','加热器使用','0.0','0.0','2','7' union all select '49','24','怠速空调','-1.1640421408740234','0.0','2','7' union all select '5','5','急加速','-0.5846876491292556','0.0','3','2' union all select '50','27','怠速加热器','0.0','0.0','2','7' union all select '51','40','日间超速','0.0','0.0','1','2' union all select '52','41','夜间超速','0.0','0.0','1','2' union all select '53','42','违反夜间禁行行驶','0.0','0.0','1','2' union all select '6','6','急减速','0.0','0.0','3','2' union all select '7','7','急转弯','-0.793530405730546','0.0','3','2' union all select '8','8','安全超速','0.0','0.0','1','2' union all select '9','19003403','跟车过近','0.0','0.0','1','2'

yangfan1995 commented 4 years ago

exe_shell_app_da_GpsJourneySegmented2CalApplication

yangfan1995 commented 4 years ago

source /home/hadoop/spark-2.2.2-bin-hadoop2.7/conf/spark-env.sh

/home/hadoop/spark-2.2.2-bin-hadoop2.7/bin/spark-submit --verbose \ --class com.icongtai.zebra.db.dwd.GpsJourneySegmented2CalApplication \ --master yarn \ --deploy-mode cluster \ --num-executors "15" \ --executor-memory "5g" \ --executor-cores "2" \ --driver-memory "2g" \ --conf spark.yarn.am.waitTime=600s \ /home/hadoop/banma/driver-behavior-bigdata-source-1.0-SNAPSHOT.jar \ /ytdw/app ${yyyymm-1}

yangfan1995 commented 4 years ago

driver-behavior-bigdata-source-1.0-SNAPSHOT-11-20.zip

yangfan1995 commented 4 years ago

journey.zip

yangfan1995 commented 4 years ago

high_gps.zip

yangfan1995 commented 4 years ago

[Uploading high_gps_part1.zip…]()

yangfan1995 commented 4 years ago

[Uploading high_gps_part2.zip…]()

yangfan1995 commented 4 years ago

[Uploading high_gps_part3.zip…]()