Re: [I] How do you configure "Actively Used Direct (Estimate)" memory in "Metrics" tab of Drill Web UI? (drill)

[via GitHub]

wschung1113 commented on issue #2789:
URL: https://github.com/apache/drill/issues/2789#issuecomment-1499922929

   Thanks for a reply!
   
   Most of the time is taken at query execution:
   
![image](https://user-images.githubusercontent.com/28873808/230540985-fc5076f8-6e19-477f-97a4-7589d5c9cf7f.png)
   
   Data format is just a ordinary row-based table from a rdbms (Oracle alike).
   
   Query should look like this, rather simple query with an outer join and few 
group by clauses. However the data is relatively large so it takes about 4 
minutes and I want to try to push it down.
   
   WITH DEF_TABLE AS (
   SELECT *
   FROM rdbms.hyperdata_ex.DO171
   )
   SELECT M_0
   FROM (
   SELECT L_SHIPINSTRUCT AS C0_0, L_SHIPMODE AS C1_0, SUM(L_EXTENDEDPRICE) AS 
M_0
   FROM DEF_TABLE
   GROUP BY L_SHIPINSTRUCT, L_SHIPMODE
   ) TARGET
   
   RIGHT OUTER JOIN (
   SELECT *
   FROM (
   SELECT L_SHIPINSTRUCT AS C0_0, L_SHIPINSTRUCT AS K0_0
   FROM DEF_TABLE
   GROUP BY L_SHIPINSTRUCT
   ),
   (
   SELECT L_SHIPMODE AS C1_0, L_SHIPMODE AS K1_0
   FROM DEF_TABLE
   GROUP BY L_SHIPMODE
   )
   ) BASE ON (
   (TARGET.C0_0 = BASE.C0_0)
   AND (TARGET.C1_0 = BASE.C1_0)
   )
   ORDER BY K0_0 ASC, K1_0 ASC


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscr...@drill.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org