Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

hive setting in hue

Solved Go to solution

hive setting in hue

Contributor

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?

1 ACCEPTED SOLUTION

Accepted Solutions

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

9 REPLIES 9

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

Re: hive setting in hue

Contributor
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.

Re: hive setting in hue

Contributor
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?

Re: hive setting in hue

Are you using Cloudera Manager?

Is Hue configured with Beeswax?

Romain

Re: hive setting in hue

Contributor
Yes, I'm using Cloudera Manager.

When I say "hue", actually I mean Beeswax in hue. Sorry for my inappropriate expression.

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

Re: hive setting in hue

Contributor
Thanks for your reply. It works.

Re: hive setting in hue

New Contributor

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

Re: hive setting in hue

Expert Contributor
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
Don't have an account?
Coming from Hortonworks? Activate your account here