How to route the dateflow after executeSQL processor

[彭光裕]

Hi,
        I have a flow   like this: ExecuteSQL-->ConvertAvroSchema

       The value of SQL select query property is:
       “select hour,available,wait from TCMSV_STAT where id='${parking.id}'”

       When ExecuteSQL doesn’t find any result(${parking.id} not match 
anything), the ConvertAvroSchema will pop out an Error.

       [Error]
2016-01-14 22:41:48,697 ERROR [Timer-Driven Process Thread-2] 
o.a.nifi.processors.standard.ExecuteSQL 
ExecuteSQL[id=b9baec46-4aa5-41c2-bb08-a6c49bf1b848] Failed to process session 
due to org.apache.nifi.processor.exception.FlowFileHandlingException: 
StandardFlowFileRecord[uuid=871d1acd-3232-489b-9edb-0ded3f63f7bb,claim=,offset=0,name=54505769166005,size=0]
 transfer relationship not specified: 
org.apache.nifi.processor.exception.FlowFileHandlingException: 
StandardFlowFileRecord[uuid=871d1acd-3232-489b-9edb-0ded3f63f7bb,claim=,offset=0,name=54505769166005,size=0]
 transfer relationship not specified

     Then the rest of ExecuteSQL will be held in queue.

       My question is: how to route the dateflow after executeSQL processor 
while query doesn’t find any result? What kind of processor I should use 
between these two processors? Thank you.


Roland.

Please be advised that this email message (including any attachments) contains 
confidential information and may be legally privileged. If you are not the 
intended recipient, please destroy this message and all attachments from your 
system and do not further collect, process, or use them. Chunghwa Telecom and 
all its subsidiaries and associated companies shall not be liable for the 
improper or incomplete transmission of the information contained in this email 
nor for any delay in its receipt or damage to your system. If you are the 
intended recipient, please protect the confidential and/or personal information 
contained in this email with due care. Any unauthorized use, disclosure or 
distribution of this message in whole or in part is strictly prohibited.  Also, 
please self-inspect attachments and hyperlinks contained in this email to 
ensure the information security and to protect personal information.