--- queries.sql SELECT /*+q1*/ 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_qu...
hzhelifu@hadoop360:~/tpch_2_17_0/dbgen$ mkdir q hzhelifu@hadoop360:~/tpch_2_17_0/dbgen$foridin`seq122`;doDSS_QUERY=./queries ./qgen-s1$id-b ./dists.dss > q/$id.sql;done... ... hzhelifu@hadoop360:~/tpch_2_17_0/dbgen$ ls -lrt q total88-rw-r--r--1hzhelifu netea...
Add all tpch queries to sqllogictest #253 Merged jurplel merged 3 commits into main from bowad/all-tpch Dec 6, 2024 +849 −102 Conversation 0 Commits 3 Checks 1 Files changed 22 Conversation Member jurplel commented Dec 6, 2024 Also updated #184 jurplel and others added 3 ...
Between https://github.com/narwhals-dev/narwhals/actions/runs/11745034758 and https://github.com/narwhals-dev/narwhals/actions/runs/11756885339, the only differences are: 2024.10.0 vs 2024.11.0 (dask) 1.1.16 vs 1.1.17 (dask-expr) and the run went from 2 minutes 15 seconds to over 16...
cp queries/* to_query/ #!/bin/bash for i in `seq 1 22` do ./qgen -d ${i} > /tmp/tpch_sql/query_${i}.sql done GBase 8a MPP Cluster数据库加载语句: LOAD DATA INFILE 'ftp://root:zx0001@10.10.55.84//tmp/ww/DBGen/tpch_2_17_0/dbgen/lineitem.tbl' INTO TABLE tpch.lineitem...
[root@imysqltpch]#./qgen|sed-e”s/\r//”queries/tpch_queries.sql 而后用vim翻开tpch_queries.sql脚本,进展下面几次全局替换: :%s/;\nlimit/limit/g :%s/;\nlimit/limit/g :%s/limit-1/limit1/g 搜寻全部类似下面的语句,去掉后面的(3): ...
[root@imysqltpch]#./qgen|sed-e 's/\r//' > queries/tpch_queries.sql 而后用vim打开tpch_queries.sql脚本,进行下面几次全局替换: :%s/;\nlimit/ limit/g :%s/limit -1/limit 1/g 搜索所有类似下面的语句,去掉后面的(3): l_shipdate<= date '1998-12-01' - interval '106' day (3) => ...
load tpch; copy (select query from tpch_queries()) to './data/tpch.sql' with (quote '', HEADER false); 限制内存用量(8G), 限制CPU线程不超过4个 SET memory_limit = '8GB'; SET max_memory = '8GB'; SET threads = 4; .timer on 测试tpch 查询 .output ./data/tpch.result .read ./da...
cp queries/* to_query/ #!/bin/bash for i in `seq 1 22` do ./qgen -d ${i} > /tmp/tpch_sql/query_${i}.sql done GBase 8a MPP Cluster数据库加载语句: LOAD DATA INFILE 'ftp://root:zx0001@10.10.55.84//tmp/ww/DBGen/tpch_2_17_0/dbgen/lineitem.tbl' INTO TABLE tpch.lineitem...
[root@imysql tpch]# ./qgen | sed -e 's/\r//' > queries/tpch_queries.sql 而后用vim打开tpch_queries.sql脚本,进行下面几次全局替换: :%s/;\nlimit/ limit/g :%s/limit -1/limit 1/g 搜索所有类似下面的语句,去掉后面的 (3): l_shipdate ...