Uploaded image for project: 'CarbonData'
  1. CarbonData
  2. CARBONDATA-1516 Support pre-aggregate tables and timeseries in carbondata
  3. CARBONDATA-1517

1. Support CTAS in carbon and support creating aggregation tables using CTAS.And update aggregation table information to main table schema.

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 1.3.0
    • None
    • None

    Description

      User should add aggregation tables with following syntax

      CREATE TABLE agg_sales 
      STORED BY 'carbondata'
      TBLPROPERTIES ('parent_table'='sales') 
      AS SELECT user_id, sum(quantity), avg(price) FROM sales GROUP BY user_id
      

      Attachments

        Issue Links

          Activity

            People

              kumarvishal09 Kumar Vishal
              ravi.pesala Ravindra Pesala
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 4h 10m
                  4h 10m