[resolved] Tmysqlinput: Where clause

[Anonymous]

Hi,
I am using tmysqlinput to fetch data froma table (Table 1).The data is huge and so i am getting "GC overhead limit exceeded" error. I want to use a where clause when i pull data (So that only small chunk of data is fetched). How to do this?
I want to apply a where condition on two tables. (i.e Select * from Table 1 where Table 1.a =Table 2.a)
Thanks!

[Anonymous · Accepted solution]

hi,
simply add your 'where' clause directly into sql request
regards
laurent

[Anonymous]

OK. Thanks!