Skip to main content

Cube

Definition​

The cube method allows you to add the CUBE subclause to the query.

The CUBE subclause is a short way to define multiple grouping sets so the following are equivalent:

CUBE(k1, k2, k3) 

GROUPING SETS (
    (k1, k2, k3), 
    (k1, k2),
    (k1, k3),
    (k2, k3),
    (k1),
    (k2),
    (k3), 
    ()
 )

Available methods​

1. cube(KColumn... kColumns)​

  • kColumns: are all the expresions that will be added to the CUBE subclause.
    Among the possible values are: KTableColumn, KColumn.
tip

The use of this method is recommended in statements that involve the GROUP BY clause.

To use this method, you need to import the static functions as follows:

import static com.myzlab.k.KFunction.*;

Example​

Java code:

k
.select(
    count(),
    APP_USER.CREATED_AT.cast(date()),
    APP_USER.ROLE_ID,
    grouping(APP_USER.CREATED_AT.cast(date())),
    grouping(APP_USER.ROLE_ID)
)
.from(APP_USER)
.groupBy(
    cube(APP_USER.CREATED_AT.cast(date()), APP_USER.ROLE_ID)
)
.multiple();

SQL generated:

SELECT
    COUNT(*),
    CAST(au.created_at AS DATE),
    au.role_id,
    GROUPING(CAST(au.created_at AS DATE)),
    GROUPING(au.role_id)
FROM app_user au
GROUP BY 
    CUBE(CAST(au.created_at AS DATE), au.role_id)

Parameters:

  • None