question Need a processor to test if a table sql exists and return the flowfile in Support Questions

question Need a processor to test if a table sql exists and return the flowfile in Support Questions https://community.cloudera.com/t5/Support-Questions/Need-a-processor-to-test-if-a-table-sql-exists-and-return/m-p/176555#M138805 Hello, My dataflow is as follow:My purpose is to create a table from a csv file and then put the data in this table. Everything is working good but I need to check if the table is created before storing the csv file. So I used the Execute SQL to run this query:<PRE>select count(table_name) from information_schema.tables where table_name='warranty'</PRE>But it returns only the number of rows and not the flowfile. My test is if number of row is one so I execute the rest. So I need to use dataflow which can check if the table is well created and execute the other processors if not it stop every thing. Can you help me plz I know that i can find another way but don't find ideas.Thank you for your help. <IMG src="https://community.cloudera.com/t5/image/serverpage/image-id/6355iDE7660750D9AB75A/image-size/large?v=1.0&px=999" border="0" alt="capture.png" title="capture.png" /> Fri, 29 Jun 2018 17:30:53 GMT AmiraKhalifa 2018-06-29T17:30:53Z