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-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

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