Searching a string in Phoenix view in all columns

[Lalit Jadhav]

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 'Something%'

Note: Column names are not known.


-- 
Regards,
*Lalit Jadhav,*
*Database Group Lead.*
*Everything happens to everybody sooner or later if there is time enough*

Re: Statements caching

[Batyrshin Alexander]

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 is possible that 
the underlying HBase connection is not always left in a healthy state by the 
previous user"?

> On 28 Jul 2018, at 06:09, James Taylor  wrote:
> 
> There's no statement caching available in Phoenix. That would be a good 
> contribution, though.
> Thanks,
> James
> 
> On Thu, Jul 26, 2018 at 10:45 AM, Batyrshin Alexander <0x62...@gmail.com 
> > wrote:
>  Hi all,
> Im wondering how to enable statement caching in Phoenix JDBC Driver.
> Is there anything like "cachePrepStmts"?
>