Ask Your Question
0

How to filter data from existing fetched data?

asked 2018-01-02 01:05:02 -0500

Shruthi gravatar image

updated 2018-07-17 08:15:02 -0500

I fetched all the data using JDBC Multitable .Now a table's full data is in my hand. I want to filter few records from it may be using query. How can i filter few records from the existing data? Is there any processor to do so? Please help

Thanks in advance

edit retag flag offensive close merge delete

2 Answers

Sort by ยป oldest newest most voted
1

answered 2018-01-04 12:55:24 -0500

It's not really clear what you're trying to do. StreamSets Data Collector will pull data from your database table; the SQL query you supply specifies which rows it will retrieve. That query can join multiple tables together if necessary. See the documentation at https://streamsets.com/documentation/...

edit flag offensive delete link more

Comments

Yes JDBC Query consumer can be used to query but as an origin. My requirement is to fetch all fields from tables using origin then for the fetched data use any processor which will allow querying for filteration.I want to know that which of the available processor will be useful for this requirement

Shruthi gravatar imageShruthi ( 2018-01-04 23:21:47 -0500 )edit
0

answered 2018-07-06 05:00:21 -0500

Shruthi gravatar image

We can use JDBC Mutitable as origin and JDBC Lookup processor to query on the fetched data. For configurations refer https://streamsets.com/documentation/...

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-01-02 01:05:02 -0500

Seen: 411 times

Last updated: Jul 17