RE: java.lang.RuntimeException: cannot find field key from [0:_col0, 1:_col2, 2:_col3]

2014-02-24 Thread java8964
My guess is that your UDTF will return an array of struct. I don't have Hive 0.10 in handy right now, but I write a simple UDTF to return an array of struct to test on Hive 0.12 release. hive> desc test;OKidint None name

Re: Mailing list/Forum

2014-02-24 Thread Alan Gates
To unsubscribe send email to user-unsubscr...@hive.apache.org Alan. On Feb 20, 2014, at 3:46 PM, Rod Asher wrote: > Good Afternoon, > > I would like to be taken off the forum and mailing list please. > > Thank you > Rod > > Rod Asher & Associates > 800-722-1030 / 206-315-6678 > www.asher.co

Re: Class not found exception from serde

2014-02-24 Thread Jason Dere
I'm assuming the jar was loaded using ADD JAR as opposed to the jar being on the classpath? On Feb 24, 2014, at 2:40 PM, Jason Dere wrote: > I think TableDesc may not be using the right class loader here when it's > trying to get the class - other parts of the code specify the class loader to

Re: Class not found exception from serde

2014-02-24 Thread Jason Dere
I think TableDesc may not be using the right class loader here when it's trying to get the class - other parts of the code specify the class loader to use but in this context it does not. I've opened https://issues.apache.org/jira/browse/HIVE-6495. On Feb 23, 2014, at 4:05 AM, Andreas Koch wr

Re: Hiveserver2 + OpenLdap Authentication issue

2014-02-24 Thread Prasad Mujumdar
What are your hive-site.xml settings of authentication and LDAP parameters ? thanks Prasad On Mon, Feb 24, 2014 at 9:40 AM, Vinod Kumar Vavilapalli wrote: > This is on the wrong mailing list, hence the non-activity. > > +user@hive > bcc:user@hadoop > > Thanks > +Vinod > > > On Feb 23, 2014

Re: ORC queries inefficient for sorted field

2014-02-24 Thread Prasanth Jayachandran
Hi Bryan ORC indexes are used only for the selection of stripes and row groups and not for answering queries. You can enable hive.compute.query.using.stats flag to answer queries using metadata. When this flag is enabled, hive metastore is checked to see if column statistics exists for the req

Re: Bug - Hive Filer Index & VARCHAR

2014-02-24 Thread Prasanth Jayachandran
Hi Bryan Yes. This is a known issue. Hive-5950 (https://issues.apache.org/jira/browse/HIVE-5950) will address it. It will soon be committed to trunk. Thanks Prasanth Jayachandran On Feb 24, 2014, at 11:21 AM, Bryan Jeffrey wrote: > All, > > I am running Hadoop 2.2.0 & Hive 0.12.0. > > Wh

Bug - Hive Filer Index & VARCHAR

2014-02-24 Thread Bryan Jeffrey
All, I am running Hadoop 2.2.0 & Hive 0.12.0. When hive.optimize.index.filter is set to true, queries against ORC tables with VARCHAR fields fail with the following errors: Error: java.io.IOException: java.lang.reflect.InvocationTargetException at org.apache.hadoop.hive.io.HiveIOExceptionHandler

Re: Hiveserver2 + OpenLdap Authentication issue

2014-02-24 Thread Vinod Kumar Vavilapalli
This is on the wrong mailing list, hence the non-activity. +user@hive bcc:user@hadoop Thanks +Vinod On Feb 23, 2014, at 10:16 PM, orahad bigdata wrote: > Can somebody help me please? > > Thanks > > > On Sun, Feb 23, 2014 at 3:27 AM, orahad bigdata wrote: > Hi Experts, > > I'm facing an

Re: java.lang.RuntimeException: cannot find field key from [0:_col0, 1:_col2, 2:_col3]

2014-02-24 Thread Kumar V
As suggested, I changed the query like this: select x.f1,x,f2,x,f3,x.f4 from ( select e.f1 as f1,e.f2 as f2,e.f3 as f3,e.f4 as f4 from mytable LATERAL VIEW myfunc(p1,p2,p3,p4) e  as f1,f2,f3,f4 where lang=123) x  where x.f3 is not null; And it still doesn't work. I am getting the same error.   I

Indexes

2014-02-24 Thread Peter Marron
Hi, I am using Hadoop 1.0.4 and Hive 0.11.0. But I've tried and have the same problems with Hive versions 10, 11, 12 and 13. I am trying to create my own indexes. As I've mentioned before (24/1/14) I have created my own class derived from TableBasedIndexHandler I copied all the methods from Com

RE: How To Change Location of Hive Log File

2014-02-24 Thread Arafat, Moiz
Thanks Matouk. Updating the hive-log4j.properties and hive-exec-log4j.properties and changing the location of hive.log.dir does work. But my question is if I am calling hive as below, Why it does not work in case of MAPJOIN . I see that in case of Mapjoin it creates a different file which goes