Set timeseries options to the timeseries view docs got from $listCollections

XMLWordPrintableJSON

    • Type: Task
    • Resolution: Duplicate
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Catalog and Routing
    • CAR Team 2024-08-19, CAR Team 2024-09-02
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      One of the goal of SPM-3797 is to create a $listCollections aggregation stage that replicates as much as possible the listCollections output adding important sharding information for the user.

      However, the new $listCollections introduced by SERVER-92216, is not returning the same fields as the listCollections command for the timeseries-view namespaces.

      This is an example for a timeseries-view namespace returned by $listCollections followed by the output of the listCollections command:

      // timeseries-view returned by $listCollections: 
  {
     namespace: 'dbA.collTimeseries',
     db: 'dbA',
     type: 'timeseries',
     viewOn: 'system.buckets.collT',
     pipeline: [
       {
         '$_internalUnpackBucket': { timeField: 't', bucketMaxSpanSeconds: 3600 }
       }
     ],
     info: { readOnly: false }
     sharded: false
   }
      // timeseries-view returned by the listCollections command:
 {
    name: 'collT',
    type: 'timeseries',
    options: {
      timeseries: {
        timeField: 't',
        granularity: 'seconds',
        bucketMaxSpanSeconds: 3600
      }
    },
    info: { readOnly: false }
  }

      This task aims to:

      • Remove the pipeline and viewOn fields
      • Add the options.timeseries field 

            Assignee:
            Silvia Surroca
            Reporter:
            Silvia Surroca
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: