You can use Convert_to/Convert_from functions with JSON encoding if it is JSON data.
Once you can get hold of the JSON string, you can use repeated_contains to check for the existence of an element. On Sun, Jul 3, 2016 at 9:47 PM, GameboyNO1 <[email protected]> wrote: > Hi, > > > I put an array in hbase column (now in Json string, but is not necessary > if drill requires the change), is it possible I can query whether an item > is in the array? > > > For example, I put string "["192.168.0.1","192.168.0.2",...]" in a hbase > column, and want to query out rows contains 192.168.0.1 in the array. > > > Thanks! > > > Alfie
