32 PM, Gopal V wrote:
>
> On 12/3/14, 3:34 PM, Pala M Muthaia wrote:
>
>> I didn't know doAs needs to be turned off. But I don't think that is
>> something to give up - users create tables, manage data, query etc, and we
>> need the queries/jobs to run as the user
2 settings need to be in place at the time
> of starting the server.
>
> Regards
> Vikram.
>
> On Tue, Dec 2, 2014 at 2:42 PM, Hitesh Shah wrote:
> > BCC’ed user@tez.
> >
> > This question belongs to either the hive user list or the Hortonworks
> user forums.
&
:
> BCC’ed user@tez.
>
> This question belongs to either the hive user list or the Hortonworks user
> forums.
>
> thanks
> — Hitesh
>
> On Dec 2, 2014, at 1:28 PM, Pala M Muthaia
> wrote:
>
> > Hi,
> >
> > I am trying to get Tez sessions enabled wi
Hi,
I am trying to get Tez sessions enabled with HS2. I start the HiveServer2
instance with the flag "-hiveconf hive.execution.engine=tez" and then try
to submit multiple queries one after another, as the same user, to the HS2
instance.
When i check the YARN UI, i find that each query of mine is
+hive-users
On Tue, Jul 29, 2014 at 1:56 PM, Pala M Muthaia wrote:
> Hi,
>
> I am testing SMB join for 2 large tables. The tables are bucketed and
> sorted on the join column. I notice that even though the table is large,
> Hive attempts to generate hash table for the '
Adding the right hive users alias.
On Fri, May 23, 2014 at 5:52 PM, Pala M Muthaia wrote:
> Hi,
>
> I am trying to run a relatively heavy Hive query that joins 3 tables. The
> query succeeds on MR after increasing the mapper and reducer container
> memory:
>
> set mapredu
> >>> optimization to work the group bys partitioning should be on the column
> >>> 1 only.
> >>>
> >>> It wont effect the correctness of group by, can make it slow but int
> >>> this case will fasten the overall query performance.
> &g
I have attached the hive 10 and 11 query plans, for the sample query below,
for illustration.
On Fri, Aug 23, 2013 at 5:35 PM, Pala M Muthaia wrote:
> Hi,
>
> We are using DISTRIBUTE BY with custom reducer scripts in our query
> workload.
>
> After upgrade to Hive 0.11, que
Hi,
We are using DISTRIBUTE BY with custom reducer scripts in our query
workload.
After upgrade to Hive 0.11, queries with GROUP BY/DISTRIBUTE BY/SORT BY and
custom reducer scripts produced incorrect results. Particularly, rows with
same value on DISTRIBUTE BY column ends up in multiple reducers