star_schema.txt

:) SELECT      C_REGION,      C_NATION,      count(*) FROM lineorder_x3  GLOBAL ANY INNER JOIN  (     SELECT          C_REGION,          C_NATION,          C_CUSTKEY AS LO_CUSTKEY     FROM customer_x3  ) USING (LO_CUSTKEY) WHERE (toYear(LO_ORDERDATE) > 1993) AND (LO_DISCOUNT >= 1) AND (LO_QUANTITY < 25) GROUP BY      C_REGION,      C_NATION;

SELECT 
    C_REGION, 
    C_NATION, 
    count(*)
FROM lineorder_x3 
GLOBAL ANY INNER JOIN 
(
    SELECT 
        C_REGION, 
        C_NATION, 
        C_CUSTKEY AS LO_CUSTKEY
    FROM customer_x3 
) USING (LO_CUSTKEY)
WHERE (toYear(LO_ORDERDATE) > 1993) AND (LO_DISCOUNT >= 1) AND (LO_QUANTITY < 25)
GROUP BY 
    C_REGION, 
    C_NATION

┌─C_REGION────┬─C_NATION───────┬──count()─┐
│ EUROPE      │ UNITED KINGDOM │ 72772537 │
│ AFRICA      │ ETHIOPIA       │ 72952010 │
│ AMERICA     │ BRAZIL         │ 72835793 │
│ EUROPE      │ ROMANIA        │ 72910028 │
│ EUROPE      │ FRANCE         │ 72859608 │
│ ASIA        │ CHINA          │ 72950291 │
│ ASIA        │ JAPAN          │ 72921870 │
│ ASIA        │ VIETNAM        │ 72971748 │
│ MIDDLE EAST │ JORDAN         │ 73012352 │
│ AFRICA      │ KENYA          │ 72833487 │
│ AFRICA      │ ALGERIA        │ 72882355 │
│ AMERICA     │ ARGENTINA      │ 72974608 │
│ AMERICA     │ PERU           │ 72956048 │
│ AMERICA     │ CANADA         │ 72931770 │
│ MIDDLE EAST │ SAUDI ARABIA   │ 72907530 │
│ AFRICA      │ MOZAMBIQUE     │ 73026789 │
│ MIDDLE EAST │ EGYPT          │ 72984421 │
│ ASIA        │ INDIA          │ 72787919 │
│ AMERICA     │ UNITED STATES  │ 72930611 │
│ MIDDLE EAST │ IRAQ           │ 73018555 │
│ EUROPE      │ RUSSIA         │ 72794082 │
│ AFRICA      │ MOROCCO        │ 72852675 │
│ EUROPE      │ GERMANY        │ 72799180 │
│ MIDDLE EAST │ IRAN           │ 72896618 │
│ ASIA        │ INDONESIA      │ 72948330 │
└─────────────┴────────────────┴──────────┘

25 rows in set. Elapsed: 41.378 sec. Processed 4.30 billion rows, 37.72 GB (103.85 million rows/s., 911.65 MB/s.)