May 20, 2019, 03:31 PM
stur0063Trace Results
Detail:
SET TRACEUSER = ON
SET TRACEOFF = ALL
SET TRACEON = SQLAGGR//CLIENT
SET TRACEON = STMTRACE//CLIENT
SET TRACEON = STMTRACE/2/CLIENT
SET TRACESTAMP = OFF
SET XRETRIEVAL = OFF
JOIN
INNER TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.VEHICLE_DIMENSION IN
telogis_trip_fact TO UNIQUE TELOGIS_VEHICLE.TELOGIS_VEHICLE.ID
IN telogis_vehicle TAG J0 AS J0
END
JOIN
INNER TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.DRIVER_DIMENSION IN telogis_trip_fact
TO UNIQUE TELOGIS_DRIVER.TELOGIS_DRIVER.ID IN telogis_driver TAG J1 AS J1
END
DEFINE FILE TELOGIS_TRIP_FACT
filterDate/YYMD=HDATE(TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.START_TIME_UTC, 'YYMD');
myTime/D12.2=HTIME(10, TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.START_TIME_UTC, 'D12.2');
driverName/A256V=J1.TELOGIS_DRIVER.FIRST_NAME | ' ' | J1.TELOGIS_DRIVER.LAST_NAME ;
tripCounter/I5 = IF TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.DEPARTURE_TIME_UNIT_TZ IS MISSING THEN tripCounter ELSE tripCounter+1;
END
TABLE FILE TELOGIS_TRIP_FACT
PRINT
J0.TELOGIS_VEHICLE.NAME AS 'Vehicle'
driverName AS 'Driver'
J1.TELOGIS_DRIVER.NAME AS 'Driver 2'
TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.START_TIME_UTC/MDY AS 'Date'
TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.START_TIME_UTC/HHIA AS 'Depart Time'
TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.END_TIME AS 'End Time Raw'
TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.END_TIME/HHIA AS 'End Time'
TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.IGNITION_ON_TIME_UNIT_TZ
TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.DEPARTURE_TIME_UNIT_TZ
tripCounter
TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.IGNITION_OFF_TIME_UNIT_TZ
TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.ARRIVAL_TIME_UNIT_TZ
TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.ARRIVAL_TIME_UNIT_TZ/HHIA AS 'Arrival Time'
TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.ENGINE_TIME
TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.TOTAL_DISTANCE
TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.TRIP_DURATION
TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.END_ODO
TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.PREIDLE_DURATION
TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.POSTIDLE_DURATION
BY TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.START_TIME_UTC NOPRINT
WHERE TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.DRIVER_DIMENSION EQ 54810602259;
WHERE filterDate EQ '20190516';
WHERE myTime NE '.00';
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
-INCLUDE _EDAHOME/ETC/warm.sty
$ Copyright 1996-2015 Information Builders, Inc. All rights reserved.
-* $Revision: 1.33 $
*TABLE_STYLE
TYPE=REPORT,
GRID=OFF,
FONT='IBIDefault',
SIZE=9,
STYLE=NORMAL,
SQUEEZE=ON,
COLOR=RGB(20 20 20),
PAGECOLOR='WHITE',
BORDER-COLOR=RGB(219 219 219),
TITLELINE=SKIP,
HYPERLINK-COLOR=RGB(51 102 255),
$
TYPE=REPORT,GRAPHCOLOR='SILVER',GRAPHCOLORNEG='RED',GRAPHWIDTH=.18,$
TYPE=REPORT,
OBJECT=MENU,
SIZE=9,
COLOR=RGB(#6B6B6B),
BACKCOLOR=RGB(#F8F8F8),
HOVER-COLOR=RGB(#495263),
HOVER-BACKCOLOR=RGB(#DFDFDF),
$
TYPE=DATA,
TOPGAP=0.05,
BOTTOMGAP=0.05,
BORDER-TOP=LIGHT,
BORDER-TOP-COLOR=RGB(219 219 219),
BORDER-BOTTOM=LIGHT,
BORDER-BOTTOM-COLOR=RGB(219 219 219),
$
TYPE=TITLE,
STYLE=-UNDERLINE + BOLD,
BORDER-BOTTOM=LIGHT,
BORDER-BOTTOM-COLOR=RGB(219 219 219),
$
TYPE=DATA,
COLUMN=ROWTOTAL(*),
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=ROWTOTAL(*),
STYLE=-UNDERLINE +BOLD,
$
TYPE=TABHEADING,
SIZE=14,
JUSTIFY=LEFT,
STYLE=BOLD,
COLOR=RGB(75 75 75),
$
TYPE=TABFOOTING,
SIZE=10,
COLOR=RGB(75 75 75),
$
TYPE=HEADING,
JUSTIFY=LEFT,
SIZE=12,
STYLE=BOLD,
COLOR=RGB(75 75 75),
$
TYPE=FOOTING,
SIZE=10,
COLOR=RGB(75 75 75),
$
TYPE=SUBHEAD,
BACKCOLOR=RGB(246 246 246),
BORDER-TOP=LIGHT,
BORDER-TOP-COLOR=RGB(219 219 219),
$
TYPE=SUBHEAD,
BY=1,
BORDER-TOP=LIGHT,
BORDER-TOP-COLOR=RGB(102 102 102),
$
TYPE=SUBHEAD,
OBJECT=FIELD,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=9,
BORDER-TOP=LIGHT,
BORDER-TOP-COLOR=RGB(219 219 219),
$
TYPE=SUBFOOT,
OBJECT=FIELD,
STYLE=BOLD,
$
TYPE=SUBTOTAL,
STYLE=BOLD,
BORDER-TOP=LIGHT,
BORDER-TOP-COLOR=RGB(219 219 219),
$
TYPE=ACROSSVALUE,
BACKCOLOR='NONE',
STYLE=NORMAL,
JUSTIFY=CENTER,
$
TYPE=ACROSSTITLE,
ACROSSTITLE=SIDE,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
STYLE=BOLD,
BORDER-TOP=LIGHT,
BORDER-TOP-COLOR=RGB(102 102 102),
$
-*ACTIVE Specific
TYPE=REPORT,OBJECT=CURRENT-ROW,HOVER-BACKCOLOR=rgb(243 243 243), BACKCOLOR=rgb(215 215 215),$
TYPE=REPORT, CALC-LOCATION=TOP, $
TYPE=REPORT, ARICONSET=BLUE, ARSTYLESET=bipib,$
TYPE=REPORT, OBJECT=CALC-AREA, COLOR=RGB(0 0 0), $
TYPE=REPORT, OBJECT=STATUS-AREA, COLOR=RGB(51 51 51), BACKCOLOR=RGB(255 255 255), JUSTIFY=LEFT, PAGE-LOCATION=BOTTOM,$
TYPE=REPORT,ARGRAPHENGINE=JSCHART,$
*GRAPH_SCRIPT
setFillColor(getSeries(0),new Color(#5388be));
setFillColor(getSeries(1),new Color(#9ed675));
setFillColor(getSeries(2),new Color(#4fa03d));
setFillColor(getSeries(3),new Color(#fcce58));
setFillColor(getSeries(4),new Color(#e1542b));
setFillColor(getSeries(5),new Color(#efcca2));
setSeriesLooping(6);
setColorMode(4);
setAutoColorLerpFactor(0.8);
setTransparentBorderColor(getChartBackground(),true);
setTransparentBorderColor(getSeries(*), true);
setTransparentBorderColor(getFrame(),true);
setTransparentBorderColor(getSeries(0),true);
setTransparentBorderColor(getSeries(1),true);
setTransparentBorderColor(getSeries(2),true);
setTransparentBorderColor(getSeries(3),true);
setTransparentBorderColor(getSeries(4),true);
setTransparentBorderColor(getSeries(5),true);
setTransparentBorderColor(getSeries(6),true);
setTransparentBorderColor(getSeries(7),true);
setTransparentBorderColor(getSeries(8),true);
setTransparentBorderColor(getSeries(9),true);
setTransparentBorderColor(getSeries(10),true);
setTransparentBorderColor(getSeries(11),true);
setTransparentBorderColor(getSeries(12),true);
setTransparentBorderColor(getSeries(13),true);
setTransparentBorderColor(getSeries(14),true);
setTransparentBorderColor(getSeries(15),true);
setTransparentBorderColor(getSeries(16),true);
setTransparentBorderColor(getSeries(17),true);
setX1MajorTickDisplay (true);
setTickLength (getX1MajorTick(), 200);
setBorderColor(getX1MajorTick(),new Color(192,192,192));
setTickStyle(getX1MajorTick(),3);
setLegendPosition(2);
setSmoothLines(false);
setFillColor(getO1Label(),new Color(128,128,128));
setDisplay(getO1MajorGrid(),false);
setBorderColor(getO1MajorGrid(),new Color(128,128,128));
setFillColor(getO1MajorGrid(),new Color(128,128,128));
setAltFmtFrameNumColors(getO1AltFmtFrame(),5);
setFontName(getO1Title(),"IBIDefault");
setFontSizeAbsolute(getO1Title(), true);
setFontSizeInPoints(getO1Title(), 10);
setPlaceResize(getO1Title(), 0);
setFillColor(getO1Title(),new Color(128,128,128));
setTickLength (getY1MajorTick(), 200);
setBorderColor(getY1AxisLine(),new Color(192,192,192));
setFillColor(getY1AxisLine(),new Color(192,192,192));
setLineWidth(getY1AxisLine(),1);
setDisplay(getY1ZeroLine(),true);
setBorderColor(getY1ZeroLine(),new Color(192,192,192));
setLineWidth(getY1ZeroLine(),1);
setFillColor(getY1Label(),new Color(128,128,128));
setBorderColor(getY1MajorGrid(),new Color(128,128,128));
setFillColor(getY1MajorGrid(),new Color(128,128,128));
setAltFmtFrameNumColors(getY1AltFmtFrame(),5);
setScaleMustIncludeZero(getY1Axis(),true);
setFontSizeAbsolute(getY1Title(), true);
setFontSizeInPoints(getY1Title(), 10);
setPlaceResize(getY1Title(), 0);
setFillColor(getY1Title(),new Color(128,128,128));
setFontName(getY1Title(),"IBIDefault");
setFontName(getY1Label(),"IBIDefault");
setFontSizeAbsolute(getY1Label(), true);
setFontSizeInPoints(getY1Label(), 9);
setPlaceResize(getY1Label(), 0);
setBorderColor(getY1MajorTick(),new Color(192,192,192));
setDisplay(getY1MajorTick(),true);
setTickStyle(getY1MajorTick(),3);
setDisplay(getY1MajorGrid(),false);
setFontName(getX1Title(),"IBIDefault");
setFontSizeAbsolute(getX1Title(), true);
setFontSizeInPoints(getX1Title(), 10);
setPlaceResize(getX1Title(), 0);
setFillColor(getX1Title(),new Color(128,128,128));
setTickLength (getY2MajorTick(), 200);
setBorderColor(getY2AxisLine(),new Color(88,88,88));
setFillColor(getY2AxisLine(),new Color(88,88,88));
setLineWidth(getY2AxisLine(),1);
setDisplay(getY2ZeroLine(),true);
setBorderColor(getY2ZeroLine(),new Color(88,88,88));
setLineWidth(getY2ZeroLine(),1);
setFillColor(getY2Label(),new Color(64,64,64));
setBorderColor(getY2MajorGrid(),new Color(64,64,64));
setFillColor(getY2MajorGrid(),new Color(64,64,64));
setAltFmtFrameNumColors(getY2AltFmtFrame(),5);
setScaleMustIncludeZero(getY2Axis(),true);
setFontSizeAbsolute(getY2Title(), true);
setFontSizeInPoints(getY2Title(), 10);
setPlaceResize(getY2Title(), 0);
setFillColor(getY2Title(),new Color(64,64,64));
setFontName(getY2Title(),"IBIDefault");
setFontName(getY2Label(),"IBIDefault");
setFontSizeAbsolute(getY2Label(), true);
setFontSizeInPoints(getY2Label(), 9);
setPlaceResize(getY2Label(), 0);
setBorderColor(getY2MajorTick(),new Color(88,88,88));
setDisplay(getY2MajorTick(),true);
setTickStyle(getY2MajorTick(),3);
setDisplay(getY2MajorGrid(),false);
setFontName(getX1Title(),"IBIDefault");
setFontSizeAbsolute(getX1Title(), true);
setFontSizeInPoints(getX1Title(), 10);
setPlaceResize(getX1Title(), 0);
setFillColor(getX1Title(),new Color(128,128,128));
setFontName(getO1Label(),"IBIDefault");
setFontSizeAbsolute(getO1Label(), true);
setFontSizeInPoints(getO1Label(), 9);
setPlaceResize(getO1Label(), 0);
setFontName(getLegendText(),"IBIDefault");
setFillColor(getLegendText(),new Color(80,80,80));
setSquareMarkers(true);
setUseSeriesShapes(true);
setMarkerShape(getSeries(*),0);
setPieFeelerTextDisplay(0);
setFontName(getPieRingLabel(),"IBIDefault");
setFontSizeAbsolute(getPieRingLabel(),true);
setAutofit(getPieRingLabel(),false);
setFontSizeInPoints(getPieRingLabel(),28);
setPlaceResize(getPieRingLabel(),0);
setDisplay(getX1MajorGrid(),false);
setBorderColor(getO1AxisLine(),new Color(192,192,192));
setLineWidth(getO1AxisLine(),1);
setBorderColor(getX1AxisLine(),new Color(192,192,192));
setLineWidth(getX1AxisLine(),1);
setScaleMustIncludeZero(getX1Axis(),true);
setBorderColor(getO1MajorTick(),new Color(192,192,192));
setDisplay(getO1MajorTick(),false);
setTickStyle(getO1MajorTick(),3);
setTransparentFillColor(getFrame(),true);
setPieRingSize(64);
setDisplay(getQuadrantLine(),false);
setFillColor(getX1Label(),new Color(128,128,128));
setFontName(getX1Label(),"IBIDefault");
setFontSizeAbsolute(getX1Label(), true);
setFontSizeInPoints(getX1Label(), 9);
setPlaceResize(getX1Label(), 0);
setPlaceTruncateCount(getLegendText(), 15);
setZeroValueDataTextDisplay(false);
*GRAPH_JS
"fill": {
"color": "transparent"
},
"border": {
"width": 1,
"color": "transparent",
"dash": ""
},
"blaProperties": {
"areaFillEffect": "70%",
"barGroupGapWidth": "0.4"
},
"bubbleMarker": {
"maxSize": "11%"
},
"pieProperties": {
"holeSize": 0,
"totalLabel": {
"visible": "auto",
"font": "10pt Sans-Serif",
"color": "#505050"
}
},
"gaugeProperties": {
"totalLabel": {
"color": "#505050"
},
"secondaryRingFillColor": "#e5e5e5",
"startAngle": 270,
"endAngle": 270,
"axisWidth": "25%",
"outerBorder": {
"fill": {
"color": "transparent"
},
"width": "6%"
}
},
"series": [
{
"series": "all",
"dataLabels": {
"visible": "auto",
"font": "7.5pt Sans-Serif",
"color": "auto"
},
"color": null,
"border": {
"width": 3
},
"marker": {
"visible": false,
"size": 10,
"border": {
"width": 2
},
"shape": "circle",
"fillEffect": "seriesAuto"
}
},
{
"series": 0,
"color": "#5388be"
},
{
"series": 1,
"color": "#9ed675"
},
{
"series": 2,
"color": "#4fa03d"
},
{
"series": 3,
"color": "#FCCE58"
},
{
"series": 4,
"color": "#e1542b"
},
{
"series": 5,
"color": "#efcca2"
}
],
"legend": {
"visible": "auto",
"lineStyle": {
"width": 1,
"color": "transparent"
},
"title": {
"visible": false,
"font": "10pt Sans-Serif",
"color": "#505050"
},
"labels": {
"font": "7.5pt Sans-Serif",
"color": "#505050"
},
"shadow": false,
"position": "auto",
"backgroundcolor": "transparent",
"scroll": {
"enabled": true,
"handle": {
"color": "#D1D1D1",
"hoverColor": "#B3B3B3"
}
},
"dock": {
"enabled": true,
"button": {
"color": "#D1D1D1",
"hoverColor": "#B3B3B3"
}
}
},
"colorScale": {
"title": {
"text": "",
"visible": true
},
"colors": [
"#D73027",
"#FDAE61",
"#FFFFBF",
"#A6D96A",
"#1A9850"
],
"labels": {
"visible": true,
"font": "7.5pt Sans-Serif",
"color": "#505050"
},
"majorGrid": {
"visible": true,
"aboveRisers": true,
"lineStyle": {
"width": 1,
"color": "rgba(255, 255, 255, 0.3)"
},
"ticks": {
"length": 5,
"visible": false,
"style": "outer",
"lineStyle": {
"width": 1,
"color": "#BABABA"
}
}
}
},
"xaxis": {
"mustIncludeZero": true,
"title": {
"visible": true,
"font": "10pt Sans-Serif",
"color": "#505050"
},
"labels": {
"visible": true,
"font": "9pt Sans-Serif",
"color": "#505050",
"excludeMin": false,
"nestingConcatSymbol": " : ",
"rotation": null
},
"labelLayout": {
"stagger": false,
"skip": "auto",
"scroll": "auto",
"truncate": "auto"
},
"bodyLineStyle": {
"width": 1,
"color": "#BABABA",
"dash": ""
},
"baseLineStyle": {
"width": 1,
"color": "#BABABA",
"dash": ""
},
"majorGrid": {
"visible": false,
"aboveRisers": false,
"lineStyle": {
"width": 1,
"color": "#EEEEEE",
"dash": ""
},
"ticks": {
"length": 5,
"visible": false,
"style": "inner",
"lineStyle": {
"width": 1,
"color": "#BABABA"
}
}
},
"minorGrid": {
"visible": false,
"count": null,
"lineStyle": {
"width": 1,
"color": "#EEEEEE",
"dash": ""
},
"ticks": {
"length": 5,
"visible": false,
"style": "inner",
"lineStyle": {
"width": 1,
"color": "#BABABA"
}
}
}
},
"yaxis": {
"mustIncludeZero": true,
"title": {
"visible": true,
"font": "10pt Sans-Serif",
"color": "#505050"
},
"labels": {
"visible": true,
"font": "9pt Sans-Serif",
"color": "#505050",
"excludeMin": false,
"rotation": null
},
"bodyLineStyle": {
"width": 1,
"color": "#BABABA",
"dash": ""
},
"baseLineStyle": {
"width": 1,
"color": "#BABABA",
"dash": ""
},
"minorGrid": {
"visible": false,
"count": null,
"lineStyle": {
"width": 1,
"color": "#EEEEEE",
"dash": ""
},
"ticks": {
"length": 5,
"style": "outer",
"visible": false,
"lineStyle": {
"width": 1,
"color": "#BABABA"
}
}
},
"majorGrid": {
"visible": false,
"aboveRisers": false,
"lineStyle": {
"width": 1,
"color": "#EEEEEE",
"dash": ""
},
"ticks": {
"length": 5,
"visible": true,
"style": "outer",
"lineStyle": {
"width": 1,
"color": "#BABABA"
}
}
}
},
"y2axis": {
"mustIncludeZero": true,
"title": {
"visible": true,
"font": "10pt Sans-Serif",
"color": "#505050"
},
"labels": {
"visible": true,
"font": "9pt Sans-Serif",
"color": "#505050",
"excludeMin": false,
"rotation": null
},
"bodyLineStyle": {
"width": 1,
"color": "#BABABA",
"dash": ""
},
"baseLineStyle": {
"width": 1,
"color": "#BABABA",
"dash": ""
},
"minorGrid": {
"visible": false,
"count": null,
"lineStyle": {
"width": 1,
"color": "#EEEEEE",
"dash": ""
},
"ticks": {
"length": 5,
"style": "outer",
"visible": false,
"lineStyle": {
"width": 1,
"color": "#BABABA"
}
}
},
"majorGrid": {
"visible": false,
"aboveRisers": false,
"lineStyle": {
"width": 1,
"color": "#EEEEEE",
"dash": ""
},
"ticks": {
"length": 5,
"visible": true,
"style": "outer",
"lineStyle": {
"width": 1,
"color": "#BABABA"
}
}
}
},
"zaxis": {
"title": {
"text": "",
"visible": true,
"font": "10pt Sans-Serif",
"color": "#505050"
},
"labels": {
"visible": true,
"font": "9pt Sans-Serif",
"color": "#505050",
"excludeMin": false,
"excludeMax": "auto",
"rotation": null
},
"majorGrid": {
"visible": false,
"ticks": {
"visible": false
}
}
},
"mouseOverIndicator": {
"color": "transparent",
"border": {
"width": 2,
"color": "#303030"
},
"marker": {
"color": "rgba(255, 255, 0, 0.88)",
"size": 8,
"shape": "circle",
"rotation": 0,
"position": "top",
"border": {
"width": 0,
"color": "rgba(26, 26, 26, 0.9)",
"dash": ""
}
}
},
"matrixProperties": {
"rowLabels": {
"color": "#505050",
"font": "8pt Sans-Serif"
},
"colLabels": {
"color": "#505050",
"font": "8pt Sans-Serif"
},
"rowHeader": {
"color": "#505050",
"font": "10pt Sans-Serif"
},
"colHeader": {
"color": "#505050",
"font": "10pt Sans-Serif"
},
"cellBorder": {
"width": 1,
"color": "#AAAAAA"
}
},
"dataSelection": {
"unselectedColor": "85%",
"selectionRect": {
"fill": "rgba(120, 120, 180, 0.45)",
"border": {
"width": 1,
"color": "rgba(120, 120, 205, 0.8)"
}
}
},
"tagcloudProperties": {
"engine": "new",
"font": "14pt Sans-serif"
},
"morphAnimation": {
"duration": 1000
},
"dataGridProperties": {
"colHeader": {
"sorting": {
"enabled": true
},
"resize": {
"enabled": true
}
}
},
"riserCycleEndLightness": 0.8,
"riserBevel": "none",
"showNullGroups": false,
"narrativeText": {
"label": {
"font": "11pt Arial",
"color": "#000000",
"align": "left"
},
"backgroundColor": "#FFFFFF",
"border": {
"width": 0,
"color": "#000000",
"dash": ""
}
},
"extensions": {
"com.esri.map": {
"baseLayer": {
"basemap": "gray"
}
}
}
*END
$
ENDSTYLE
END
FOC2565 - THE OBJECT OF IF/WHERE CANNOT BE CONVERTED TO SQL
FOC2566 - DEFINE myTime CANNOT BE CONVERTED TO SQL
FOC2567 - FUNCTION HTIME CANNOT BE CONVERTED TO SQL
FOC2590 - AGGREGATION NOT DONE FOR THE FOLLOWING REASON:
FOC2594 - AGGREGATION IS NOT APPLICABLE TO THE VERB USED
SELECT
T1."abs_count",
T1."arrival_time_unit_tz",
T1."departure_time_unit_tz",
T1."driver_dimension",
T1."end_odo",
T1."end_time",
T1."engine_time",
T1."ignition_off_time_unit_tz",
T1."ignition_on_time_unit_tz",
T1."postidle_duration",
T1."preidle_duration",
T1."start_time_utc",
T1."total_distance",
T1."trip_duration",
T1."vehicle_dimension",
T2."name",
T3."first_name",
T3."last_name",
T3."name"
FROM
zonesf31d.trip_fact T1,
zonesf31d.vehicle T2,
zonesf31d.driver T3
WHERE
(T2."id" = T1."vehicle_dimension") AND
(T3."id" = T1."driver_dimension") AND
(DATE_TRUNC('DAY',CAST(T1."start_time_utc" AS TIMESTAMP)) =
DATE '2019-05-16') AND
(T1."driver_dimension" = 54810602259)
ORDER BY
T1."start_time_utc";
0 NUMBER OF RECORDS IN TABLE= 0 LINES= 0