Re: Can't access file in Distributed Cache in Hive 1.1.0

2015-06-30 Thread gabriel balan
Hi Try "set hive.fetch.task.conversion=minimal;" in hive cli to get an MR job rather than a local fetch task. hth Gabriel Balan On 6/30/2015 5:22 AM, Zsolt Tóth wrote: Thank you for your answer. The plans are identical for Hive 1.0.0 and Hive 1.1.0. You're right, Hive-1.1.0 does not start a

Re: Can't access file in Distributed Cache in Hive 1.1.0

2015-06-30 Thread Zsolt Tóth
Thank you for your answer. The plans are identical for Hive 1.0.0 and Hive 1.1.0. You're right, Hive-1.1.0 does not start a MapReduce job for the query, while Hive-1.0.0 does. Should I file a JIRA for this issue? 2015-05-07 21:17 GMT+02:00 Jason Dere : > Is this on Hive CLI, or using HiveServer

Re: Can't access file in Distributed Cache in Hive 1.1.0

2015-05-07 Thread Jason Dere
Is this on Hive CLI, or using HiveServer2? Can you run "explain select in_file('a', './testfile') from a;" from both Hive 1.0.0 and hive 1.1.0 and see if they look different? One possibile thing that might be happening here is that in Hive-1.1.0, this query is being executed without the need for

Re: Can't access file in Distributed Cache in Hive 1.1.0

2015-05-07 Thread Zsolt Tóth
Does this error occur for anyone else? It might be a serious issue. 2015-05-05 13:59 GMT+02:00 Zsolt Tóth : > Hi, > > I've just upgraded to Hive 1.1.0 and it looks like there is a problem with > the distributed cache. > I use ADD FILE, then an UDF that wants to read the file. The following > synt

Can't access file in Distributed Cache in Hive 1.1.0

2015-05-05 Thread Zsolt Tóth
Hi, I've just upgraded to Hive 1.1.0 and it looks like there is a problem with the distributed cache. I use ADD FILE, then an UDF that wants to read the file. The following syntax works in Hive 1.0.0 but Hive can't find the file in 1.1.0 (testfile exists on hdfs, the built-in udf in_file is just a