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, LockRefrigerator, SwitchMotorOM2, Ground, CurrentArmTED4, Fuse5VUU, TOilOutDiesel, Pfact, TWaterInDiesel, Pboost, SpeedWp1, OutTrainContactor4, OutTrainContactor1, SwitchMotorFun3, TWaterInIntercooler, UTPVoltagePosOnboard, ConnectionSUD, PAirMainRes, PWaterOutDiesel, PowerPolling, CurrentArmTED2, SwitchMotorOM1, OutContactorExcitationGenerator, SpeedTurbocharger, ContactorLockKUDK, LockDoorsVUU, SpeedWp5, OutTrainContactor6, CurrentArmTED6, VoltageRectOf4BranchRect, FuelConsumptionCurr, OutTrainContactor5, GroundRelay, VoltageRectOf2BranchRect, PowerPreset, CurrentBattery, POilPumpOut, VoltageRectOf3BranchRect, TOilInDiesel, AngleOpenThyristors4RectBranch, SwitchMotorFun2, SwitchMotorOM3, SpeedWp3, CurrentExcitationGenerator, AngleOpenThyristors3RectBranch, CurrentArmTED5, RestrictionTractive1, UTPPermissionExcitationExcit, CurrentCompressorMotor, OutTrainContactor2, OutTrainContactor7, LockDoorsHighVoltage, RestrictionLoadSUD, SwitchMovementSection1, PosKM, CurrentExcitation, POilInCarter, TAirInTurbocharger, TAirInEngine, AngleOpenThyristors5RectBranch, LockSelfExcitation, Fuse3VUU, SpeedWp6, Speed, SwitchMotorFun4, Fuse4VUU, SwitchMotorFun1, SwitchMotorOM5, Fuse1VUU, SensorBrakeRelease, CurrentArmTED3, UTPPermissionExcitationTG, ToggleSandSupply, PFuelTNVD, Boxing, VoltageRectOf5BranchRect, ConstraintSuperchargeERD, SwitchMotorOM4, AngleOpenThyristors1RectBranch, PAirTurbocharger, VoltageTGRect, AngleOpenThyristors2RectBranch, SpeedWp4, Fuse2VUU, TWaterOutDiesel, ContactorExcitationGenerator, VoltageRectOf6BranchRect, TExGasTurbineRight, CurrentArmTED1, AngleOpenThyristors6RectBranch, SpeedEngine, ContactorLockKDK, UTPVoltageNegOnboard, ConnectionUTP, SwitchMotorOM6, SpeedWp2, FuelConsumptionMax, VoltageBattery, Fuse6VUU, ContactorExcitation, VolnageTGPreset, TWaterInChargeAirCooler, TExGasTurbineLeft, TAirOut, OutTrainContactor3, VoltageRectOf1BranchRect, PAirOut, SwitchMovementSection2 , upload_id FROM telemetry_2te116ud_20220323__wide WHERE equipment_id IN (20823) AND ts >= 1738691506.0 AND ts <= 1738691654.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
1240
add_circle
edit
delete
Patterns
Incidents
add_circle
Add New Incident
Pattern ID
From
To
1240
04.02.2025 17:51:46
04.02.2025 17:54:14
add_circle
edit
delete
save
Save