Hi there, You should check the cache directory to see if Drill is writing files to the cache. You should see result files there. Best, -- C
> On Feb 16, 2024, at 09:06, RayetSena (via GitHub) <g...@apache.org> wrote: > > > RayetSena opened a new issue, #2881: > URL: https://github.com/apache/drill/issues/2881 > > Hello, > > I am using http storage plugin and I want to activate the caching. In the > documentation it says that this requires adding cacheResults. So I added this > to my config. But when I run the same query again, there is almost no > difference in query duration. You can see the configuration and query > duration below. > > >  > ``` > { > "type": "http", > "cacheResults": true, > "connections": { > "opendata": { > "url": "https://opendata.cbs.nl/ODataApi/odata/";, > "requireTail": true, > "method": "GET", > "authType": "none", > "inputType": "json", > "xmlDataLevel": 1, > "postParameterLocation": "QUERY_STRING", > "verifySSLCert": false > } > }, > "timeout": 4000, > "retryDelay": 5000, > "proxyType": "direct", > "authMode": "USER_TRANSLATION", > "enabled": true > } > ``` > >  > > Also I tried to configure the caching properties in the drill-override.conf > file. Here is the configuration that I added: > ``` > drill.exec: { > caching: { > enabled: true > storage:{ > type: “local” > path: “cache/directory” > } > } > } > ``` > > **Drill version** > 1.21.1 > > > > > -- > This is an automated message from the Apache Git Service. > To respond to the message, please log on to GitHub and use the > URL above to go to the specific comment. > > To unsubscribe, e-mail: dev-unsubscr...@drill.apache.org.apache.org > > For queries about this service, please contact Infrastructure at: > us...@infra.apache.org >
