流数据表中UUID字段怎么写入

流数据表定义如下：

t_completed_event_partition_table = table(10:1,`customer_code`company_id`device_code`device_name`event_code`event_name`event_reason`process_strategy`event_level`identify_person`generate_time`release_time`alert_result,[SYMBOL,UUID,SYMBOL,SYMBOL,SYMBOL,SYMBOL,SYMBOL,SYMBOL,SYMBOL,SYMBOL,
     TIMESTAMP,TIMESTAMP,SYMBOL]);
t_complete_warning_stream_data=streamTable(t_completed_event_partition_table)

我在DolphinDB database GUI中插入记录：

insert into t_complete_warning_stream_data values("0000100888","256065fd-74d0-4004-bb55-c15d5982a531","748865688JA002AP3S6000000000","福建宁德3# 科尼 110KW 3号厂房 AB2 JA002AP3S6","1","200mS","","","告警","null",2020.03.11T09:55:56.000,2020.03.11T09:56:06.000,"已通知");

报异常：Failed to append data to column 'company_id'。请问是什么原因？

0 条评论

默认排序时间排序

1 个回答

logger 2021-06-15 16:28

流数据写入时，要求类型一致。因此字符串需要用uuid函数转换一下：

insert into t\_complete\_warning\_stream\_data values("0000100888",uuid("256065fd-74d0-4004-bb55-c15d5982a531"),"748865688JA002AP3S6000000000","福建宁德3# 科尼 110KW 3号厂房 AB2 JA002AP3S6","1","200mS","","","告警","null",2020.03.11T09:55:56.000,2020.03.11T09:56:06.000,"已通知");

流数据表中UUID字段怎么写入

1 个回答

相似问题