Change of behaviour on CBP for Hive 3 with null checks against complex types

2019-10-11 Thread Eyal Ben Ivri
ave a suspicion that this is new behaviour for HIVE 3. Has anyone else noticed this behaviour, can direct me to documentation about this? Thank you, Eyal Ben Ivri

Re: ClassNotFoundException every time we run any hive query

2011-11-29 Thread Eyal B
Add it to the distributed cache add jar derby.jar; or use environment variable HIVE_AUX_JARS_PATH On Mon, Nov 28, 2011 at 1:29 PM, Ghousia wrote: > Hi Chinna, > > I have the derby.jar in the lib folder, hive runs fine and we are able to > execute the queries. Even then this error shows up in t

Re: How to generate global unique ID?

2010-11-17 Thread Eyal
Write a UDF that generates a UUID in Java something like this: @description(name = "uuid", value = "_FUNC_() - Generate a unique uuid") @SuppressWarnings({"UnusedDeclaration"}) public class Uuid extends UDF{ public Text evaluate() { return new Text(UUID.randomUUID().toString()); } } On T

hive client test fails

2010-11-14 Thread Eyal
HI, I am trying to run the odbc test in hive and I get this error *ant test -Dthrift.home=/media/sda1/thrift-0.5.0* Buildfile: build.xml check-word-size: check-thrift-home: test: [exec] LD_LIBRARY_PATH=/media/sda1/hive/build/odbc/lib:/media/sda1/thrift-0.5.0/lib:/home/ebarila/bin/jdk1.6.

Re: Hive slides from ApacheCon NA 2010

2010-11-08 Thread Eyal
Will there be a video of this talk ? On Tue, Nov 9, 2010 at 1:09 AM, John Sichi wrote: > http://www.slideshare.net/jsichi/hive-evolution-apachecon-2010 > > JVS > >

longest matching prefix

2010-11-04 Thread Eyal
Hi, In MySQL to match '12684041234' to the longest prefix I would do SELECT num_prefix FROM nums WHERE '12684041234' LIKE CONCAT(num_prefix, '%') AND LENGTH(num_prefix) = ( SELECT MAX(LENGTH(num_prefix)) FROM nums WHERE '12684041234' LIKE CONCAT(num_prefix, '%') ) ** Table nums has a column name

NOT IN query

2010-11-03 Thread Eyal
Hi, I have a table A with some values and another table B with some other values How do I get all the distinct values from A that are NOT in B e.g if table A has values 1,2,3,4,1,2,3,5,6,7 and B has values 2,3,4,5,6 then the result should be 1,7 Thanks Eyal