scql

scql copied to clipboard

把scql engine的数据源换成pgsql，在client执行查询语句，报如下错误，请问应该怎么修改配置？

`[demo]alice> SELECT ta.credit_rank, COUNT(*) as cnt, AVG(ta.income) as avg_income, AVG(tb.order_amount) as avg_amount FROM ta INNER JOIN tb ON ta.ID = tb.ID WHERE ta.age >= 20 AND ta.age <= 30 AND tb.is_active=1 GROUP BY ta.credit_rank; [fetch]err: Code: 320, message:RunExecutionPlan run jobs(3399514f-75b5-11ee-bb1d-0242c0a87006) failed, catch std::exception=[engine/datasource/odbc_ad aptor.cc:58] catch unexpected Poco::Data::DataException: Connection attempt failed: Connection Error: connection to server on socket "/tmp/.s.PGSQL.54 32" failed: No such file or directory Is the server running locally and accepting connections on that socket?

Stacktrace: #0 scql::engine::op::RunSQL::Execute()+0x556e3e6f20f6 #1 scql::engine::Executor::RunExecNode()+0x556e3e4deb33 #2 scql::engine::EngineServiceImpl::RunPlan()+0x556e3e4d163d #3 scql::engine::EngineServiceImpl::RunExecutionPlan()+0x556e3e4d4625 #4 brpc::policy::ProcessHttpRequest()+0x556e40ccd321 #5 brpc::ProcessInputMessage()+0x556e40c77b97 #6 brpc::InputMessenger::InputMessageClosure::~InputMessageClosure()+0x556e40c785f1 #7 brpc::InputMessenger::OnNewMessages()+0x556e40c790a1 #8 brpc::Socket::ProcessEvent()+0x556e40d739fe #9 bthread::TaskGroup::task_runner()+0x556e40dcd497 #10 bthread_make_fcontext+0x556e40db8b01 `

请进入到 engine 的容器中，用配置的 pgsql 连接串连接一下 pgsql 试下，看是否可以联通

请问使用的 pg 的版本是哪个？