Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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"

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"

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"

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"

JDBC Lookup on Not Found Records

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"