使用studio导入时间戳数据问题

nebula 版本:3.2.v
部署方式:分布式
安装方式:RPM
是否为线上版本:Y
硬件信息
磁盘 非SSD
CPU、内存信息 单节点 4core8g
问题的具体描述
相关的 meta / storage / graph info 日志信息(尽量使用文本形式方便检索)

我定义的vertex的schema如下:

CREATE EDGE sign(sign_time timestamp);

csv文件中对应的列也是时间戳类型,如下2张图所示

开始执行导入后,在控制台有错误输出

2022/11/30 21:48:40 [ERROR] handler.go:63: Client 8 fail to execute: INSERT EDGE `sign`(`sign_time`) VALUES "3503115267403219110"->"110.184.40.255":(timestamp("1646184668")) , "3501221414492962918"->"180.143.213.44":(timestamp("1646184860")) , "3533150418323046484"->"2409:893c:e20:25c9:be0e:7545:1108:9877":(timestamp("1646184931")) , "3531476456483193065"->"114.86.229.22":(timestamp("1646185089")) , "3531257971213402282"->"60.169.131.249":(timestamp("1646185173")) , "3527046810137395284"->"118.249.43.102":(timestamp("1646185309")) , "3522174784054886464"->"221.231.165.104":(timestamp("1646185395")) , "3514429382145998912"->"220.200.38.121":(timestamp("1646185567")) , "3524395737504088297"->"112.115.89.207":(timestamp("1646185774")) , "3531687269020336299"->"123.112.232.90":(timestamp("1646185969")) , "3516060496397271142"->"117.32.246.198":(timestamp("1646186141")) , "3522416790670803188"->"2409:8960:1e68:7e16:486c:f986:623:460b":(timestamp("1646186476")) , "3513276584750874868"->"111.121.78.104":(timestamp("1646186538")) , "3481577608674148586"->"2409:891e:2800:2493:dc76:ac6:8ed8:7206":(timestamp("1646186697")) , "3496941922139308276"->"124.77.18.228":(timestamp("1646186782")) , "3532382081451425974"->"124.78.253.21":(timestamp("1646186936")) , "3518464005248188660"->"14.223.181.141":(timestamp("1646187081")) , "3482881783994449984"->"112.82.224.153":(timestamp("1646187192")) , "3518495203937157364"->"113.71.139.25":(timestamp("1646187423")) , "3533894349885866023"->"106.47.127.183":(timestamp("1646187592")) , "3509026751199510772"->"117.89.18.120":(timestamp("1646187856")) , "3521793487645638871"->"113.89.8.62":(timestamp("1646187956")) , "3474119580488826944"->"2409:8962:c:1f1b:ea15:61e1:a191:c300":(timestamp("1646188230")) , "3526671275577573546"->"120.244.74.175":(timestamp("1646188550")) , "3481729536737476842"->"117.30.165.253":(timestamp("1646188686")) , "3522352728992448727"->"113.109.43.20":(timestamp("1646189007")) , "3520141433040339188"->"2408:8417:b01:8e7:74fc:ea87:91a3:a68":(timestamp("1646189287")) , "3496066124465897536"->"2409:8950:a87:81b5:196b:6f3f:c23e:577":(timestamp("1646189675")) , "3516606140349284416"->"125.33.202.93":(timestamp("1646189937")) , "3493640049961533504"->"101.206.168.134":(timestamp("1646190655")) , "3501621559375822916"->"123.127.48.192":(timestamp("1646191103")) , "3531657234257150123"->"2409:8a00:60b6:77c0:172:43d1:1e11:cc5f":(timestamp("1646191478")) , "3505475674074775767"->"106.47.127.183":(timestamp("1646191920")) , "3513552687207481408"->"219.145.72.57":(timestamp("1646192438")) , "3516411129338593382"->"111.121.69.213":(timestamp("1646192689")) , "3508318312083620055"->"240e:47a:70:56fa:66bc:b0d:ae8:fcca":(timestamp("1646193312")) , "3535174078914101332"->"2409:8970:980:43e7:d461:81ff:fe3e:cbd7":(timestamp("1646193782")) , "3510886828465324247"->"49.90.185.207":(timestamp("1646194888")) , "3508628339013779700"->"2409:891f:4ea2:467:8d75:5f93:8719:e33b":(timestamp("1646196207")) , "3516970872894259415"->"183.133.39.236":(timestamp("1646198723")) , "3518094069004763238"->"175.191.54.69":(timestamp("1646199548")) , "3525553892463018023"->"240e:478:4000:9f37:89ef:6ec1:53b3:e1a6":(timestamp("1646200485")) , "3466049519268528343"->"223.104.63.190":(timestamp("1646201519")) , "3535169330817466452"->"2409:891f:4e24:836c:54c5:c9ff:fe0f:dfab":(timestamp("1646202341")) , "3522369198063026420"->"240e:458:48e:169f:201f:9443:e024:e51b":(timestamp("1646203090")) , "3531491911951056935"->"2409:8934:28a:4db4::1":(timestamp("1646203954")) , "3514206019785720023"->"218.7.40.9":(timestamp("1646205807")) , "3471390023439810662"->"113.78.13.242":(timestamp("1646207182")) , "3504357097308029030"->"2409:8902:5722:9260:fa1f:494b:157c:32fb":(timestamp("1646208417")) , "3535209825987002452"->"180.139.101.182":(timestamp("1646210441")) , "3512744032896090356"->"182.119.36.253":(timestamp("1646212820")) , "3507188930448261364"->"27.17.191.62":(timestamp("1646214326")) , "3534787149102514260"->"2409:8900:78a3:9da:834:58ff:fefd:fefe":(timestamp("1646216244")) , "3535225655102079158"->"2408:8456:4621:4677:2:2:8eb2:d312":(timestamp("1646218370")) , "3534664100350197931"->"113.81.175.104":(timestamp("1646222794")) , "3511831504195748084"->"2408:8456:d047:9aa6:2:1:73c9:e0f":(timestamp("1646228431")) , "3495854058678255850"->"101.206.166.234":(timestamp("1646237235")) , "3528527496040349735"->"223.74.157.28":(timestamp("1646239376")) , "3534271794158502058"->"223.104.42.188":(timestamp("1646259690")) , "3513461393256022118"->"240e:47c:2c18:595f:e6e0:3a35:6e19:4d87":(timestamp("1646261757")) ;, ErrMsg: Wrong value type: timestamp("1646184668"), ErrCode: -1005

为什么插入的时候timestamp会插入引号呢?timestamp(“1646261757”)
是我的配置有问题,还是这是studio的一个bug?

先感谢各位开发者了

补充:通过论坛查询了相关的问题说这是studio的一个bug,可以通过importer进行数据导入,但是通过importer进行导入时,也是同样的问题

@helloworld 您好!
您的问题,我们一早就在分析。目前定位到是 importer 导入数据的问题。
Studio 也是依赖 importer 导入的,也是类似的问题。
我们将进行修复,谢谢您的反馈!

再补充:论坛相关的帖子

@helloworld 如果您现在比较紧急,是否可以暂时转换成 2022-12-01T23:47:16 格式?

咨询下,在studio或者importer哪个版本进行修复呢? 修复的时间大概在什么时候呢?

您是说在我csv文件中时间戳的那一列修改为 2022-12-01T23:47:16 格式?

是的

importer 目前已经修复

3 个赞

在上层处理的我数据为2022-12-01T23:47:16 格式后是没有问题的,十分感谢

效率真高!为社区点赞!

2 个赞

此话题已在最后回复的 7 天后被自动关闭。不再允许新回复。