questdb："numeric" Type NotSupported 返回
SqlSugar
沟通中
5
135
摇曳的风筝 发布于2周前
悬赏：0 飞吻
N年前用过questdb，因为服务器断电导致数据丢失，就放弃了。最近打算在新项目里面用questdb存储物联网数据，这开局就不利啊。
SqlSugarException.NotSupportedException： "numeric" Type NotSupported, DbBindProvider.GetPropertyTypeName error.
也不知道是哪个字段导致的，难道是枚举吗？
热忱回答（5）
-
摇曳的风筝 VIP0
2周前
这样写又提示：Object cannot be cast from DBNull to other types.
0 回复 -
摇曳的风筝 VIP0
2周前
这样写是可以的
0 回复 -
摇曳的风筝 VIP0
2周前
不知道为啥这样的数据在写入时返回的是0
想要实现的是已经存在的记录就不写入，不存在才写入，防止重复上传数据
[QuestDB]上传站房工况分钟数据：0 { "realtime_temp": "22.42", "realtime_humid": "30.79", "realtime_temp_outside": 607, "realtime_humid_outside": 8724, "realtime_pressure_outside": 9715, "realtime_wind": 0.0, "realtime_wind_direction": 193, "realtime_rainfall": 0.0, "std_co_pressure": 0.206, "std_so2_pressure": 0.195, "std_nox_pressure": 0.18, "in_pressure": -1.47, "in_temp": 27.3, "in_humid": 23.1, "liquid_pm25_std": null, "liquid_pm25": 16.704, "liquid_pm10_std": null, "liquid_pm10": 16.706, "liquid_out_std": 0.6, "liquid_out": 0.6, "liquid_co_std": 0.83, "liquid_co": 0.71, "liquid_so2_std": 0.74, "liquid_so2": 0.74, "liquid_o3_std": 0.53, "liquid_o3": 0.53, "liquid_nox_std": 0.43, "liquid_nox": 0.43, "voltage": "233.04,228.43,230.34", "current": "0.55,9.41,0", "total_energy": "17555.33", "total_power": "2.23", "power_hz": "50.07", "membrane_change_count": 3, "membrane_change_countall": 5, "membrane_change_temp": null, "membrane_change_humid": null, "membrane_change_liquid_std": null, "membrane_change_liquid": null, "membrane_change_pressure": null, "condensing_temperature": 400, "door_state": 0, "up_door_state": 0, "blower_state": 1, "ups_state": 0, "fire_state": 0, "light_state": 1, "water_state": 0, "water_state2": 0, "pm25_temp": 26.991, "pm10_temp": 33.14, "air_condition_settemp": 25, "air_condition_setstate": 1, "liquid_pm1": null, "liquid_noy": null, "liquid_noy_1": null, "liquid_nh3": null, "liquid_pm1_std": null, "liquid_noy_std": null, "liquid_noy_1_std": null, "liquid_nh3_std": null, "pm1_temp": null, "membrane_change_state": 0, "membrane_change_flowstate": 0, "membrane_change_quastate": 1, "LifterStatus": 0, "ClarityStatus": 1, "ClarityVal": 37.3, "Id": "2007987443227299840", "SiteMnCode": "AQS_Z_SCZDY", "SiteMnCodeName": null, "DataTime": "2026-01-05T09:28:00", "dtDataTime": "2026-01-05 09:28:00", "DataCrTime": "2026-01-05T09:28:07+08:00", "dtDataCrTime": "2026-01-05 09:28:07", "SiteProvCode": "510000000000", "SiteProvCodeName": null, "SiteCityCode": "511400000000", "SiteCityCodeName": null, "SiteCountyCode": "511403000000", "SiteCountyCodeName": null, "Flag": 0, "RecTime": "2026-01-05T09:28:07.7059312+08:00", "dtRecTime": "2026-01-05 09:28:07", "CreateTime": "2026-01-05T09:28:07.7255954+08:00", "dtCreateTime": "2026-01-05 09:28:07" }0 回复 -
decimal用默认的，datatype删掉看看
0 回复 -
摇曳的风筝 VIP0
2周前
@fate stay night：
decimal默认是用的double类型，删除了枚举对象，直接改为int类型。生成的sql如下
INSERT INTO "Rtd_AnalyzerMin1" ("device_id","device_type","Factor","Density","Density_orignal","data_checkstate","DataFlag","AuditFlag","Id","SiteMnCode","DataTime","DataCrTime","SiteProvCode","SiteCityCode","SiteCountyCode","Flag","RecTime","CreateTime") VALUES (N'SC2013',5,7,17.000,null,N'N',null,0,N'2008075128684023808',N'AQS_Z_SCZDE','2026-01-05 15:16:00.000','2026-01-05 15:16:33.000',N'510000000000',N'511300000000',N'511381000000',0,'2026-01-05 15:16:33.550','2026-01-05 15:16:33.567')但是报错提示是Object cannot be cast from DBNull to other types，语句直接执行的话又提示列不存在
0 回复
fate stay night VIP0