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*
