Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

使用all in one的自定义scql组件报错CreateTable: Table schema err: VerifyTableMeta: line 6 column 8 near \\\"default int, #206

Closed
EtanWatson opened this issue Feb 6, 2025 · 2 comments

Comments

@EtanWatson
Copy link

Issue Type

Running

Have you searched for existing documents and issues?

Yes

OS Platform and Distribution

CentOS Linux release 7.9.2009

All_in_one Version

v1.11.0

Module type

secretpad

Module version

0.12.0b0

What happend and What you expected to happen.

使用内置节点alice和bob进行自定义scql组件分析的时候,出现status error: code:300  message:\"CreateTable: Table schema err: VerifyTableMeta: line 6 column 8 near \\\"default int错误,查询secretpad和alice的lite节点,均报这个错
sql如下,为简单的查询alice的输出表,隐私求交结果正常输出:
select
  id1,
  age,
  education
from
  alice_iptazwok_node_35_output_0
我看源表里面字段均为float,但是保存的时候,字段的类型为int,不知道什么原因导致的

Log output.

2025-02-06 09:41:57 INFO the jobId=gdrx, taskId=gdrx-iptazwok-node-36 start ...
2025-02-06 09:42:03 INFO the jobId=gdrx, taskId=gdrx-iptazwok-node-36 failed: party alice failed msg: container[agent] terminated state reason "Error", message: "2025-02-06 09:41:57.269 INFO main.go:62 Read config file: /work/configs/config.yml
2025-02-06 09:41:57.269 INFO agent.go:61 self party: alice, run as initiator
2025-02-06 09:41:57.269 INFO kusciastub.go:84 CreateServing request: serving_id:\"sid-gdrxiptazwoknode36\"  initiator:\"alice\"  parties:{domain_id:\"alice\"  role:\"broker\"  app_image:\"scql-image\"  service_name_prefix:\"broker-sid-gdrxiptazwoknode36\"}  parties:{domain_id:\"bob\"  role:\"broker\"  app_image:\"scql-image\"  service_name_prefix:\"broker-sid-gdrxiptazwoknode36\"}
2025-02-06 09:41:57.269 INFO kusciastub.go:92 CreateServing succeed, resp: status:{message:\"success\"}
2025-02-06 09:42:00.269 INFO kusciastub.go:117 WaitServingReady succeed
2025-02-06 09:42:00.269 INFO kusciastub.go:160 GetBrokerUrl succeed: broker-sid-gdrxiptazwoknode36-intra.alice.svc:23742
2025-02-06 09:42:00.269 INFO scqlstub.go:72 CreateProject req: project_id:\"gdrxiptazwoknode36\"  conf:{spu_runtime_cfg:{protocol:SEMI2K  field:FM64}}
2025-02-06 09:42:00.269 INFO scqlstub.go:81 CreateProject succeed
2025-02-06 09:42:00.269 INFO scqlstub.go:102 InviteMember: invite bob successfully
2025-02-06 09:42:00.269 INFO scqlstub.go:151 WaitMemberReady start
2025-02-06 09:42:01.269 INFO scqlstub.go:173 WaitMemberReady succeed: project 'gdrxiptazwoknode36' cantains all memebers
2025-02-06 09:42:01.269 INFO scqlstub.go:182 CreateTable for: alice
2025-02-06 09:42:01.269 INFO kusciastub.go:139 DeleteServing succeed
2025-02-06 09:42:01.269 FATAL main.go:70 Run agent failed: CreateTable: status error: code:300  message:\"CreateTable: Table schema err: VerifyTableMeta: line 6 column 8 near \\\"default int,\
balance int,\
housing int,\
loan int,\
day int,\
duration int,\
campaign int,\
pdays int,\
previous int,\
job_blue-collar int,\
job_entrepreneur int,\
job_housemaid int,\
job_management int,\
job_retired int,\
job_self-employed int,\
job_services int,\
job_student int,\
job_technician int,\
job_unemployed int,\
marital_divorced int,\
marital_married int,\
marital_single int\
\\t);\
\\t\\\" \"
"
@lanyy9527
Copy link

中心化模式内置的数据包含default字段,可以重新上传两份自定义数据来进行测试;
ps:可以查看 自定义scql分析组件字段命名规则

@EtanWatson
Copy link
Author

中心化模式内置的数据包含default字段,可以重新上传两份自定义数据来进行测试; ps:可以查看 自定义scql分析组件字段命名规则

解决啦,谢谢啦

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants