You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@tez.apache.org by Alain Petrus <al...@gmail.com> on 2014/09/05 22:42:56 UTC

MicroStrategy enabling tez through JDBC/ODBC

Hello,

We are using MicroStrategy as analytical layer. When submitting queries to hive, these are executed using MR engine only instead of Tez.  We are using in the SQL script the command “set hive.execution.engine=tez”, but this seems not to work.

Any help here would be appreciated.

Thanks,
Alain

Re: MicroStrategy enabling tez through JDBC/ODBC

Posted by Alain Petrus <al...@gmail.com>.

Thanks for your help, I will give it a try.

On 06 Sep 2014, at 04:03, May Long <lo...@gmail.com> wrote:

> That's an interesting question. I believe you might have to reconnect to HiveServer2 after setting hive.execution.engine=tez
> 
> 
> On Fri, Sep 5, 2014 at 9:15 PM, Bikas Saha <bi...@hortonworks.com> wrote:
> This question is better answered in the Hive user mailing list.
> 
> I am guessing that this configuration needs to be set up on the Hive
> Server 2 that is going to host the JDBC/ODBC end point.
> 
> Bikas
> 
> -----Original Message-----
> From: Alain Petrus [mailto:alain.petrus11@gmail.com]
> Sent: Friday, September 05, 2014 1:43 PM
> To: user@tez.apache.org
> Subject: MicroStrategy enabling tez through JDBC/ODBC
> 
> Hello,
> 
> We are using MicroStrategy as analytical layer. When submitting queries to
> hive, these are executed using MR engine only instead of Tez.  We are
> using in the SQL script the command "set hive.execution.engine=tez", but
> this seems not to work.
> 
> Any help here would be appreciated.
> 
> Thanks,
> Alain
> 
> --
> CONFIDENTIALITY NOTICE
> NOTICE: This message is intended for the use of the individual or entity to
> which it is addressed and may contain information that is confidential,
> privileged and exempt from disclosure under applicable law. If the reader
> of this message is not the intended recipient, you are hereby notified that
> any printing, copying, dissemination, distribution, disclosure or
> forwarding of this communication is strictly prohibited. If you have
> received this communication in error, please contact the sender immediately
> and delete it from your system. Thank You.
>

Re: MicroStrategy enabling tez through JDBC/ODBC

Posted by May Long <lo...@gmail.com>.

That's an interesting question. I believe you might have to *reconnect* to
HiveServer2 *after* setting hive.execution.engine=tez


On Fri, Sep 5, 2014 at 9:15 PM, Bikas Saha <bi...@hortonworks.com> wrote:

> This question is better answered in the Hive user mailing list.
>
> I am guessing that this configuration needs to be set up on the Hive
> Server 2 that is going to host the JDBC/ODBC end point.
>
> Bikas
>
> -----Original Message-----
> From: Alain Petrus [mailto:alain.petrus11@gmail.com]
> Sent: Friday, September 05, 2014 1:43 PM
> To: user@tez.apache.org
> Subject: MicroStrategy enabling tez through JDBC/ODBC
>
> Hello,
>
> We are using MicroStrategy as analytical layer. When submitting queries to
> hive, these are executed using MR engine only instead of Tez.  We are
> using in the SQL script the command "set hive.execution.engine=tez", but
> this seems not to work.
>
> Any help here would be appreciated.
>
> Thanks,
> Alain
>
> --
> CONFIDENTIALITY NOTICE
> NOTICE: This message is intended for the use of the individual or entity to
> which it is addressed and may contain information that is confidential,
> privileged and exempt from disclosure under applicable law. If the reader
> of this message is not the intended recipient, you are hereby notified that
> any printing, copying, dissemination, distribution, disclosure or
> forwarding of this communication is strictly prohibited. If you have
> received this communication in error, please contact the sender immediately
> and delete it from your system. Thank You.
>

RE: MicroStrategy enabling tez through JDBC/ODBC

Posted by Bikas Saha <bi...@hortonworks.com>.

This question is better answered in the Hive user mailing list.

I am guessing that this configuration needs to be set up on the Hive
Server 2 that is going to host the JDBC/ODBC end point.

Bikas

-----Original Message-----
From: Alain Petrus [mailto:alain.petrus11@gmail.com]
Sent: Friday, September 05, 2014 1:43 PM
To: user@tez.apache.org
Subject: MicroStrategy enabling tez through JDBC/ODBC

Hello,

We are using MicroStrategy as analytical layer. When submitting queries to
hive, these are executed using MR engine only instead of Tez.  We are
using in the SQL script the command "set hive.execution.engine=tez", but
this seems not to work.

Any help here would be appreciated.

Thanks,
Alain

-- 
CONFIDENTIALITY NOTICE
NOTICE: This message is intended for the use of the individual or entity to 
which it is addressed and may contain information that is confidential, 
privileged and exempt from disclosure under applicable law. If the reader 
of this message is not the intended recipient, you are hereby notified that 
any printing, copying, dissemination, distribution, disclosure or 
forwarding of this communication is strictly prohibited. If you have 
received this communication in error, please contact the sender immediately 
and delete it from your system. Thank You.