Re: Searching a string in Phoenix view in all columns

2018-08-16 Thread Josh Elser
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 ".."

Searching a string in Phoenix view in all columns

2018-08-15 Thread 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 'Somethin