General

Latest Discussion Posts

  • hi @Jeon Woohyuck , my runtimes are linear on the same are using for testing Into the attach the queries runtime, memory allocation and - output Regards ------------------------------ Candido Dessanti Dba Crismatica consulting Rome ----------- ...

  • Oh, Sorry. that log is cold cache, but the value I wrote is the time value after running the query about 5 times. ------------------------------ Jeon Woohyuck [[Unknown]] ------------------------------

  • Hi @Patrick Erdelt I have 3 gpu's in this machine so I used this set up for my sharding DROP TABLE IF EXISTS PART; CREATE TABLE PART ( P_PARTKEY BIGINT, P_NAME TEXT ENCODING DICT, P_MFGR TEXT ENCODING DICT, P_BRAND TEXT ENCODING DICT, P_TYPE ...

  • Hi Thanks for your continued exploration of OmniSci @Patrick Erdelt Could you share the precise CREATE table statements you used to build your test tables for the above result?​ In parallel I will test this locally to see if i can see the difference ...

  • Hi @Patrick Erdelt , I just used the copy command running the same query on both tables, then compared with diff Unix command the sorted of resulting CSVs. copy (select ....) to '/path/query1.csv' I can try with 2018 data only, but using such ...

Latest Shared Files