You can translate the question and the replies:

Context clause wiped out by VDP....

I created a new derived view from a base view and provided the context for 'queryTimeout' setting e.g. ``` SELECT ... FROM ... CONTEXT ('queryTimeout' = '9000000') ``` However, VDP keeps replacing it with ``` SELECT ... FROM ... CONTEXT ('formatted' = 'yes') ``` How can I make it take my input? I'm using Denodo Virtual DataPort version 7.0.20190903.
26-02-2020 21:37:06 -0500

1 Answer

Hi, Query timeout is a parameter that is set for the connection level configuration and not for the view level. The reason it's getting replaced with *CONTEXT ('formatted' = 'yes')* is that the administration tool automatically adds this parameter when you manually edit the VQL of a derived view using the [VQL tab]( So, the *queryTimeout* parameter can be used while executing rather than while creating or altering a view. I came across these two ways to set the parameter: * Under Tools-->Admin Tool preferences-->Connection -->Query Timeout, you can set the value. * When accessing via JDBC clients, optionally the *queryTimeout *parameter can be set by setting the value in the JDBC connection URL. You may refer to [Parameters of the JDBC Connection URL]( of the Virtual DataPort Developer Guide and [CONTEXT Clause]( of the Virtual Dataport VQL guide for more information. Hope this helps!
Denodo Team
27-02-2020 07:29:05 -0500
You must sign in to add an answer. If you do not have an account, you can register here