implementing a UDF

2011-02-25 Thread Igor Tatarinov
I am trying to implement a simple UDF but that doesn't seem to work for some reason. It looks like Hive is not able to cast the arguments to the right type. select price, mavg(0, price, 2) from prices limit 1; FAILED: Error in semantic analysis: line 1:14 Wrong Arguments 2: No matching method for

Re: TOAD for hive

2011-02-25 Thread Otis Gospodnetic
Hi, I've had a quick look at Toad for Cloud the other day, too. * One complaint I heard (but have not verified) is that it crashed. I don't have the details. Anyone seen any crashes? * The other "complaint" I heard is that just like it allows easy querying, it allows the person using it easy

Re: Thrift Java Client - TTransportException (SocketException: Connection reset)

2011-02-25 Thread Ning Zhang
I tried on the latest trunk (through CLI connecting to Hive Server) and there is no disconnection after 10 mins for a long query. @Ayush, is this Java client using JDBC connection? If so the client may have set a timeout for JDBC queries. I'm suspecting the disconnection is from the Java client

HiveODBC build error

2011-02-25 Thread Paul Trout
25 Feb 2011 We're interested in using the HiveODBC interface, so I've been trying to build it. I'm using Hadoop 0.20.2+320, from Cloudera, with Hive 0.7.0CDH3B4. Initially I was trying this with Hive 0.5.0+32, but we intend to upgrade to CDH3B4 very soon, so I decided to try with the newer ve