Uploaded image for project: 'Data Management'
  1. Data Management
  2. DM-18342

Add ci_id, ci_url and squash_id as InfluxDB fields instead of tags

    XMLWordPrintable

    Details

    • Type: Story
    • Status: Done
    • Resolution: Done
    • Fix Version/s: None
    • Component/s: squash
    • Labels:
      None

      Description

      ci_id, ci_url and squash_id are sequential numbers. If mapped to InfluxDB tags that will
      increase InfluxDB series cardinality which is not recommended.

      We should add ci_id, ci_url and squash_id as InfluxDB fields instead.

        Attachments

          Issue Links

          relates to

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. DM-18103 Revisit SQuaSH InfluxDB data model

          • Done

            Activity

            Ascending order - Click to sort in descending order
            No builds found.
            afausti Angelo Fausti created issue -
            afausti Angelo Fausti made changes -
            Field Original Value New Value
            Epic Link DM-16744 [ 235432 ]
            afausti Angelo Fausti made changes -
            Status To Do [ 10001 ] In Progress [ 3 ]
            afausti Angelo Fausti made changes -
            Link This issue relates to DM-18103 [ DM-18103 ]
            afausti Angelo Fausti made changes -
            Summary Add ci_id and squash_id as InfluxDB field instead of tag Add ci_id, ci_url and squash_id as InfluxDB field instead of tag
            afausti Angelo Fausti made changes -
            Description {{ci_id}} and {{squash_id}} are sequential numbers. If mapped to InfluxDB tags that will
            [increase InfluxDB series cardinality|https://docs.influxdata.com/influxdb/v1.7/concepts/schema_and_data_layout/#discouraged-schema-design]

            We should add {{ci_id}} and {{squash_id}} as InfluxDB fields instead.             		{{ci_id}}, {{ci_url}} and {{squash_id}} are sequential numbers. If mapped to InfluxDB tags that will
            [increase InfluxDB series cardinality|https://docs.influxdata.com/influxdb/v1.7/concepts/schema_and_data_layout/#discouraged-schema-design]

            We should add {{ci_id}} and {{squash_id}} as InfluxDB fields instead.
            afausti Angelo Fausti made changes -
            Description {{ci_id}}, {{ci_url}} and {{squash_id}} are sequential numbers. If mapped to InfluxDB tags that will
            [increase InfluxDB series cardinality|https://docs.influxdata.com/influxdb/v1.7/concepts/schema_and_data_layout/#discouraged-schema-design]

            We should add {{ci_id}} and {{squash_id}} as InfluxDB fields instead.             		{{ci_id}}, {{ci_url}} and {{squash_id}} are sequential numbers. If mapped to InfluxDB tags that will
            [increase InfluxDB series cardinality|https://docs.influxdata.com/influxdb/v1.7/concepts/schema_and_data_layout/#discouraged-schema-design] which is not recommended.

            We should add {{ci_id}} and {{squash_id}} as InfluxDB fields instead.
            afausti Angelo Fausti made changes -
            Description {{ci_id}}, {{ci_url}} and {{squash_id}} are sequential numbers. If mapped to InfluxDB tags that will
            [increase InfluxDB series cardinality|https://docs.influxdata.com/influxdb/v1.7/concepts/schema_and_data_layout/#discouraged-schema-design] which is not recommended.

            We should add {{ci_id}} and {{squash_id}} as InfluxDB fields instead.             		{{ci_id}}, {{ci_url}} and {{squash_id}} are sequential numbers. If mapped to InfluxDB tags that will
            [increase InfluxDB series cardinality|https://docs.influxdata.com/influxdb/v1.7/concepts/schema_and_data_layout/#discouraged-schema-design] which is not recommended.

            We should add {{ci_id}}, {{ci_url}} and {{squash_id}} as InfluxDB fields instead.
            afausti Angelo Fausti made changes -
            Story Points 1.4 0.5
            afausti Angelo Fausti made changes -
            Component/s squash [ 14169 ]
            afausti Angelo Fausti made changes -
            Summary Add ci_id, ci_url and squash_id as InfluxDB field instead of tag Add ci_id, ci_url and squash_id as InfluxDB fields instead of tags
            afausti Angelo Fausti made changes -
            Epic Link DM-16744 [ 235432 ] DM-5504 [ 23337 ]
            afausti Angelo Fausti made changes -
            Epic Link DM-5504 [ 23337 ] DM-17034 [ 238527 ]
            Hide
            Permalink
            afausti Angelo Fausti added a comment -

            ci_id, ci_url and squash_id are properly mapped to InfluxDB fields now.
            https://github.com/lsst-sqre/squash-restful-api/blob/master/examples/influxdb_data_model.ipynb

            Show
            afausti Angelo Fausti added a comment - ci_id , ci_url and squash_id are properly mapped to InfluxDB fields now. https://github.com/lsst-sqre/squash-restful-api/blob/master/examples/influxdb_data_model.ipynb
            afausti Angelo Fausti made changes -
            Resolution Done [ 10000 ]
            Status In Progress [ 3 ] Done [ 10002 ]

              People

              Assignee:
              afausti Angelo Fausti
              Reporter:
              afausti Angelo Fausti
              Watchers:
              Angelo Fausti
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Jenkins

                  No builds found.