Cloudera Community
bshteinberg
user rank
New Contributor
My Accepted Solutions
Show All

Re: Hive ignores hive.security.authorization.sqlst...

by New Contributor in Support Questions
‎03-29-2016 02:58 AM
1 Kudo
‎03-29-2016 02:58 AM
1 Kudo
So, the solution is to properly define the regex list in The above definition is incorrect for myvar1. The manual states that the list has to be defined as regex, and in my case delimited by pipe. The correct value has to be "|myvar.*" (without double quotes). The ".*" may not be necessary. This custom list will then be appended to an existing whitelist. Also I had to restart all hive related services. ... View more

Hive ignores hive.security.authorization.sqlstd.co...

by New Contributor in Support Questions
‎03-26-2016 04:00 PM
1 Kudo
‎03-26-2016 04:00 PM
1 Kudo
I have a problem with running HQL scripts where I need to set user defined variables at run-time. Any kind of statement like "set myvar=1" I get an exception "Cannot modify myvar1 at runtime. It is not in list of params that are allowed to be modified at runtime". So, I went and whitelisted this variable as per hive manual in Hive custom site. Restarted all affected services, tried again just to see the same error. I can however assign values to variables which are already whitelisted. Environment: off the shelf HDP 2.3.2 sandbox running on vmware esxi 5.5 Any clues? ... View more
Labels:
Contact Me
Online
Offline
Last Visited
‎04-05-2016 05:08 PM
Community Statistics
Member Since ‎03-26-2016 12:10 PM
Last Visited ‎04-05-2016 05:08 PM
Posts 2
Kudos received 2