clintropolis opened a new pull request, #20452:
URL: https://github.com/apache/druid/pull/20452

   ### Description
   Follow-up to #19830 and #20377, this adds a rollup table 
`BaseTableProjectionSpec`, the API side companion of the internal v10 segment 
metadata `RollupTableProjectionSchema` that we store internally for rollup 
tables. This PR rounds stuff out so that all of the physical layouts of V10 
segments can be expressed as base table specs, and also with DDL in the 
catalog, where a rollup table is expressed as a group by query base table 
projection:
   
   ```
   CREATE TABLE "druid"."visits" (
     user_id VARCHAR,
     __time TIMESTAMP,
     total BIGINT,
     ...
     PROJECTION __base AS (
       SELECT user_id, TIME_FLOOR(__time, 'PT1H') AS __time, SUM(total) AS total
       GROUP BY 1, 2
     )
   )
   PARTITIONED BY DAY
   ```
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to