{"id":40844,"date":"2023-10-07T17:39:09","date_gmt":"2023-10-07T17:39:09","guid":{"rendered":"https:\/\/www.devopsschool.com\/blog\/?p=40844"},"modified":"2023-10-07T17:39:11","modified_gmt":"2023-10-07T17:39:11","slug":"dynatrace-tutorials-dynatrace-query-language-dql","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/dynatrace-tutorials-dynatrace-query-language-dql\/","title":{"rendered":"Dynatrace Tutorials: Dynatrace Query Language – DQL"},"content":{"rendered":"\n

Chaining commands with the pipe operator<\/strong><\/p>\n\n\n\n

A DQL query contains at least one or more commands, each of which returns tabular output containing records (lines or rows) and fields (columns). All commands are sequenced by a | (pipe). The data flows or is funneled from one command to the next. The data is filtered or manipulated at each step and then streamed into the following step.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

The Dynatrace Query Language (DQL) is a powerful tool to explore your data and discover patterns, identify anomalies and outliers, create statistical modeling, and more based on data stored in Dynatrace Grail storage.<\/p>\n\n\n\n

Here is a list of DQL commands:<\/h2>\n\n\n\n

Here is a list of DQL commands:<\/p>\n\n\n\n

    \n
  • fetch<\/strong> – Fetches data from a specific data type, such as logs, metrics, or business events.<\/li>\n\n\n\n
  • filter<\/strong> – Filters the data based on a specified condition.<\/li>\n\n\n\n
  • fields<\/strong> – Selects the fields that you want to include in the output.<\/li>\n\n\n\n
  • fieldsAdd<\/strong> – Adds new fields to the output.<\/li>\n\n\n\n
  • parse<\/strong> – Parses the data into a different format.<\/li>\n\n\n\n
  • summarize<\/strong> – Performs aggregations on the data, such as counting the number of rows, or finding the average value of a column.<\/li>\n\n\n\n
  • sort<\/strong> – Sorts the data based on a specified field.<\/li>\n\n\n\n
  • limit<\/strong> – Limits the number of rows that are returned in the output.<\/li>\n\n\n\n
  • timeseries<\/strong> – Produces a time series of aggregated data.<\/li>\n\n\n\n
  • fieldsSummary<\/strong> – Calculates the cardinality of field values that the specified fields have.<\/li>\n<\/ul>\n\n\n\n

    Here is a list of DQL Functions:<\/h2>\n\n\n\n

    The following is a list of DQL functions:<\/p>\n\n\n\n

      \n
    • avg<\/strong> – Calculates the average of the values in a column.<\/li>\n\n\n\n
    • count<\/strong> – Counts the number of rows in a table.<\/li>\n\n\n\n
    • count_distinct<\/strong> – Counts the number of distinct values in a column.<\/li>\n\n\n\n
    • first<\/strong> – Returns the first value in a column.<\/li>\n\n\n\n
    • last<\/strong> – Returns the last value in a column.<\/li>\n\n\n\n
    • max<\/strong> – Returns the maximum value in a column.<\/li>\n\n\n\n
    • min<\/strong> – Returns the minimum value in a column.<\/li>\n\n\n\n
    • percentile<\/strong> – Returns the percentile value of the values in a column.<\/li>\n\n\n\n
    • sum<\/strong> – Calculates the sum of the values in a column.<\/li>\n<\/ul>\n\n\n\n

      DQL operators<\/h2>\n\n\n\n

      Numerical operators<\/h2>\n\n\n\n

      The types long<\/code>, double<\/code> and timestamp<\/code> real represent numerical types. The following operators can be used between pairs of these types<\/p>\n\n\n\n

      Operator<\/th>Description<\/th>Example<\/th><\/tr><\/thead>
      +<\/code><\/td>Addition<\/td>2+2.5<\/code><\/td><\/tr>
      -<\/code><\/td>Subtraction<\/td>0.2-0.11<\/code><\/td><\/tr>
      *<\/code><\/td>Multiplication<\/td>4*5, 60*1s<\/code><\/td><\/tr>
      \/<\/code><\/td>Division<\/td>10\/2, 1h\/60<\/code><\/td><\/tr>
      %<\/code><\/td>Modulo<\/td>4%2<\/code><\/td><\/tr>
      <<\/code><\/td>Lower<\/td>8 < 9, now()-1m < now()<\/code><\/td><\/tr>
      <=<\/code><\/td>Lower than or equal<\/td>4<=5<\/code><\/td><\/tr>
      ><\/code><\/td>Greater<\/td>5 > 4<\/code><\/td><\/tr>
      >=<\/code><\/td>Greater than or equal<\/td>4 >=4<\/code><\/td><\/tr>
      ==<\/code><\/td>Equals<\/td>2 == 2<\/code><\/td><\/tr>
      !=<\/code><\/td>Not equals<\/td>1 != 2<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

      Logical or equality operators<\/h2>\n\n\n\n
      Operator<\/th>Description<\/th>Example (yields true)<\/th><\/tr><\/thead>
      ==<\/code><\/td>Equals – Yields true if both operands are not null and equal to each other. Otherwise, false.<\/td>2==2<\/code>, \"a\" == \"a\"<\/code><\/td><\/tr>
      !=<\/code><\/td>Not equals – Yields null, if one of the operands is null, or if the operands are not equal to each other.<\/td>2!=1, \"b\" != \"a\"<\/code><\/td><\/tr>
      NOT<\/code><\/td>Negation – Negates a logical state<\/td>NOT 2==1<\/code><\/td><\/tr>
      AND<\/code><\/td>Logical and (multiplication) – Yields true if both operands are true.<\/td>NOT 2==1 AND 1<2<\/code><\/td><\/tr>
      OR<\/code><\/td>Logical or (addition) – Yields true if one of the operands is true, regardless of the other operand.<\/td>1 < 2 OR 1 > 2<\/code><\/td><\/tr>
      XOR<\/code><\/td>Exclusive or – Yields true if one of the operands is true, but false in case both are true.<\/td>1 < 2 XOR 1 > 2<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"

      Chaining commands with the pipe operator A DQL query contains at least one or more commands, each of which returns tabular output containing records (lines or rows) and fields (columns). All commands are sequenced by a | (pipe). The data flows or is funneled from one command to the next. The data is filtered or…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","_joinchat":[],"footnotes":""},"categories":[2],"tags":[],"class_list":["post-40844","post","type-post","status-publish","format-standard","hentry","category-uncategorised"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/40844","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/comments?post=40844"}],"version-history":[{"count":1,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/40844\/revisions"}],"predecessor-version":[{"id":40846,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/40844\/revisions\/40846"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=40844"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=40844"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=40844"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}