Re: How to query array in Hbase

2016-07-05 Thread GameboyNO1
'192.168.0.1') = > TRUE; Alfie -- Original ---------- From: Neeraja Rentachintala Date: ,7?? 5,2016 0:43 To: user@drill.apache.org Subject: Re: How to query array in Hbase You can use Convert_to/Convert_from functions with JSON encoding if it is

Re: How to query array in Hbase

2016-07-04 Thread Neeraja Rentachintala
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 <7304...@qq.com> wrote: > Hi, > > > I put an array in

How to query array in Hbase

2016-07-03 Thread GameboyNO1
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