Running a Query that Contains Spaces

["Simpson, Anne" <An...@mastercard.com>]

Hi,

I am currently using the executesql processor to run a query in oracle. We are using select as to rename the columns. In oracle you use double quotes to ingest a table name with a space, ex: select "hierarchy date" but when put into nifi it is saying that contains an invalid character. What can I do to get nifi to ingest the space?

Anne Simpson
CONFIDENTIALITY NOTICE This e-mail message and any attachments are only for the use of the intended recipient and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient, any disclosure, distribution or other use of this e-mail message or attachments is prohibited. If you have received this e-mail message in error, please delete and notify the sender immediately. Thank you.