menu
TSP Testbed
home
Home
database
Data
labs
Tests
history
History
Sidebar
Edit test
Name
com.github.housepower.jdbc.ClickHouseDriver
com.github.housepower.jdbc.ClickHouseDriver
Source
com.github.housepower.jdbc.ClickHouseDriver
com.github.housepower.jdbc.ClickHouseDriver
Sink
SELECT ts, equipment_id AS equipment_id, InPAirBrakeLine, InPAirBrakeCylinder1Bog, OutTrainContactor4, TExGasCylinder2Left, TExGasCylinder3Right, TWaterOutDiesel, InPFuelTNVD, TOilInDiesel, InCurrentExcitationGenerator, OutRelayFieldWeakStage1, InCurrentBattery, InTrainContactor6, InSpeedWp6, InTrainContactor2, TExGasCylinder1Right, InSwitchMotorOM5, TExGasCylinder3Left, InTurnReverseBack, InLockControl, TColdJump, OutRelayFieldWeakStage2, InRelayFieldWeakStage1, OutContactorOilPump, InRadiatorLoverRight1, InTrainContactor3, InCurrentArmTED1, InSwitchMotorOM4, SpeedEngine, TExGasCylinder5Right, OutContactorDieselStart_1, InPFuelFineFuelFilter, TExGasCylinder2Right, TExGasCylinder7Right, OutTrainContactor1, InSwitchMotorOM2, TExGasTurbineRight, InSpeedWp5, PowerMeasured, TExGasCylinder5Left, TExGasTurbineLeft, OutContactorDieselStart_2, TExGasCylinder1Left, InTrainContactor4, InSwitchMotorOM6, InSpeedWp2, OutTrainContactor5, InSwitchMotorOM3, Pboost, InCurrentArmTED2, TExGasCylinder6Right, OutTrainContactor3, InSpeedWp1, InCurrentArmTED3, InRadiatorLoverLeft2, InRadiatorLoverRight2, TExGasCylinder4Right, InPAirBrakeCylinder2Bog, TOilOutDiesel, InTurnReverseForward, InRelayFieldWeakStage2, TExGasCylinder8Right, POilDiselIn, PosKM, InRadiatorLoverLeft1, InButtonEmergencyDieselStopCab1, InSwitchMotorOM1, TExGasCylinder7Left, InTrainContactor1, CurrentDistribution, OutTrainContactor6, InTrainContactor5, InSpeedWp4, InUStarterGenerator, OutTrainContactor2, TExGasCylinder6Left, InCurrentArmTED6, Speed, InCurrentArmTED5, InGroundRelay, TExGasCylinder4Left, InPOilFineFilter, TExGasCylinder8Left, InCurrentArmTED4, InSpeedWp3 , upload_id FROM telemetry_2te25km_tmy_2024_wide WHERE equipment_id IN (9208) AND ts >= 1739823840.0 AND ts <= 1739823899.0 ORDER BY ts ASC
Query
00:15:00
Chunk Size (milliseconds)
00:01:00
Telemetry data gap (milliseconds)
00:00:02
Incidents gap (milliseconds)
add_circle
Add New Pattern
Pattern ID
Source Code
2525
add_circle
edit
delete
Patterns
Incidents
add_circle
Add New Incident
Pattern ID
From
To
2525
17.02.2025 20:24:20
17.02.2025 20:24:58
add_circle
edit
delete
save
Save