incubator-drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mehdi Chitforoosh <mehdichitforo...@gmail.com>
Subject Array,flatten() and binary_string() problem
Date Mon, 03 Nov 2014 18:58:50 GMT
Hi,

Thank you guys for this 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

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