Searching a string in Phoenix view in all columns

I have a phoenix view of HBase table with n number of columns. I want to search a string consider "Foo". But it can be in any columns. (Need to scan all columns) Let me know what query I can fire to retrieve the desired outcome. For Example: SELECT * FROM DemoTable WHERE Any Column LIKE

Re: Statements caching

https://phoenix.apache.org/faq.html#Should_I_pool_Phoenix_JDBC_Connections If we should recreate connection every time then statements caching looks useless. Could you, please, explain in details what does it means "it