x...@infobird.com
To unsubscribe, you need to send a message to
user-unsubscr...@hive.apache.org as described here:
http://hive.apache.org/mailing_lists.html.
-- Lefty
On Fri, Nov 7, 2014 at 12:05 AM, x...@infobird.com x...@infobird.com
wrote:
--
x...@infobird.com
Hi users,
I have hive set up at multi node hadoop cluster.
I want to run multiple queries on top of a table from different machines.
So please help how to achieve multiple access on hive to run multiple
queries simultaneously.
Thanks
Amit
I have a simple query with grouping. Something similar to bellow:
SELECT col1, col2, col3, min(date), count(*)
FROM tblX
WHERE partitionDate=20141107
GROUP BY col1, col2, col3;
When I run this query through WebHCat everything works fine. But when I try
to run it from hive shell I have
hi Amit,
Please try to see if Hive CLI (client) installed on the 'different'
machines helps you achieve your goal at the minimalist end.
If you use any other program like oozie (to submit your queries) etc. then
you can fire queries through the respective interfaces safely enough.
regards
Devopam
, 2014 at 7:56 PM, Ja Sam ptrstp...@gmail.com wrote:
I have a simple query with grouping. Something similar to bellow:
SELECT col1, col2, col3, min(date), count(*)
FROM tblX
WHERE partitionDate=20141107
GROUP BY col1, col2, col3;
When I run this query through WebHCat everything
. Something similar to bellow:
SELECT col1, col2, col3, min(date), count(*)
FROM tblX
WHERE partitionDate=20141107
GROUP BY col1, col2, col3;
When I run this query through WebHCat everything works fine. But when I
try to run it from hive shell I have error like this:
Setting job
hi Devopam,
Thank you for replying.
I am using Hue on the top of Hive. So can you please help me, how oozie
will help me and how can I integrate oozie with this.
Thanks
Amit
On Fri, Nov 7, 2014 at 7:58 PM, Devopam Mittra devo...@gmail.com wrote:
hi Amit,
Please try to see if Hive CLI
), count(*)
FROM tblX
WHERE partitionDate=20141107
GROUP BY col1, col2, col3;
When I run this query through WebHCat everything works fine. But when I
try to run it from hive shell I have error like this:
Setting job diagnostics to REDUCE capability required is more than the
supported