search

druid-io / pydruid

A Python connector for Druid
Other
506 stars 194 forks source link

[Question] PyDruid queries misses the cache, Why? #191

Open EmadMokhtar opened 4 years ago

EmadMokhtar commented 4 years ago

Hi,

Last week we upgrade from Python 2.7 to Python 3.5, and with this upgrade, we upgraded PyDriud from 0.4.1 to 0.5.7. After this upgrade we saw there are many queries misses the cache from historicals and brokers. We are enabling the useCache and populateCahce setting by default. Thus we are not passing it into the PyDruid query.

roles/druid_common/templates/_common/common.runtime.properties:#druid.(broker|historical|realtime).cache.useCache=false
roles/druid_common/templates/broker/runtime.properties:druid.broker.cache.useCache=true
roles/druid_common/templates/historical/runtime.properties:druid.historical.cache.useCache=true
roles/druid_common/templates/_common/common.runtime.properties:#druid.(broker|historical|realtime).cache.populateCache=false
roles/druid_common/templates/broker/runtime.properties:druid.broker.cache.populateCache=true
roles/druid_common/templates/historical/runtime.properties:druid.historical.cache.populateCache=true

Any idea what is wrong?

Nagam-Naidu commented 2 years ago

Did we get any resolution for the same. Or is there any way to set useCache and populateCahce while creating connection?