Fwd: Hive Decimal did not parse value correctly when a space pre-pend the value

2016-01-17 Thread Jie Jin
Hi, all Hive decimal can correctly parse value like "1245" or "-4564". But it failed to parse " 12345" (note: there is a space before 12345). Do anyone met the same problem like this? I also test impala, impala can parse " 12345" as decimal correctly. 谢谢 金杰 (Jie Jin)

Fwd: Conversion

2016-01-17 Thread Daniel Haviv
Hi, We have a string column that represents an array of doubles that looks like this: f7 ad 3b 38 89 b7 e5 3f a1 c1 1a 74 db To parse it we use unhex(translate(signalvalues,' ','')) which returns a BINARY value. How can we convert it to ARRAY ? Thank you. Daniel