一、问题
版本：
cdh6.2.0
kylin3.0.0
构建cube第一阶段Create Intermediate Flat Hive，报错 FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask
日志：
java.io.IOException: OS command error exit with return code: 2, error message: WARNING: Use "yarn jar" to launch YARN applications.
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/opt/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/jars/log4j-slf4j-impl-2.8.2.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/opt/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/jars/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
Logging initialized using configuration in jar:file:/opt/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/jars/hive-common-2.1.1-cdh6.2.0.jar!/hive-log4j2.properties Async: false
OK
Time taken: 2.194 seconds
OK
Time taken: 0.079 seconds
OK
Time taken: 0.515 seconds
OK
Time taken: 0.211 seconds
Query ID = hdfs_20210302060042_3d1bd329-6238-4341-b537-22bf96edfcdd
Total jobs = 1
SLF4J: Class path contains multiple SLF4J bindings.SLF4J: Found binding in [jar:file:/opt/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/jars/log4j-slf4j-impl-2.8.2.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/opt/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/jars/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]2021-03-02 06:01:00 Starting to launch local task to process map join; maximum memory = 7635730432
Execution failed with exit status: 2
Obtaining error information
Task failed!
Task ID:
Stage-10
Logs:
/tmp/hdfs/hive.log
FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask
The command is:
hive -e "set mapred.job.name='Create Intermediate Flat Hive Table';
USE default;
DROP TABLE IF EXISTS kylin_intermediate_cube_ho_kpi_20210113_b56967df_3513_0a13_c04e_662881158dbb;
CREATE EXTERNAL TABLE IF NOT EXISTS kylin_intermediate_cube_ho_kpi_20210113_b56967df_3513_0a13_c04e_662881158dbb
(
\`VIEW_CUBE_HO_KPI_20210113_FLIGHT_ID\` bigint
,\`VIEW_CUBE_HO_KPI_20210113_FLIGHT_DATE\` date
,\`VIEW_CUBE_HO_KPI_20210113_AIR_LINE\` string
,\`VIEW_CUBE_HO_KPI_20210113_DEPARTURE_4_CODE\` string
,\`VIEW_CUBE_HO_KPI_20210113_ARRIVAL_4_CODE\` string
,\`VIEW_CUBE_HO_KPI_20210113_FLIGHT_NUMBER\` string
,\`VIEW_CUBE_HO_KPI_20210113_PLANE_TYPE\` string
,\`VIEW_CUBE_HO_KPI_20210113_CAPTAIN\` string
,\`VIEW_CUBE_HO_KPI_20210113_ENGINES1\` string
,\`VIEW_CUBE_HO_KPI_20210113_FLIGHT_TYPE\` string
,\`VIEW_CUBE_HO_KPI_20210113_FLIGHT_PROPERTY\` string
,\`VIEW_CUBE_HO_KPI_20210113_FLIGHT_STATUS\` string
,\`VIEW_CUBE_HO_KPI_20210113_FLG_STATE\` string
,\`VIEW_CUBE_HO_KPI_20210113_MAX_DEPART_WEIGHT\` int
,\`VIEW_CUBE_HO_KPI_20210113_SEAT_NUM\` int
,\`VIEW_CUBE_HO_KPI_20210113_PLANE_NUMBER\` string
,\`VIEW_CUBE_HO_KPI_20210113_ACQUIS_DATE\` string
,\`VIEW_CUBE_HO_KPI_20210113_BASE\` string
,\`VIEW_CUBE_HO_KPI_20210113_FILIALE\` string
,\`VIEW_CUBE_HO_KPI_20210113_CLOUD_LEVEL\` int
,\`VIEW_CUBE_HO_KPI_20210113_VIS\` double
,\`VIEW_CUBE_HO_KPI_20210113_WEATHER\` string
,\`VIEW_CUBE_HO_KPI_20210113_DISPATCH\` string
,\`VIEW_CUBE_HO_KPI_20210113_KPI_RED\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_CI_STATUS\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_REDISPATCH\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_WHETHER_CDA\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_TAKEOFFRUNWAYID\` string
,\`VIEW_CUBE_HO_KPI_20210113_KPI_LANDINGRUNWAYID\` string
,\`VIEW_CUBE_HO_KPI_20210113_KPI_IS_DELAY\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_WHETHERTHEHOVER\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_DATA_FLIGHT_SUCCESS_EOTI\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_DATA_FLIGHT_SUCCESS_REVT\` double
,\`VIEW_CUBE_HO_KPI_20210113_ACTUAL_DEPARTURE_TIME\` bigint
,\`VIEW_CUBE_HO_KPI_20210113_ACTUAL_ARRIVAL_TIME\` bigint
,\`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_TRIP_TIME\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_TRIP_DIST\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_PL\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_PL\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_CI\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_TOTAL_FUEL\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_TAXI_OUT_FUEL_CONSUMPTION\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_TRIP_FUEL_CONSUMPTION\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_PBCF\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_HOLD_FUEL\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_ALTN_FUEL1\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_ALTN_FUEL2\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_APM\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_DNC\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_INCE\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_FUEL_PERHOUR\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_AVG_FL\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_AVG_ALT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_RED_DIST\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_RED_FUEL_SAVE\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_RED_RATE\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_CI_RATE\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_CI_ACHIEVING_B\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_FLT_ASMT_TIME\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_TAXI_OUT_FOB\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_TAKEOFF_FOB\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_LANDING_FOB\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_TAXI_IN_FOB\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_TAXI_OUT_FUEL_CONSUMPTION\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_TRIP_FUEL_CONSUMPTION\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_BLOCK_FUEL_CONSUMPTION\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_TAXI_OUT_TIME\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_TRIP_TIME\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_TRIP_FUEL_DEVIATION\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_TRIP_DIST\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_FUEL_PERHOUR\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_FLT_SPD\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_FUEL_PER_KM\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_FOC_TOTAL_FUEL\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_LANDING_FOB\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_BLOCK_TIME\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_EXTRA_FUEL\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_ARRI_FUEL_BIAS\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_RESERVE_FUEL_USAGE\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_CREW_EXTRA_FUEL\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_AVG_ALT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_AVG_FL\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_CRUISE_TIME\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_ALTN_DIST1\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_ALTN_DIST2\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_TAKE_OFF_WEIGHT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_LANDING_WEIGHT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_TAKE_OFF_WEIGHT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_LANDING_WEIGHT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_FUEL_FIXED_PL\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_FTK_FIXED_PL\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_FUEL_PER_FTK_FIXED_PL\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_FLT_FUEL_SAVE\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_FUEL_PRICE\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_RED_FUEL_SAVE_BOUNTY\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_ALT_ACHIEVING_A\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_CDA_FUEL_SAVE\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_CDA_FUEL_SAVE_BOUNTY\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_EOTI_FUEL_SAVE\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_EOTI_FUEL_SAVE_BOUNTY\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_REVT_FUEL_SAVE\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_REVT_FUEL_SAVE_BOUNTY\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_ON_TIME_C\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_APM\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_CI_COUNT_EXECUTE\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_CI_COUNT_TOTAL\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_CI\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_CREW_EXTRA_FUEL\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_DISP_EXTRA_FUEL\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_ALT_LANDING_GEAR_UP\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_ALT_ACHIEVING_RATE\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_AIRGCDIS\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_BLOCK_FUEL_PERHOUR\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_ALT_FLAPS_RETRACTION_START_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_ALT_TAKEOFF_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_DURATION_CRUISE_PLAN\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_ALT_LANDING_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_HIGH_DURATION_CLIMB_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_HIGH_FUEL_CON_CLIMB_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_HIGH_DURATION_CRUISE_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_HIGH_FUEL_CON_CRUISE_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_FUEL_CON_CRUISE_FUEL_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_CRUISE_FUEL_CONSUMPTION\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_ALT_LANDING_GEAR_DOWN_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_ALT_TAKEOFF_PLAN\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_ALT_LANDING_PLAN\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_HIGH_DURATION_DESCENT_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_HIGH_FUEL_CON_TAXI_OUT_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_SPD_TAKEOFF\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_SPD_LANDING_GEAR_UP\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_HIGH_FUEL_CON_DESCENT_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_HIGH_DURATION_SID_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_SPD_LANDING\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_HIGH_DURATION_STAR_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_HIGH_FUEL_CON_STAR_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_HIGH_FUEL_CON_SID_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_WEIGHT_TAXI_OUT_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_WEIGHT_TOTAL_PLAN\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_DIST_CRUISE_PLAN\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_DIST_SID_PLAN\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_DIST_STAR_PLAN\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_DIST_ROUTE_PLAN\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_TEMP_PUSH_OUT_OAT_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_TEMP_PUSH_OUT_TAT_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_TEMP_TAT_TAXI_IN_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_TEMP_OAT_TAXI_IN_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_WIND_TAKEOFF_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_WIND_LANDING_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_DIST_TAXI_OUT_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_DIST_SID_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_DIST_STAR_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_HIGH_DIST_SID_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_HIGH_DIST_CLIMB_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_HIGH_DIST_CRUISE_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_HIGH_DIST_DESCENT_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_HIGH_DIST_STAR_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_RATE_ROUTE_BEND\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_FUEL_PER_DIST_PLAN\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_HIGH_DURATION_TRIP_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_HIGH_DIST_TRIP_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_HIGH_PL_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_CL_FUEL_CONSUMPTION\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_DEC_FUEL_CONSUMPTION\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_FUEL_ALARM_RATING\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_TAXI_IN_TIME\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_TAXI_IN_FUEL_CONSUMPTION\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_FLIGHT_ID\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_DURATION_SLIP_RUN_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_DURATION_CLIMB_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_ALT_FLAPS_RELEASE_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_SPD_FLAPS_RETRACTION_START\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_SPD_FLAPS_RELEASE\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_DURATION_CLIMB_PLAN\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_DURATION_DESCENT_PLAN\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_ALT_TOC_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_ALT_TOD_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_FUEL_CON_CLIMB_FUEL_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_FUEL_CON_DESCENT_FUEL_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_ALT_TOC_PLAN\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_ALT_TOD_PLAN\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_SPD_LANDING_GEAR_DOWN\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_DIST_DEPT_BIAS_PLAN\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_DIST_ARRI_BIAS_PLAN\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_DIST_CLIMB_PLAN\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_DIST_DESCENT_PLAN\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_DURATION_DESCENT_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_DURATION_STAR_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_FUEL_CON_SID_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_FUEL_CON_STAR_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_DURATION_SID_PLAN\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_DURATION_STAR_PLAN\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_FUEL_CON_SID_PLAN\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_FUEL_CON_STAR_PLAN\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_DURATION_SID_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_DIST_TAKEOFF_RUN_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_DIST_CLIMB_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_DIST_CRUISE_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_DIST_DESCENT_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_DIST_TAXI_IN_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_DURATION_TAKEOFF_RUN_ACT\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_NWS_WHEEL_ANG_M_ZERO\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_NWS_WHEEL_ANG_C_ZERO\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_NWS_WHEEL_ANG_OFFSET\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_IDGINTM_AFTER_60_NUM\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_IDGINTM_MAX\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_IDGINTM_IDGOUTM_OFFSET_MAX\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_IDGINTM_IDGOUTM_OFFSET_MIN\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_AVI_IN_V_OPEN_CLOSE_DURATION\` double
,\`VIEW_CUBE_HO_KPI_20210113_KPI_AVI_EXT_V_OPEN_CLOSE_DURATION\` double
)
STORED AS SEQUENCEFILE
LOCATION 'hdfs://Aero/kylin/kylin_metadata/kylin-2c069c71-0bbf-ae23-722d-f819f968c85a/kylin_intermediate_cube_ho_kpi_20210113_b56967df_3513_0a13_c04e_662881158dbb';
ALTER TABLE kylin_intermediate_cube_ho_kpi_20210113_b56967df_3513_0a13_c04e_662881158dbb SET TBLPROPERTIES('auto.purge'='true');
INSERT OVERWRITE TABLE \`kylin_intermediate_cube_ho_kpi_20210113_b56967df_3513_0a13_c04e_662881158dbb\` SELECT
\`VIEW_CUBE_HO_KPI_20210113\`.\`FLIGHT_ID\` as \`VIEW_CUBE_HO_KPI_20210113_FLIGHT_ID\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`FLIGHT_DATE\` as \`VIEW_CUBE_HO_KPI_20210113_FLIGHT_DATE\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`AIR_LINE\` as \`VIEW_CUBE_HO_KPI_20210113_AIR_LINE\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`DEPARTURE_4_CODE\` as \`VIEW_CUBE_HO_KPI_20210113_DEPARTURE_4_CODE\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`ARRIVAL_4_CODE\` as \`VIEW_CUBE_HO_KPI_20210113_ARRIVAL_4_CODE\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`FLIGHT_NUMBER\` as \`VIEW_CUBE_HO_KPI_20210113_FLIGHT_NUMBER\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`PLANE_TYPE\` as \`VIEW_CUBE_HO_KPI_20210113_PLANE_TYPE\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`CAPTAIN\` as \`VIEW_CUBE_HO_KPI_20210113_CAPTAIN\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`ENGINES1\` as \`VIEW_CUBE_HO_KPI_20210113_ENGINES1\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`FLIGHT_TYPE\` as \`VIEW_CUBE_HO_KPI_20210113_FLIGHT_TYPE\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`FLIGHT_PROPERTY\` as \`VIEW_CUBE_HO_KPI_20210113_FLIGHT_PROPERTY\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`FLIGHT_STATUS\` as \`VIEW_CUBE_HO_KPI_20210113_FLIGHT_STATUS\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`FLG_STATE\` as \`VIEW_CUBE_HO_KPI_20210113_FLG_STATE\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`MAX_DEPART_WEIGHT\` as \`VIEW_CUBE_HO_KPI_20210113_MAX_DEPART_WEIGHT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`SEAT_NUM\` as \`VIEW_CUBE_HO_KPI_20210113_SEAT_NUM\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`PLANE_NUMBER\` as \`VIEW_CUBE_HO_KPI_20210113_PLANE_NUMBER\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`ACQUIS_DATE\` as \`VIEW_CUBE_HO_KPI_20210113_ACQUIS_DATE\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`BASE\` as \`VIEW_CUBE_HO_KPI_20210113_BASE\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`FILIALE\` as \`VIEW_CUBE_HO_KPI_20210113_FILIALE\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`CLOUD_LEVEL\` as \`VIEW_CUBE_HO_KPI_20210113_CLOUD_LEVEL\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`VIS\` as \`VIEW_CUBE_HO_KPI_20210113_VIS\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`WEATHER\` as \`VIEW_CUBE_HO_KPI_20210113_WEATHER\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`DISPATCH\` as \`VIEW_CUBE_HO_KPI_20210113_DISPATCH\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_RED\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_RED\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_CI_STATUS\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_CI_STATUS\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_REDISPATCH\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_REDISPATCH\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_WHETHER_CDA\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_WHETHER_CDA\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_TAKEOFFRUNWAYID\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_TAKEOFFRUNWAYID\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_LANDINGRUNWAYID\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_LANDINGRUNWAYID\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_IS_DELAY\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_IS_DELAY\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_WHETHERTHEHOVER\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_WHETHERTHEHOVER\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_DATA_FLIGHT_SUCCESS_EOTI\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_DATA_FLIGHT_SUCCESS_EOTI\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_DATA_FLIGHT_SUCCESS_REVT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_DATA_FLIGHT_SUCCESS_REVT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`ACTUAL_DEPARTURE_TIME\` as \`VIEW_CUBE_HO_KPI_20210113_ACTUAL_DEPARTURE_TIME\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`ACTUAL_ARRIVAL_TIME\` as \`VIEW_CUBE_HO_KPI_20210113_ACTUAL_ARRIVAL_TIME\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_PLAN_TRIP_TIME\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_TRIP_TIME\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_PLAN_TRIP_DIST\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_TRIP_DIST\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_PLAN_PL\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_PL\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_ACT_PL\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_PL\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_PLAN_CI\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_CI\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_PLAN_TOTAL_FUEL\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_TOTAL_FUEL\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_PLAN_TAXI_OUT_FUEL_CONSUMPTION\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_TAXI_OUT_FUEL_CONSUMPTION\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_PLAN_TRIP_FUEL_CONSUMPTION\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_TRIP_FUEL_CONSUMPTION\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_PLAN_PBCF\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_PBCF\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_PLAN_HOLD_FUEL\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_HOLD_FUEL\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_PLAN_ALTN_FUEL1\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_ALTN_FUEL1\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_PLAN_ALTN_FUEL2\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_ALTN_FUEL2\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_PLAN_APM\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_APM\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_PLAN_DNC\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_DNC\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_PLAN_INCE\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_INCE\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_PLAN_FUEL_PERHOUR\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_FUEL_PERHOUR\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_PLAN_AVG_FL\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_AVG_FL\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_PLAN_AVG_ALT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_AVG_ALT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_RED_DIST\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_RED_DIST\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_RED_FUEL_SAVE\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_RED_FUEL_SAVE\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_RED_RATE\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_RED_RATE\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_CI_RATE\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_CI_RATE\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_CI_ACHIEVING_B\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_CI_ACHIEVING_B\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_FLT_ASMT_TIME\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_FLT_ASMT_TIME\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_ACT_TAXI_OUT_FOB\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_TAXI_OUT_FOB\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_ACT_TAKEOFF_FOB\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_TAKEOFF_FOB\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_ACT_LANDING_FOB\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_LANDING_FOB\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_ACT_TAXI_IN_FOB\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_TAXI_IN_FOB\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_ACT_TAXI_OUT_FUEL_CONSUMPTION\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_TAXI_OUT_FUEL_CONSUMPTION\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_ACT_TRIP_FUEL_CONSUMPTION\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_TRIP_FUEL_CONSUMPTION\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_ACT_BLOCK_FUEL_CONSUMPTION\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_BLOCK_FUEL_CONSUMPTION\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_ACT_TAXI_OUT_TIME\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_TAXI_OUT_TIME\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_ACT_TRIP_TIME\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_TRIP_TIME\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_TRIP_FUEL_DEVIATION\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_TRIP_FUEL_DEVIATION\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_ACT_TRIP_DIST\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_TRIP_DIST\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_ACT_FUEL_PERHOUR\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_FUEL_PERHOUR\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_ACT_FLT_SPD\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_FLT_SPD\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_PLAN_FUEL_PER_KM\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_FUEL_PER_KM\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_FOC_TOTAL_FUEL\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_FOC_TOTAL_FUEL\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_PLAN_LANDING_FOB\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_LANDING_FOB\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_ACT_BLOCK_TIME\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_BLOCK_TIME\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_PLAN_EXTRA_FUEL\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_EXTRA_FUEL\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_PLAN_ARRI_FUEL_BIAS\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_ARRI_FUEL_BIAS\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_RESERVE_FUEL_USAGE\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_RESERVE_FUEL_USAGE\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_CREW_EXTRA_FUEL\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_CREW_EXTRA_FUEL\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_ACT_AVG_ALT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_AVG_ALT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_ACT_AVG_FL\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_AVG_FL\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_ACT_CRUISE_TIME\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_CRUISE_TIME\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_PLAN_ALTN_DIST1\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_ALTN_DIST1\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_PLAN_ALTN_DIST2\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_ALTN_DIST2\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_PLAN_TAKE_OFF_WEIGHT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_TAKE_OFF_WEIGHT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_PLAN_LANDING_WEIGHT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_LANDING_WEIGHT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_ACT_TAKE_OFF_WEIGHT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_TAKE_OFF_WEIGHT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_ACT_LANDING_WEIGHT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_LANDING_WEIGHT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_FUEL_FIXED_PL\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_FUEL_FIXED_PL\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_FTK_FIXED_PL\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_FTK_FIXED_PL\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_FUEL_PER_FTK_FIXED_PL\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_FUEL_PER_FTK_FIXED_PL\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_FLT_FUEL_SAVE\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_FLT_FUEL_SAVE\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_FUEL_PRICE\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_FUEL_PRICE\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_RED_FUEL_SAVE_BOUNTY\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_RED_FUEL_SAVE_BOUNTY\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_ALT_ACHIEVING_A\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_ALT_ACHIEVING_A\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_CDA_FUEL_SAVE\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_CDA_FUEL_SAVE\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_CDA_FUEL_SAVE_BOUNTY\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_CDA_FUEL_SAVE_BOUNTY\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_EOTI_FUEL_SAVE\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_EOTI_FUEL_SAVE\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_EOTI_FUEL_SAVE_BOUNTY\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_EOTI_FUEL_SAVE_BOUNTY\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_REVT_FUEL_SAVE\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_REVT_FUEL_SAVE\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_REVT_FUEL_SAVE_BOUNTY\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_REVT_FUEL_SAVE_BOUNTY\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_ON_TIME_C\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_ON_TIME_C\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_ACT_APM\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_APM\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_CI_COUNT_EXECUTE\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_CI_COUNT_EXECUTE\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_CI_COUNT_TOTAL\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_CI_COUNT_TOTAL\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_ACT_CI\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_CI\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_PLAN_CREW_EXTRA_FUEL\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_CREW_EXTRA_FUEL\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_PLAN_DISP_EXTRA_FUEL\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_DISP_EXTRA_FUEL\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_ALT_LANDING_GEAR_UP\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_ALT_LANDING_GEAR_UP\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_ALT_ACHIEVING_RATE\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_ALT_ACHIEVING_RATE\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_AIRGCDIS\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_AIRGCDIS\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_ACT_BLOCK_FUEL_PERHOUR\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_BLOCK_FUEL_PERHOUR\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_ALT_FLAPS_RETRACTION_START_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_ALT_FLAPS_RETRACTION_START_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_ALT_TAKEOFF_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_ALT_TAKEOFF_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_DURATION_CRUISE_PLAN\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_DURATION_CRUISE_PLAN\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_ALT_LANDING_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_ALT_LANDING_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_STAT_HIGH_DURATION_CLIMB_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_HIGH_DURATION_CLIMB_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_STAT_HIGH_FUEL_CON_CLIMB_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_HIGH_FUEL_CON_CLIMB_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_STAT_HIGH_DURATION_CRUISE_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_HIGH_DURATION_CRUISE_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_STAT_HIGH_FUEL_CON_CRUISE_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_HIGH_FUEL_CON_CRUISE_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_FUEL_CON_CRUISE_FUEL_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_FUEL_CON_CRUISE_FUEL_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_PLAN_CRUISE_FUEL_CONSUMPTION\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_CRUISE_FUEL_CONSUMPTION\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_ALT_LANDING_GEAR_DOWN_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_ALT_LANDING_GEAR_DOWN_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_ALT_TAKEOFF_PLAN\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_ALT_TAKEOFF_PLAN\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_ALT_LANDING_PLAN\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_ALT_LANDING_PLAN\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_STAT_HIGH_DURATION_DESCENT_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_HIGH_DURATION_DESCENT_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_STAT_HIGH_FUEL_CON_TAXI_OUT_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_HIGH_FUEL_CON_TAXI_OUT_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_SPD_TAKEOFF\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_SPD_TAKEOFF\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_SPD_LANDING_GEAR_UP\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_SPD_LANDING_GEAR_UP\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_STAT_HIGH_FUEL_CON_DESCENT_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_HIGH_FUEL_CON_DESCENT_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_STAT_HIGH_DURATION_SID_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_HIGH_DURATION_SID_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_SPD_LANDING\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_SPD_LANDING\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_STAT_HIGH_DURATION_STAR_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_HIGH_DURATION_STAR_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_STAT_HIGH_FUEL_CON_STAR_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_HIGH_FUEL_CON_STAR_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_STAT_HIGH_FUEL_CON_SID_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_HIGH_FUEL_CON_SID_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_WEIGHT_TAXI_OUT_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_WEIGHT_TAXI_OUT_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_WEIGHT_TOTAL_PLAN\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_WEIGHT_TOTAL_PLAN\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_DIST_CRUISE_PLAN\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_DIST_CRUISE_PLAN\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_DIST_SID_PLAN\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_DIST_SID_PLAN\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_DIST_STAR_PLAN\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_DIST_STAR_PLAN\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_DIST_ROUTE_PLAN\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_DIST_ROUTE_PLAN\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_TEMP_PUSH_OUT_OAT_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_TEMP_PUSH_OUT_OAT_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_TEMP_PUSH_OUT_TAT_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_TEMP_PUSH_OUT_TAT_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_TEMP_TAT_TAXI_IN_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_TEMP_TAT_TAXI_IN_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_TEMP_OAT_TAXI_IN_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_TEMP_OAT_TAXI_IN_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_WIND_TAKEOFF_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_WIND_TAKEOFF_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_WIND_LANDING_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_WIND_LANDING_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_DIST_TAXI_OUT_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_DIST_TAXI_OUT_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_DIST_SID_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_DIST_SID_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_DIST_STAR_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_DIST_STAR_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_STAT_HIGH_DIST_SID_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_HIGH_DIST_SID_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_STAT_HIGH_DIST_CLIMB_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_HIGH_DIST_CLIMB_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_STAT_HIGH_DIST_CRUISE_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_HIGH_DIST_CRUISE_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_STAT_HIGH_DIST_DESCENT_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_HIGH_DIST_DESCENT_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_STAT_HIGH_DIST_STAR_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_HIGH_DIST_STAR_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_STAT_RATE_ROUTE_BEND\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_RATE_ROUTE_BEND\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_STAT_FUEL_PER_DIST_PLAN\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_FUEL_PER_DIST_PLAN\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_STAT_HIGH_DURATION_TRIP_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_HIGH_DURATION_TRIP_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_STAT_HIGH_DIST_TRIP_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_HIGH_DIST_TRIP_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_STAT_HIGH_PL_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_STAT_HIGH_PL_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_PLAN_CL_FUEL_CONSUMPTION\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_CL_FUEL_CONSUMPTION\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_PLAN_DEC_FUEL_CONSUMPTION\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_PLAN_DEC_FUEL_CONSUMPTION\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_FUEL_ALARM_RATING\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_FUEL_ALARM_RATING\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_ACT_TAXI_IN_TIME\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_TAXI_IN_TIME\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_ACT_TAXI_IN_FUEL_CONSUMPTION\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_ACT_TAXI_IN_FUEL_CONSUMPTION\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_FLIGHT_ID\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_FLIGHT_ID\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_DURATION_SLIP_RUN_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_DURATION_SLIP_RUN_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_DURATION_CLIMB_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_DURATION_CLIMB_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_ALT_FLAPS_RELEASE_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_ALT_FLAPS_RELEASE_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_SPD_FLAPS_RETRACTION_START\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_SPD_FLAPS_RETRACTION_START\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_SPD_FLAPS_RELEASE\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_SPD_FLAPS_RELEASE\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_DURATION_CLIMB_PLAN\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_DURATION_CLIMB_PLAN\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_DURATION_DESCENT_PLAN\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_DURATION_DESCENT_PLAN\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_ALT_TOC_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_ALT_TOC_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_ALT_TOD_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_ALT_TOD_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_FUEL_CON_CLIMB_FUEL_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_FUEL_CON_CLIMB_FUEL_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_FUEL_CON_DESCENT_FUEL_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_FUEL_CON_DESCENT_FUEL_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_ALT_TOC_PLAN\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_ALT_TOC_PLAN\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_ALT_TOD_PLAN\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_ALT_TOD_PLAN\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_SPD_LANDING_GEAR_DOWN\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_SPD_LANDING_GEAR_DOWN\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_DIST_DEPT_BIAS_PLAN\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_DIST_DEPT_BIAS_PLAN\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_DIST_ARRI_BIAS_PLAN\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_DIST_ARRI_BIAS_PLAN\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_DIST_CLIMB_PLAN\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_DIST_CLIMB_PLAN\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_DIST_DESCENT_PLAN\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_DIST_DESCENT_PLAN\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_DURATION_DESCENT_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_DURATION_DESCENT_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_DURATION_STAR_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_DURATION_STAR_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_FUEL_CON_SID_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_FUEL_CON_SID_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_FUEL_CON_STAR_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_FUEL_CON_STAR_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_DURATION_SID_PLAN\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_DURATION_SID_PLAN\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_DURATION_STAR_PLAN\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_DURATION_STAR_PLAN\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_FUEL_CON_SID_PLAN\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_FUEL_CON_SID_PLAN\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_FUEL_CON_STAR_PLAN\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_FUEL_CON_STAR_PLAN\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_DURATION_SID_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_DURATION_SID_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_DIST_TAKEOFF_RUN_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_DIST_TAKEOFF_RUN_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_DIST_CLIMB_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_DIST_CLIMB_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_DIST_CRUISE_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_DIST_CRUISE_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_DIST_DESCENT_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_DIST_DESCENT_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_DIST_TAXI_IN_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_DIST_TAXI_IN_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_DURATION_TAKEOFF_RUN_ACT\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_DURATION_TAKEOFF_RUN_ACT\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_NWS_WHEEL_ANG_M_ZERO\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_NWS_WHEEL_ANG_M_ZERO\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_NWS_WHEEL_ANG_C_ZERO\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_NWS_WHEEL_ANG_C_ZERO\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_NWS_WHEEL_ANG_OFFSET\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_NWS_WHEEL_ANG_OFFSET\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_IDGINTM_AFTER_60_NUM\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_IDGINTM_AFTER_60_NUM\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_IDGINTM_MAX\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_IDGINTM_MAX\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_IDGINTM_IDGOUTM_OFFSET_MAX\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_IDGINTM_IDGOUTM_OFFSET_MAX\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_IDGINTM_IDGOUTM_OFFSET_MIN\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_IDGINTM_IDGOUTM_OFFSET_MIN\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_AVI_IN_V_OPEN_CLOSE_DURATION\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_AVI_IN_V_OPEN_CLOSE_DURATION\`
,\`VIEW_CUBE_HO_KPI_20210113\`.\`KPI_AVI_EXT_V_OPEN_CLOSE_DURATION\` as \`VIEW_CUBE_HO_KPI_20210113_KPI_AVI_EXT_V_OPEN_CLOSE_DURATION\`
FROM \`AERO_HO\`.\`VIEW_CUBE_HO_KPI_20210113\` as \`VIEW_CUBE_HO_KPI_20210113\`
WHERE 1=1 AND (\`VIEW_CUBE_HO_KPI_20210113\`.\`FLIGHT_DATE\` >= '2021-03-01' AND \`VIEW_CUBE_HO_KPI_20210113\`.\`FLIGHT_DATE\` < '2021-03-02')
;
" --hiveconf hive.merge.mapredfiles=false --hiveconf hive.auto.convert.join=true --hiveconf dfs.replication=2 --hiveconf hive.exec.compress.output=true --hiveconf hive.auto.convert.join.noconditionaltask=true --hiveconf mapreduce.job.split.metainfo.maxsize=-1 --hiveconf hive.merge.mapfiles=false --hiveconf hive.auto.convert.join.noconditionaltask.size=100000000 --hiveconf hive.stats.autogather=true
at org.apache.kylin.common.util.CliCommandExecutor.execute(CliCommandExecutor.java:96)
at org.apache.kylin.source.hive.CreateFlatHiveTableStep.createFlatHiveTable(CreateFlatHiveTableStep.java:59)
at org.apache.kylin.source.hive.CreateFlatHiveTableStep.doWork(CreateFlatHiveTableStep.java:97)
at org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:179)
at org.apache.kylin.job.execution.DefaultChainedExecutable.doWork(DefaultChainedExecutable.java:71)
at org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:179)
at org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRunner.run(DefaultScheduler.java:114)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:748)
二、解决
从日志看有点像之前遇到的一个mapjoin的问题：
https://blog.csdn.net/qq_39945938/article/details/113369256
之前在hive中已经关闭了mapjoin，仔细看日志发现–hiveconf hive.auto.convert.join=true，mapjoin还是开启的
虽然在hive里设置为关闭了，但在job级别任然是开启的
需要修改kylin的hivejob配置文件把hive.auto.convert.join设置为true
编辑
$KYLIN_HOME/conf/kylin_hive_conf.xml
改为如下
重新build即可成功
扫一扫
1245
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
