> https://github.com/apache/drill/blob/master/exec/java-exec/src/test/java/org/apache/drill/exec/physical/impl/TestConvertFunctions.java
> > >
> > > Now specifically to your three examples:
> > >
> > > > SELECT CONVERT_TO('[ [1, 2], [3, 4], [5]]
BINARY(10)) foo from (values 1000)tbl(x);
>
> I'm pretty sure that SQL doesn't allow a cast from integer to varbinary,
> thus a correct failure message.
>
> >select convert_to(x, 'INT') from (values 1000) tbl(x);
>
> The problem here is that Drill treats
you saw what format your data is
> in? Is it exactly 4 bytes, big endian?
>
>
>
> On Wed, Jul 22, 2015 at 5:34 AM, Alex Ott wrote:
> > Ok, answering my first question - I need to take the only the column name
> > into the backquotes, instead of taking the complete coordin
RE row_key
= 'AZ.OC.ICR';
++---+
|key |url|
++---+
| AZ.OC.ICR | http://RCI.CO.ZA |
++---+
On Wed, Jul 22, 2015 at 1:22 PM, Alex Ott wrote:
> Hello
>
> I'm sta
timestamp=1411476725886,
> > value=\x00\x00\x00\xC8
> > 5 row(s) in 0.0300 seconds
> >
> > But when I do query from Drill, I get some big negative number:
> >
> > 0: jdbc:drill:zk=local> select CONVERT_FROM(row_key, 'UTF8') as key,
> > CONVERT_FROM(urls.u.status, 'INT') AS statu
lect CONVERT_FROM(row_key, 'UTF8') as key,
CONVERT_FROM(urls.u.status, 'INT') AS status FROM hbase.urls WHERE row_key
= 'AZ.OC.ICR'
. . . . . . . . . . . > ;
++-+
|key | status|
++-+
| AZ.OC.ICR | -939524096 |
+----+-+
Wh