It seems like your query returns no results,try using count to confirm.
Daniel
On 16 במאי 2015, at 14:40, Anand Murali anand_vi...@yahoo.com 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
try to put the query in a file called name.hql don't forget to add exit! to
the bottom.
Then run it as
hive -f name.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
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
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 anand_vi...@yahoo.com 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 do not find
it there. Can somebody advise
hive select year, MAX(Temperature) from records where temperature and
(quality = 0 or
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 nitinpawar...@gmail.com
wrote:
Hi,
I am trying to access a lookup file from a udf.
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