Jump to content

How to to do query push down by using TDV

Sheikh Mohammad Zohaib

Recommended Posts


Where to check if the view is pushed down to the database or not:

When you run any view in TDV, you can go check the TDV Studio -> Manager tab -> Requests panel (or) click on the 'Query execution' plan button on the view.

When we create any view in TDV and have a query in it --> execute it --> The query will be pushed down to the data source, gets executed and the data is retrieved.

But there may be some functions that are not pushed,it could be due to the fact that the data source might not support that function or TDVhas missed mapping that function, or they cannot be pushed further.

You can see the mapping in [TDV_Install_Dir]appsdlm\conf.capabilities file.

In the query plan, check what SQL you have in the FETCH node. The SQL in the FETCH node is what is pushed down to the data source.

TDV does not execute that SQL,that SQL is pushed to the data source and executes in the database and the result is returned to TDV.

Some functions or joins might not get pushed.. you would see them in the query plan. If these are not part of the FETCH node,it means these functions are applied or executed by TDV.

Sometimes, you would have no push reason messages in the query plan, explaining the reason why it could not be pushed further. Evaluate these messages and take appropriate action if needed.



Link to comment
Share on other sites

Chandrika thank you for your detailed reply. Issue is, we are reading from Hadoop system with where clause and in where clause we are reading numbers from Teradata system.


Our expectation is that Tibco will push that list of numbers to Hadoop system and fetch the result sets (assuming processing should be done within hadoop system). However in our case, tibco is reading from Teradata and reading from Hadoop and then doing processing on TDV level. 


Can you recommend some option, we have tried Data shipment option also but its not supported by TDV ,  also we have tried the cache as well.


Please help as we are stuck with this problem push down and our solution fails it doesn't work 



Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...