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.

How to do a white list the parameter disable.quoting.for.sv

Highlighted

How to do a white list the parameter disable.quoting.for.sv

Explorer

I need to whitelist the below parameter, so that user can use it on demand

disable.quoting.for.sv

Is there any impact on adding this paramter in whitellist ?

3 REPLIES 3

Re: How to do a white list the parameter disable.quoting.for.sv

Guru

@suresh krish Is that property listed in "hive.conf.restricted.list" ?

Re: How to do a white list the parameter disable.quoting.for.sv

Explorer

It is not listed

hive.security.authenticator.manager,hive.security.authorization.manager,hive.users.in.admin.role hive.security.authorization.enabled,hive.security.authorization.manager,hive.security.authenticator.manager

Re: How to do a white list the parameter disable.quoting.for.sv

@suresh krish

There won't be any problem in adding 'disable.quoting.for.sv' to whitelist. Did you try setting system parameter at runtime and executing your query?

beeline -u 'jdbc:hive2://localhost:10000/' --outputformat=csv2 -e 'set system:disable.quoting.for.sv=false; <query>'

Don't have an account?
Coming from Hortonworks? Activate your account here