incubator-drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ted Dunning <>
Subject Re: Array,flatten() and binary_string() problem
Date Tue, 04 Nov 2014 16:36:30 GMT

Using a consistent quoting convention is important in these cases.  The
simplest approach in the case of drill is to convert to JSON.  There are
examples in the Drill tutorial.

On Tue, Nov 4, 2014 at 8:04 AM, Mehdi Chitforoosh <> wrote:

> Hi,
> Thank you guys for this sexy framework.I love it:-) .i tested
> phoenix,hive,...
>  Apache Drill is better beacuse of query on semi-structured data.It is my
> pleasure that contribute in this open-source. soon.
> 1.I have an array of byte[] (as generated id) (ARRAY(VARBINARY)) that can
> be nested in a hbase column .[id1,id2,....]  (each id is byte[])
> first problem : Drill seprates array elements with ',' that binary
> representation of ',' maybe conflict with id bytes .i change the ids to hex
> string like '\xAD\xFD\x34' for avoiding conflict for ',' and using
> binary_string function in Drill.
> hbase insert '\' charachter as hex '\x5c' for example id hex string
> '\xAD\xFD\x34' change to '\x5cxAD\x5cxFD\x5c34' that i can't read this
> value with binary_string.
> I want to combine flatten() function on array to get id hex string elements
> then call binary_string on elements to get varbinary and finally join on
> other table.
> do you have a suggestion?
> Thank you.
> --
> Mehdi Chitforoosh

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message