Reply
Contributor
Posts: 40
Registered: ‎06-16-2014
Accepted Solution

hive setting in hue

I want to set "hive.mapred.mode" as "strict" for hue.

 

In the file "/etc/hive/conf/hive-site.xml", I can set hive parameters. However, it seems that this file cannot affect hue.

 

Where can I change hue's default setting?

Cloudera Employee
Posts: 717
Registered: ‎07-30-2013

Re: hive setting in hue

Which version are you using?

If you are using HiveServer2, make sure that you are editing the
hive-site.xml of the same machine.

Romain

Contributor
Posts: 40
Registered: ‎06-16-2014

Re: hive setting in hue

It's hue 2.5.0.

I tried this in a one-machine test system, and I even restarted the hue service.

It just doesn't work.
Contributor
Posts: 40
Registered: ‎06-16-2014

Re: hive setting in hue

The parameters in "/etc/hive/conf/hive-site.xml" works in hive where I use CLI, but has nothing to do with hue.

Does hue has its own configure files?
Cloudera Employee
Posts: 717
Registered: ‎07-30-2013

Re: hive setting in hue

Are you using Cloudera Manager?

Is Hue configured with Beeswax?

Romain

Contributor
Posts: 40
Registered: ‎06-16-2014

Re: hive setting in hue

Yes, I'm using Cloudera Manager.

When I say "hue", actually I mean Beeswax in hue. Sorry for my inappropriate expression.
Cloudera Employee
Posts: 717
Registered: ‎07-30-2013

Re: hive setting in hue

So you needs to insert the parameters in the Hive safety valve of Beeswax:

Beeswax Server Default Group -- > Advanced
Hive Advanced Configuration Snippet (Safety Valve)

CM overwrite the local hive-site.xml so this is the way to modify it.

Romain

Contributor
Posts: 40
Registered: ‎06-16-2014

Re: hive setting in hue

Thanks for your reply. It works.
New Contributor
Posts: 4
Registered: ‎10-20-2015

Re: hive setting in hue

Hi Romain,

 

I was trying to implement the same setting on my cluster, but could not find Hive Advanced Configuration Snippet (Safety Valve) in Hue, could you help me where to enter the configuration parameter in Cloudera Manager Ver. 5.4.0

 

hive.mapred.mode=strict

 

 

Thanks.

Highlighted
Cloudera Employee
Posts: 89
Registered: ‎07-31-2013

Re: hive setting in hue

Hue sends queries to HiveServer2, so you would want to implement it in the CM configuration for HS2, which is this safety valve in the Hive service:

HiveServer2 Advanced Configuration Snippet (Safety Valve) for hive-site.xml
Announcements