Given a query
select category, value from someHiveTable;
I expect to output the result above of each category into one separate file
named by the corresponding category.
Any tips how to make it?
Your WHERE clause is returning 0 rows to the query. Either the filter
needs to be tweaked OR there is something wrong with your table.
Try doing a count on the table without filters to see if that works and
then maybe add filters in one by one to see where you lose results.
Abe
On Sat, May 16,
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:
>
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
