Revision history [back]

How can i handle Jdbc look up if the look up field is not exist in database?

Example : table_product

|col_1   | col2    |
====================
|a       | apple   |
|b       | boy     |
|c       | cat     |


In my database and tables, these are 3 records. Hence my jdbc query will be

select col_1 , col_2 from table product where col_1 = '${record:value('/product_id')}'  If my product_id is "d", there is no matching records found, hence , streamsets now will return error stating "No Matching Record Found". In this instance, how can i handle the no matching record while using JDBC look Up? My Expected Results will be If the product_id is not found, return "NA"  2 None metadaddy 5464 ●26 ●41 ●81 https://about.me/patpa... JDBC Look Up on Not Found Records How can i handle Jdbc look up if the look up field is not exist in database? Example : table_product |col_1 | col2 | ==================== |a | apple | |b | boy | |c | cat |  In my database and tables, these are 3 records. Hence my jdbc query will be select col_1 , col_2 from table product where col_1 = '${record:value('/product_id')}'


If my product_id is "d", there is no matching records found, hence , streamsets now will return error stating "No Matching Record Found". In this instance, how can i handle the no matching record while using JDBC look Up?

My Expected Results will be If the product_id is not found, return "NA"

How can i handle Jdbc look up if the look up field is not exist in database?

Example : table_product

|col_1   | col2    |
====================
|a       | apple   |
|b       | boy     |
|c       | cat     |


In my database and tables, these are 3 records. Hence my jdbc query will be

select col_1 , col_2 from table product where col_1 = '${record:value('/product_id')}'  If my product_id is "d", there is no matching records found, hence , streamsets now will return error stating "No Matching Record Found". In this instance, how can i handle the no matching record while using JDBC look Up? My Expected Results will be If the product_id is not found, return "NA"  4 None metadaddy 5464 ●26 ●41 ●81 https://about.me/patpa... JDBC Look Up Lookup on Not Found Records How can i handle Jdbc look up JDBC lookup if the look up lookup field is does not exist in the database? Example : table_product |col_1 | col2 | ==================== |a | apple | |b | boy | |c | cat |  In my database and tables, these are 3 records. Hence my jdbc query will be select col_1 , col_2 from table product where col_1 = '${record:value('/product_id')}'


If my product_id is "d", there is no matching records found, hence , streamsets now will return error stating "No Matching Record Found". Found".

In this instance, how can i handle the no matching record while using JDBC look Up?Lookup?

My Expected Results will be If if the product_id is not found, return "NA"

How can i handle JDBC lookup if the lookup field does not exist in the database?

Example : table_product

|col_1   | col2  col_2   |
====================
|a       | apple   |
|b       | boy     |
|c       | cat     |


In my database and tables, these are 3 records. Hence my jdbc query will be

select col_1 , col_2 from table product where col_1 = '\${record:value('/product_id')}'


If my product_id is "d", there is no matching records found, hence , streamsets now will return error stating "No Matching Record Found".

In this instance, how can i handle the no matching record while using JDBC Lookup?

My Expected Results will be if the product_id is not found, return "NA"