SQL doesn't work like this.
You can use the DatabaseMetaData class, obtained off of the JDBC
Connection class, to inspect the available columns for a query. However,
I'd caution you against constructing a massive disjunction, e.g.
select * from demotable where colA like ".." or colB like ".."
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 'Somethin