phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lalit Jadhav <lalit.jad...@nciportal.com>
Subject Searching a string in Phoenix view in all columns
Date Thu, 16 Aug 2018 04:46:37 GMT
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*

Mime
View raw message