Used: 438105027512, Limit: 438103947386. Mem usage has exceed the limit of single query, You can change the limit by set session variable exec_mem_limit目前我设置比较这个限制的值大，还是报错超出限制，

💬 StarRocks 用户问答 功能使用相关
#462

enable_pipeline_engine这个设置后好像要重启，重启fe了吗？

#463

对的，重启过了 凑字

#464

能提供一下那个sql的query dump吗？

#465

麻烦问一下，是执行计划吗

#466

wget --user=root --password=1234 --post-file post_file http://fe_host:fe_http_port/api/query_dump?db=$db -O dump_file
post_file为包含query的文件
dump_file是返回的数据
$DB为您的db

#467

您这个执行的时候是不是需要把sql 执行完，还是说在执行中就可以执行

#468

真正执行的，就只有explain costs不用执行

#469

wget --user=root --post-file post_file http://10.0.0.81:8030/api/query_dump?db=tcph10tmp -O dump_file
–2022-09-06 10:18:01-- http://10.0.0.81:8030/api/query_dump?db=tcph10tmp
POST data file ‘post_file’ missing: No such file or directory
Connecting to 10.0.0.81:8030… connected.
HTTP request sent, awaiting response… 401 Unauthorized
Authorization failed.
我这个密码是空，应该怎么写呢

#470

password= 不填就ok

#471

不写的话返回400
[root@tpcds-bdp-01 ~]# wget --user=root --password= --post-file post_file http://10.0.0.81:8030/api/query_dump?db=tcph10tmp -O dump_file
–2022-09-06 02:22:57-- http://10.0.0.81:8030/api/query_dump?db=tcph10tmp
POST data file ‘post_file’ missing: No such file or directory
Connecting to 10.0.0.81:8030… connected.
HTTP request sent, awaiting response… 401 Unauthorized
Reusing existing connection to 10.0.0.81:8030.
HTTP request sent, awaiting response… 400 Bad Request
2022-09-06 02:22:57 ERROR 400: Bad Request.

[root@tpcds-bdp-01 ~]#

#472

把sql放在post_file

#473

请把测试有问题的一个sql发一下 谢谢

#474

https://docs.starrocks.com/zh-cn/latest/benchmarking/TPC-H_Benchmark 第一个sql

#475

还是哪个报错400

#476

详细报错信息发一下

#477

sql分析.txt (19.8 KB)

#478

您这个explain cost不是第一个SQL吧 麻烦跑一下第一个SQL的query dump

#479

是第一个，select
l_returnflag,
l_linestatus,
sum(l_quantity) as sum_qty,
sum(l_extendedprice) as sum_base_price,
sum(l_extendedprice * (1 - l_discount)) as sum_disc_price,
sum(l_extendedprice * (1 - l_discount) * (1 + l_tax)) as sum_charge,
avg(l_quantity) as avg_qty,
avg(l_extendedprice) as avg_price,
avg(l_discount) as avg_disc,
count(*) as count_order
from lineitem
where l_shipdate <= date ‘1998-12-01’
group by l_returnflag, l_linestatus
order by l_returnflag, l_linestatus;

#480

wget --user=root --password= --post-file postfile http://10.0.0.81:8030/api/query_dump?db=tcph10tmp -O dump_file
sql放在postfile

#481

这个SQL 先让他跑完第一次 再跑第二次看看吧

京ICP备2022026421号-1