You can translate the question and the replies:

Error using multiple inner joins

Hi Community I'm facing an error with vdp, when using joins. I'm working on a view using 28 inner joins, at 25th join everything works fine, but when i add the 26th table to join with i have the following error : Finished with error: Error executing query. Total time 20.979 seconds. JOIN_4_TEST [VIRTUAL] [ERROR] JOIN_4_TEST [JDBC WRAPPER] [ERROR] JOIN_4_TEST#0 [JDBC ROUTE] [ERROR] Received exception with message 'org.apache.thrift.transport.TTransportException: HTTP Response code: 500'
user
18-01-2021 17:08:10 -0500

1 Answer

Hi, I was able to perform an inner join using 28 views in my environment, it worked fine for me without any errors. In this situation, I would perform the following checks in order to get more information. * Check the server logs in the data source side * Check the Execution Trace under the Query Results tab of the join view * Check the vdp.log file located under the directory <DENODO_HOME>/logs/vdp In the Execution Trace, you may look for the errors that will help you to understand this issue. I found the relevant info in the following user manual. * [Execution Trace of a Statement](https://community.denodo.com/docs/html/browse/8.0/vdp/administration/creating_derived_views/querying_views/execution_trace_of_a_statement) Hope this helps!
Denodo Team
19-01-2021 04:53:30 -0500
You must sign in to add an answer. If you do not have an account, you can register here