Answering my own question
either way the file was available via distributed cache.
it was a spelling mistake in the code for me, correcting it solved the
problem
On Sun, May 17, 2015 at 2:46 AM, Nitin Pawar
wrote:
> Hi,
>
> I am trying to access a lookup file from a udf.
> There are two ways I
Does your hive table has data? Please verify it first.
On Sat, May 16, 2015 at 8:00 PM, Daniel Haviv <
daniel.ha...@veracity-group.com> wrote:
> It seems like your query returns no results,try using count to confirm.
>
> Daniel
>
> On 16 במאי 2015, at 14:40, Anand Murali wrote:
>
> Dear All:
>
Hi,
I am trying to access a lookup file from a udf.
There are two ways I add lookup file to distribute cache
option1: loading file from local disk to distributed cache this is for hive
cli
add file tmp.txt;
option2: add a file from hdfs to distributed cache so that oozie can do it
too
add file
I have a hive script , where I call a udf .
Script works fine when called from local shell script.
But when called from within oozie workflow, it throws an exception saying
jar not found.
add jar hdfs://hdfspath of jar;
create temporary function duncname as 'pkg.className';
then on calling func
It seems like your query returns no results,try using count to confirm.
Daniel
> On 16 במאי 2015, at 14:40, Anand Murali wrote:
>
> Dear All:
>
> I am new to hive so pardon my ignorance. I have the following query but do
> not see any output. I wondered it maybe in HDFS and checked there and
try to put the query in a file called .hql don't forget to add exit! to
the bottom.
Then run it as
hive -f .hql > name.log
The output will be streamed to that file.
In general you should see both the execution and result. if you do the way I
mentioned, you would only see the result from quer
Dear All:
I am new to hive so pardon my ignorance. I have the following query but do not
see any output. I wondered it maybe in HDFS and checked there and do not find
it there. Can somebody advise
hive> select year, MAX(Temperature) from records where temperature <> and
(quality = 0 or qual
Hi Hive experts,
I am wondering if there is a way to map the explain results back to the
original script?(for example, know that which map/reduce stage are roughly
corresponding to which piece of script). Manually analyze the explain output
seems somewhat possible but I am wondering if there ar
