DruidContext not working

[okeeffdp]

Hi all,

I am having trouble passing parameters to druid via the druidContext key in the yml config. I want to do two things: first, I want to display more than five lines on a line graph; Second I want to get the exact count distinct, not the approximate number. I'm not sure what I am doing wrong. I followed the doc here The I can see the parameters in the query context that is sent to Druid, but the results do not show what I expect.

Here is a sample of the config,

dataCubes:
  - name: my_cube
    options:
      # Context to be sent to Druid with every query executed on the data cube
      # defined as yaml key / value mappings.
      # https://druid.apache.org/docs/latest/querying/query-context.html
      druidContext:
        # Whether to use an approximate cardinality algorithm for COUNT(DISTINCT foo)s
        # https://druid.apache.org/docs/latest/configuration/index.html#broker-node-configs
        useApproximateCountDistinct: false
        # The top minTopNThreshold local results from each segment are returned
        # for merging to determine the global topN.
        minTopNThreshold: 20
        threshold: 20

The query sent to druid which I got verbose: true in the yaml.

{
  "queryType": "topN",
  "dataSource": "my_cube_source",
  "intervals": "2020-11-23T23:25Z/2021-05-23T23:25Z",
  "granularity": "all",
  "context": {
    "useApproximateCountDistinct": false,
    "minTopNThreshold": 20,
    "threshold": 20,
    "timeout": 40000
  },
  "filter": {
    "type": "selector",
    "dimension": "issue_type_category",
    "value": "account security"
  },
  "dimension": {
    "type": "default",
    "dimension": "issue_type",
    "outputName": "issue_type"
  },
  "aggregations": [
    {
      "name": "count",
      "type": "longSum",
      "fieldName": "count"
    }
  ],
  "metric": "count",
  "threshold": 5
}

Thanks

[mkuthan]

1. The parameter "useApproximateCountDistinct" is for SQL, Turnilo executes native queries only. To get exact count you have to configure datasource (numer or string field type, not HLL)
2. The parameter minTopNThreshold should work as expected, but this is not parameter to set up number of lines on the line chart (use limit on the split, max splits is 10)
3. There is no "treshold" query context parameter https://druid.apache.org/docs/latest/querying/query-context.html

I hope, it helps :)

[okeeffdp]

Hi @mkuthan ,

Thanks for the information. Can I increase the max split limit past 10?

I see options for 25, 50, and 100, but they do nothing when I click them. Is there a limit variable in the turnilo configuration that I can change?

Thanks,
Daniel