hue.ini 78 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288
  1. # Hue configuration file
  2. # ===================================
  3. #
  4. # For complete documentation about the contents of this file, check
  5. # https://docs.gethue.com/administrator/configuration/
  6. #
  7. # All .ini files under the current directory are treated equally. Their
  8. # contents are merged to form the Hue configuration, which can
  9. # can be viewed on the Hue at
  10. # http://<hue_host>:<port>/dump_config
  11. ###########################################################################
  12. # General configuration for API (authentication, etc)
  13. ###########################################################################
  14. [desktop]
  15. # Set this to a random string, the longer the better.
  16. # This is used for secure hashing in the session store.
  17. secret_key=
  18. # Execute this script to produce the Django secret key. This will be used when
  19. # 'secret_key' is not set.
  20. ## secret_key_script=
  21. # Webserver listens on this address and port
  22. http_host=0.0.0.0
  23. http_port=8888
  24. # A comma-separated list of available Hue load balancers
  25. ## hue_load_balancer=
  26. # Time zone name
  27. time_zone=America/Los_Angeles
  28. # Enable or disable debug mode.
  29. django_debug_mode=false
  30. # Enable development mode, where notably static files are not cached.
  31. ## dev=false
  32. # Enable or disable database debug mode.
  33. ## database_logging=false
  34. # Whether to send debug messages from JavaScript to the server logs.
  35. ## send_dbug_messages=false
  36. # Enable or disable backtrace for server error
  37. http_500_debug_mode=false
  38. # Enable or disable instrumentation. If django_debug_mode is True, this is automatically enabled
  39. ## instrumentation=false
  40. # Server email for internal error messages
  41. ## django_server_email='hue@localhost.localdomain'
  42. # Email backend
  43. ## django_email_backend=django.core.mail.backends.smtp.EmailBackend
  44. # Set to true to use CherryPy as the webserver, set to false
  45. # to use Gunicorn as the webserver. Defaults to CherryPy if
  46. # key is not specified.
  47. ## use_cherrypy_server=true
  48. # Gunicorn work class: gevent or evenlet, gthread or sync.
  49. ## gunicorn_work_class=eventlet
  50. # The number of Gunicorn worker processes. If not specified, it uses: (number of CPU * 2) + 1.
  51. ## gunicorn_number_of_workers=1
  52. # Webserver runs as this user
  53. ## server_user=hue
  54. ## server_group=hue
  55. # This should be the Hue admin and proxy user
  56. ## default_user=hue
  57. # This should be the hadoop cluster admin
  58. ## default_hdfs_superuser=hdfs
  59. # If set to false, runcpserver will not actually start the web server.
  60. # Used if Apache is being used as a WSGI container.
  61. ## enable_server=yes
  62. # Number of threads used by the CherryPy web server
  63. ## cherrypy_server_threads=50
  64. # This property specifies the maximum size of the receive buffer in bytes in thrift sasl communication,
  65. # default value is 2097152 (2 MB), which equals to (2 * 1024 * 1024)
  66. ## sasl_max_buffer=2097152
  67. # Hue will try to get the actual host of the Service, even if it resides behind a load balancer.
  68. # This will enable an automatic configuration of the service without requiring custom configuration of the service load balancer.
  69. # This is available for the Impala service only currently. It is highly recommended to only point to a series of coordinator-only nodes only.
  70. # enable_smart_thrift_pool=false
  71. # Limits for request headers
  72. ## limit_request_field_size=8190
  73. ## limit_request_fields=100
  74. ## limit_request_line=4094
  75. # Filename of SSL Certificate
  76. ## ssl_certificate=
  77. # Filename of SSL RSA Private Key
  78. ## ssl_private_key=
  79. # Filename of SSL Certificate Chain
  80. ## ssl_certificate_chain=
  81. # SSL certificate password
  82. ## ssl_password=
  83. # Execute this script to produce the SSL password. This will be used when 'ssl_password' is not set.
  84. ## ssl_password_script=
  85. # Disable all renegotiation in TLSv1.2 and earlier. Do not send HelloRequest messages, and ignore renegotiation requests via ClientHello. This option is only available with OpenSSL 1.1.0h and later and python 3.7
  86. ## ssl_no_renegotiation=python.version >= 3.7
  87. # X-Content-Type-Options: nosniff This is a HTTP response header feature that helps prevent attacks based on MIME-type confusion.
  88. ## secure_content_type_nosniff=true
  89. # X-Xss-Protection: \"1; mode=block\" This is a HTTP response header feature to force XSS protection.
  90. ## secure_browser_xss_filter=true
  91. # X-Content-Type-Options: nosniff This is a HTTP response header feature that helps prevent attacks based on MIME-type confusion.
  92. ## secure_content_security_policy="script-src 'self' 'unsafe-inline' 'unsafe-eval' *.googletagmanager.com *.doubleclick.net data:;img-src 'self' *.doubleclick.net http://*.tile.osm.org *.tile.osm.org *.gstatic.com data:;style-src 'self' 'unsafe-inline' fonts.googleapis.com;connect-src 'self' *.google-analytics.com;frame-src *;child-src 'self' data: *.vimeo.com;object-src 'none'"
  93. # Strict-Transport-Security HTTP Strict Transport Security(HSTS) is a policy which is communicated by the server to the user agent via HTTP response header field name "Strict-Transport-Security". HSTS policy specifies a period of time during which the user agent(browser) should only access the server in a secure fashion(https).
  94. ## secure_ssl_redirect=False
  95. ## secure_redirect_host=0.0.0.0
  96. ## secure_redirect_exempt=[]
  97. ## secure_hsts_seconds=31536000
  98. ## secure_hsts_include_subdomains=true
  99. # List of allowed and disallowed ciphers in cipher list format.
  100. # See http://www.openssl.org/docs/apps/ciphers.html for more information on
  101. # cipher list format. This list is from
  102. # https://wiki.mozilla.org/Security/Server_Side_TLS v3.7 intermediate
  103. # recommendation, which should be compatible with Firefox 1, Chrome 1, IE 7,
  104. # Opera 5 and Safari 1.
  105. ## ssl_cipher_list=ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES256-GCM-SHA384:DHE-RSA-AES128-GCM-SHA256:DHE-DSS-AES128-GCM-SHA256:kEDH+AESGCM:ECDHE-RSA-AES128-SHA256:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES256-SHA384:ECDHE-ECDSA-AES256-SHA384:ECDHE-RSA-AES256-SHA:ECDHE-ECDSA-AES256-SHA:DHE-RSA-AES128-SHA256:DHE-RSA-AES128-SHA:DHE-DSS-AES128-SHA256:DHE-RSA-AES256-SHA256:DHE-DSS-AES256-SHA:DHE-RSA-AES256-SHA:AES128-GCM-SHA256:AES256-GCM-SHA384:AES128-SHA256:AES256-SHA256:AES128-SHA:AES256-SHA:AES:CAMELLIA:DES-CBC3-SHA:!aNULL:!eNULL:!EXPORT:!DES:!RC4:!MD5:!PSK:!aECDH:!EDH-DSS-DES-CBC3-SHA:!EDH-RSA-DES-CBC3-SHA:!KRB5-DES-CBC3-SHA
  106. # Path to default Certificate Authority certificates.
  107. ## ssl_cacerts=/etc/hue/cacerts.pem
  108. # Choose whether Hue should validate certificates received from the server.
  109. ## ssl_validate=true
  110. # Default LDAP/PAM/.. username and password of the hue user used for authentications with other services.
  111. # Inactive if password is empty.
  112. # e.g. LDAP pass-through authentication for HiveServer2 or Impala. Apps can override them individually.
  113. ## auth_username=hue
  114. ## auth_password=
  115. # Default encoding for site data
  116. ## default_site_encoding=utf-8
  117. # Help improve Hue with anonymous usage analytics.
  118. # Use Google Analytics to see how many times an application or specific section of an application is used, nothing more.
  119. ## collect_usage=true
  120. ## gtag_id='G-25K7599S1Q'
  121. # Tile layer server URL for the Leaflet map charts
  122. # Read more on http://leafletjs.com/reference.html#tilelayer
  123. # Make sure you add the tile domain to the img-src section of the 'secure_content_security_policy' configuration parameter as well.
  124. ## leaflet_tile_layer=http://{s}.tile.osm.org/{z}/{x}/{y}.png
  125. # The copyright message for the specified Leaflet maps Tile Layer
  126. ## leaflet_tile_layer_attribution='&copy; <a href="http://osm.org/copyright">OpenStreetMap</a> contributors'
  127. # All the map options accordingly to http://leafletjs.com/reference-0.7.7.html#map-options
  128. # To change CRS, just use the name, ie. "EPSG4326"
  129. ## leaflet_map_options='{}'
  130. # All the tile layer options, accordingly to http://leafletjs.com/reference-0.7.7.html#tilelayer
  131. ## leaflet_tile_layer_options='{}'
  132. # X-Frame-Options HTTP header value. Use 'DENY' to deny framing completely
  133. ## http_x_frame_options=SAMEORIGIN
  134. # Enable X-Forwarded-Host header if the load balancer requires it.
  135. ## use_x_forwarded_host=true
  136. # Support for HTTPS termination at the load-balancer level with SECURE_PROXY_SSL_HEADER.
  137. ## secure_proxy_ssl_header=false
  138. # Comma-separated list of Django middleware classes to use.
  139. # See https://docs.djangoproject.com/en/1.4/ref/middleware/ for more details on middlewares in Django.
  140. ## middleware=desktop.auth.backend.LdapSynchronizationBackend
  141. # Comma-separated list of regular expressions, which match the redirect URL.
  142. # For example, to restrict to your local domain and FQDN, the following value can be used:
  143. # ^\/.*$,^http:\/\/www.mydomain.com\/.*$
  144. ## redirect_whitelist=^(\/[a-zA-Z0-9]+.*|\/)$
  145. # Comma separated list of apps to not load at server startup.
  146. # e.g.: pig,zookeeper
  147. ## app_blacklist=
  148. # Id of the cluster where Hue is located.
  149. ## cluster_id='default'
  150. # Choose whether to show the new SQL editor.
  151. ## use_new_editor=true
  152. # Global setting to allow or disable end user downloads in all Hue.
  153. # e.g. Query result in Editors and Dashboards, file in File Browser...
  154. ## enable_download=true
  155. # Global setting to enable or disable document sharing.
  156. # Note that this does not affect currently shared documents.
  157. ## enable_sharing=true
  158. # Choose whether to enable SQL syntax check or not
  159. ## enable_sql_syntax_check=true
  160. # Choose whether to use new charting library across the whole Hue.
  161. ## use_new_charts=false
  162. # Choose whether to allow multi tenancy or not.
  163. ## enable_organizations=false
  164. # Editor autocomplete timeout (ms) when fetching columns, fields, tables etc.
  165. # To disable this type of autocompletion set the value to 0.
  166. ## editor_autocomplete_timeout=30000
  167. # Enable saved default configurations for Hive, Impala, Spark, and Oozie.
  168. ## use_default_configuration=false
  169. # The directory where to store the auditing logs. Auditing is disable if the value is empty.
  170. # e.g. /var/log/hue/audit.log
  171. ## audit_event_log_dir=
  172. # Size in KB/MB/GB for audit log to rollover.
  173. ## audit_log_max_file_size=100MB
  174. # Timeout in seconds for REST calls.
  175. ## rest_conn_timeout=120
  176. # A json file containing a list of log redaction rules for cleaning sensitive data
  177. # from log files. It is defined as:
  178. #
  179. # {
  180. # "version": 1,
  181. # "rules": [
  182. # {
  183. # "description": "This is the first rule",
  184. # "trigger": "triggerstring 1",
  185. # "search": "regex 1",
  186. # "replace": "replace 1"
  187. # },
  188. # {
  189. # "description": "This is the second rule",
  190. # "trigger": "triggerstring 2",
  191. # "search": "regex 2",
  192. # "replace": "replace 2"
  193. # }
  194. # ]
  195. # }
  196. #
  197. # Redaction works by searching a string for the [TRIGGER] string. If found,
  198. # the [REGEX] is used to replace sensitive information with the
  199. # [REDACTION_MASK]. If specified with 'log_redaction_string', the
  200. # 'log_redaction_string' rules will be executed after the
  201. # 'log_redaction_file' rules.
  202. #
  203. # For example, here is a file that would redact passwords and social security numbers:
  204. # {
  205. # "version": 1,
  206. # "rules": [
  207. # {
  208. # "description": "Redact passwords",
  209. # "trigger": "password",
  210. # "search": "password=\".*\"",
  211. # "replace": "password=\"???\""
  212. # },
  213. # {
  214. # "description": "Redact social security numbers",
  215. # "trigger": "",
  216. # "search": "\d{3}-\d{2}-\d{4}",
  217. # "replace": "XXX-XX-XXXX"
  218. # }
  219. # ]
  220. # }
  221. ## log_redaction_file=
  222. # Comma separated list of strings representing the host/domain names that the Hue server can serve.
  223. # e.g.: localhost,domain1,*
  224. ## allowed_hosts="*"
  225. # Number of characters in rest api reponse calls to dump to the logs when debug is enabled. Set to -1 for entire response.
  226. ## rest_response_size=2000
  227. # Turn on Prometheus metrics end point /metrics.
  228. ## enable_prometheus=false
  229. # Turn on the Gist snippet sharing.
  230. ## enable_gist=true
  231. # Add public description so that the link can be unfurled in a preview by websites like Slack.
  232. # Only enabled automatically in private setups.
  233. ## enable_gist_preview=true
  234. # Turn on the direct link sharing of saved document.
  235. ## enable_link_sharing=true
  236. # Use JWT as Bearer header for authentication when using Thrift over HTTP transport.
  237. ## use_thrift_http_jwt=false
  238. # Hue uses Localstorage to keep the users settings and database preferences.
  239. # Please make this value true in case local storage should not be used
  240. # default value is false
  241. ## disable_local_storage = false
  242. # Administrators
  243. # ----------------
  244. [[django_admins]]
  245. ## [[[admin1]]]
  246. ## name=john
  247. ## email=john@doe.com
  248. # UI customizations
  249. # -------------------
  250. [[custom]]
  251. # Top banner HTML code
  252. # e.g. <H4>Test Lab A2 Hue Services</H4>
  253. ## banner_top_html='<div style="padding: 4px; text-align: center; background-color: #003F6C; color: #DBE8F1">This is Hue 4 Beta! - Please feel free to email any feedback / questions to <a href="mailto:team@gethue.com" target="_blank" style="color: #FFF; font-weight: bold">team@gethue.com</a> or <a href="https://twitter.com/gethue" target="_blank" style="color: #FFF; font-weight: bold">@gethue</a>.</div>'
  254. # Login splash HTML code
  255. # e.g. WARNING: You are required to have authorization before you proceed
  256. ## login_splash_html=<h4>GetHue.com</h4><br/><br/>WARNING: You have accessed a computer managed by GetHue. You are required to have authorization from GetHue before you proceed.
  257. # Cache timeout in milliseconds for the assist, autocomplete, etc.
  258. # defaults to 10 days, set to 0 to disable caching
  259. ## cacheable_ttl=864000000
  260. # SVG code to replace the default Hue logo in the top bar and sign in screen
  261. # e.g. <image xlink:href="/static/desktop/art/hue-logo-mini-white.png" x="0" y="0" height="40" width="160" />
  262. ## logo_svg=
  263. # Configuration options for user authentication into the web application
  264. # ------------------------------------------------------------------------
  265. [[auth]]
  266. # Authentication backend. Common settings are:
  267. # - desktop.auth.backend.AllowFirstUserDjangoBackend
  268. # (Default. Fist login becomes and admin, then relies on user accounts)
  269. # - django.contrib.auth.backends.ModelBackend (entirely Django backend)
  270. # - desktop.auth.backend.AllowAllBackend (allows everyone)
  271. # - desktop.auth.backend.LdapBackend
  272. # - desktop.auth.backend.PamBackend
  273. # - desktop.auth.backend.SpnegoDjangoBackend
  274. # - desktop.auth.backend.KnoxSpnegoDjangoBackend
  275. # - desktop.auth.backend.RemoteUserDjangoBackend
  276. # - libsaml.backend.SAML2Backend
  277. # - desktop.auth.backend.OIDCBackend (New oauth, support Twitter, Facebook, Google+ and Linkedin
  278. # Multiple Authentication backend combinations are supported by specifying a comma-separated list in order of priority.
  279. ## backend=desktop.auth.backend.AllowFirstUserDjangoBackend
  280. # Multiple Authentication backends for REST APIs are supported by specifying a comma-separated list in order of priority.
  281. ## api_auth=rest_framework_simplejwt.authentication.JWTAuthentication,rest_framework.authentication.SessionAuthentication
  282. # Class which defines extra accessor methods for User objects.
  283. ## user_aug=desktop.auth.backend.DefaultUserAugmentor
  284. # The service to use when querying PAM.
  285. ## pam_service=login
  286. # To use Python unix pwd module to get the username from the entered credentials in Hue if Centrify like PAM service is in use.
  287. # This will set the username to what is being returned by the pwd module.
  288. ## pam_use_pwd_module=false
  289. # When using the desktop.auth.backend.RemoteUserDjangoBackend, this sets
  290. # the normalized name of the header that contains the remote user.
  291. # The HTTP header in the request is converted to a key by converting
  292. # all characters to uppercase, replacing any hyphens with underscores
  293. # and adding an HTTP_ prefix to the name. So, for example, if the header
  294. # is called Remote-User that would be configured as HTTP_REMOTE_USER
  295. #
  296. # Defaults to HTTP_REMOTE_USER
  297. ## remote_user_header=HTTP_REMOTE_USER
  298. # Ignore the case of usernames when searching for existing users.
  299. # Supported in remoteUserDjangoBackend and SpnegoDjangoBackend
  300. ## ignore_username_case=true
  301. # Forcibly cast usernames to lowercase, takes precedence over force_username_uppercase
  302. # Supported in remoteUserDjangoBackend and SpnegoDjangoBackend
  303. ## force_username_lowercase=true
  304. # Forcibly cast usernames to uppercase, cannot be combined with force_username_lowercase
  305. ## force_username_uppercase=false
  306. # Users will expire after they have not logged in for 'n' amount of seconds.
  307. # A negative number means that users will never expire.
  308. ## expires_after=-1
  309. # Apply 'expires_after' to superusers.
  310. ## expire_superusers=true
  311. # Users will automatically be logged out after 'n' seconds of inactivity.
  312. # A negative number means that idle sessions will not be timed out.
  313. idle_session_timeout=-1
  314. # Force users to change password on first login with desktop.auth.backend.AllowFirstUserDjangoBackend
  315. ## change_default_password=false
  316. # Number of login attempts allowed before a record is created for failed logins
  317. ## login_failure_limit=3
  318. # After number of allowed login attempts are exceeded, do we lock out this IP and optionally user agent?
  319. ## login_lock_out_at_failure=false
  320. # If set, defines period of inactivity in hours after which failed logins will be forgotten.
  321. # A value of 0 or None will disable this check. Default: None
  322. ## login_cooloff_time=None
  323. # If True, lock out based on an IP address AND a user agent.
  324. # This means requests from different user agents but from the same IP are treated differently.
  325. ## login_lock_out_use_user_agent=false
  326. # If True, lock out based on IP and user
  327. ## login_lock_out_by_combination_user_and_ip=false
  328. # If True, it will look for the IP address from the header defined at reverse_proxy_header.
  329. ## behind_reverse_proxy=false
  330. # If behind_reverse_proxy is True, it will look for the IP address from this header. Default: HTTP_X_FORWARDED_FOR
  331. ## reverse_proxy_header=HTTP_X_FORWARDED_FOR
  332. [[[jwt]]]
  333. # Adds custom JWT Authentication backend for REST APIs in top priority.
  334. ## is_enabled=false
  335. # Endpoint to fetch the public key from verification server.
  336. ## key_server_url=https://ext_authz:8000
  337. # The identifier of the service issued the JWT
  338. ## issuer=None
  339. # The identifier of the resource intend to access
  340. ## audience=None
  341. # Verify custom JWT signature.
  342. ## verify=true
  343. # Configuration options for connecting to LDAP and Active Directory
  344. # -------------------------------------------------------------------
  345. [[ldap]]
  346. # The search base for finding users and groups
  347. ## base_dn="DC=mycompany,DC=com"
  348. # URL of the LDAP server
  349. ## ldap_url=ldap://auth.mycompany.com
  350. # The NT domain used for LDAP authentication
  351. ## nt_domain=mycompany.com
  352. # A PEM-format file containing certificates for the CA's that
  353. # Hue will trust for authentication over TLS.
  354. # The certificate for the CA that signed the
  355. # LDAP server certificate must be included among these certificates.
  356. # See more here http://www.openldap.org/doc/admin24/tls.html.
  357. ## ldap_cert=
  358. ## use_start_tls=true
  359. # Distinguished name of the user to bind as -- not necessary if the LDAP server
  360. # supports anonymous searches
  361. ## bind_dn="CN=ServiceAccount,DC=mycompany,DC=com"
  362. # Password of the bind user -- not necessary if the LDAP server supports
  363. # anonymous searches
  364. ## bind_password=
  365. # Execute this script to produce the bind user password. This will be used
  366. # when 'bind_password' is not set.
  367. ## bind_password_script=
  368. # Pattern for searching for usernames -- Use <username> for the parameter
  369. # For use when using LdapBackend for Hue authentication
  370. ## ldap_username_pattern="uid=<username>,ou=People,dc=mycompany,dc=com"
  371. # Create users in Hue when they try to login with their LDAP credentials
  372. # For use when using LdapBackend for Hue authentication
  373. ## create_users_on_login = true
  374. # Synchronize a users groups when they login
  375. ## sync_groups_on_login=true
  376. # A comma-separated list of Ldap groups with users that can login
  377. ## login_groups=
  378. # Ignore the case of usernames when searching for existing users in Hue.
  379. ## ignore_username_case=true
  380. # Force usernames to lowercase when creating new users from LDAP.
  381. # Takes precedence over force_username_uppercase
  382. ## force_username_lowercase=true
  383. # Force usernames to uppercase, cannot be combined with force_username_lowercase
  384. ## force_username_uppercase=false
  385. # Use search bind authentication.
  386. ## search_bind_authentication=true
  387. # Choose which kind of subgrouping to use: nested or suboordinate (deprecated).
  388. ## subgroups=suboordinate
  389. # Define the number of levels to search for nested members.
  390. ## nested_members_search_depth=10
  391. # Whether or not to follow referrals
  392. ## follow_referrals=false
  393. # Enable python-ldap debugging.
  394. ## debug=false
  395. # Sets the debug level within the underlying LDAP C lib.
  396. ## debug_level=255
  397. # Possible values for trace_level are 0 for no logging, 1 for only logging the method calls with arguments,
  398. # 2 for logging the method calls with arguments and the complete results and 9 for also logging the traceback of method calls.
  399. ## trace_level=0
  400. [[[users]]]
  401. # Base filter for searching for users
  402. ## user_filter="objectclass=*"
  403. # The username attribute in the LDAP schema
  404. ## user_name_attr=sAMAccountName
  405. [[[groups]]]
  406. # Base filter for searching for groups
  407. ## group_filter="objectclass=*"
  408. # The group name attribute in the LDAP schema
  409. ## group_name_attr=cn
  410. # The attribute of the group object which identifies the members of the group
  411. ## group_member_attr=members
  412. [[[ldap_servers]]]
  413. ## [[[[mycompany]]]]
  414. # The search base for finding users and groups
  415. ## base_dn="DC=mycompany,DC=com"
  416. # URL of the LDAP server
  417. ## ldap_url=ldap://auth.mycompany.com
  418. # The NT domain used for LDAP authentication
  419. ## nt_domain=mycompany.com
  420. # A PEM-format file containing certificates for the CA's that
  421. # Hue will trust for authentication over TLS.
  422. # The certificate for the CA that signed the
  423. # LDAP server certificate must be included among these certificates.
  424. # See more here http://www.openldap.org/doc/admin24/tls.html.
  425. ## ldap_cert=
  426. ## use_start_tls=true
  427. # Distinguished name of the user to bind as -- not necessary if the LDAP server
  428. # supports anonymous searches
  429. ## bind_dn="CN=ServiceAccount,DC=mycompany,DC=com"
  430. # Password of the bind user -- not necessary if the LDAP server supports
  431. # anonymous searches
  432. ## bind_password=
  433. # Execute this script to produce the bind user password. This will be used
  434. # when 'bind_password' is not set.
  435. ## bind_password_script=
  436. # Pattern for searching for usernames -- Use <username> for the parameter
  437. # For use when using LdapBackend for Hue authentication
  438. ## ldap_username_pattern="uid=<username>,ou=People,dc=mycompany,dc=com"
  439. ## Use search bind authentication.
  440. ## search_bind_authentication=true
  441. # Whether or not to follow referrals
  442. ## follow_referrals=false
  443. # Enable python-ldap debugging.
  444. ## debug=false
  445. # Sets the debug level within the underlying LDAP C lib.
  446. ## debug_level=255
  447. # Possible values for trace_level are 0 for no logging, 1 for only logging the method calls with arguments,
  448. # 2 for logging the method calls with arguments and the complete results and 9 for also logging the traceback of method calls.
  449. ## trace_level=0
  450. ## [[[[[users]]]]]
  451. # Base filter for searching for users
  452. ## user_filter="objectclass=Person"
  453. # The username attribute in the LDAP schema
  454. ## user_name_attr=sAMAccountName
  455. ## [[[[[groups]]]]]
  456. # Base filter for searching for groups
  457. ## group_filter="objectclass=groupOfNames"
  458. # The username attribute in the LDAP schema
  459. ## group_name_attr=cn
  460. # Configuration options for specifying the Source Version Control.
  461. # ----------------------------------------------------------------
  462. [[vcs]]
  463. ## [[[git-read-only]]]
  464. ## Base URL to Remote Server
  465. # remote_url=https://github.com/cloudera/hue/tree/master
  466. ## Base URL to Version Control API
  467. # api_url=https://api.github.com
  468. ## [[[github]]]
  469. ## Base URL to Remote Server
  470. # remote_url=https://github.com/cloudera/hue/tree/master
  471. ## Base URL to Version Control API
  472. # api_url=https://api.github.com
  473. # These will be necessary when you want to write back to the repository.
  474. ## Client ID for Authorized Application
  475. # client_id=
  476. ## Client Secret for Authorized Application
  477. # client_secret=
  478. ## [[[svn]]
  479. ## Base URL to Remote Server
  480. # remote_url=https://github.com/cloudera/hue/tree/master
  481. ## Base URL to Version Control API
  482. # api_url=https://api.github.com
  483. # These will be necessary when you want to write back to the repository.
  484. ## Client ID for Authorized Application
  485. # client_id=
  486. ## Client Secret for Authorized Application
  487. # client_secret=
  488. # Configuration options for specifying the Desktop Database. For more info,
  489. # see http://docs.djangoproject.com/en/1.11/ref/settings/#database-engine
  490. # ------------------------------------------------------------------------
  491. [[database]]
  492. # Database engine is typically one of:
  493. # postgresql_psycopg2, mysql, sqlite3 or oracle.
  494. #
  495. # Note that for sqlite3, 'name', below is a path to the filename. For other backends, it is the database name
  496. # Note for Oracle, options={"threaded":true} must be set in order to avoid crashes.
  497. # Note for Oracle, you can use the Oracle Service Name by setting "host=" and "port=" and then "name=<host>:<port>/<service_name>".
  498. # Note for MariaDB use the 'mysql' engine.
  499. ## engine=sqlite3
  500. ## host=
  501. ## port=
  502. ## user=
  503. ## password=
  504. # conn_max_age option to make database connection persistent value in seconds
  505. # https://docs.djangoproject.com/en/1.11/ref/databases/#persistent-connections
  506. ## conn_max_age=0
  507. # Execute this script to produce the database password. This will be used when 'password' is not set.
  508. ## password_script=/path/script
  509. ## name=desktop/desktop.db
  510. ## options={}
  511. # Database schema, to be used only when public schema is revoked in postgres
  512. ## schema=public
  513. # Configuration options for specifying the Desktop session.
  514. # For more info, see https://docs.djangoproject.com/en/1.4/topics/http/sessions/
  515. # ------------------------------------------------------------------------
  516. [[session]]
  517. # The name of the cookie to use for sessions.
  518. # This can have any value that is not used by the other cookie names in your application.
  519. ## cookie_name=sessionid
  520. # Configuration to determine whether test cookie should be added determine whether the user's browser supports cookies
  521. # Should be disabled if django_session table is growing rapidly , Default value is true
  522. ## enable_test_cookie=true
  523. # The cookie containing the users' session ID will expire after this amount of time in seconds.
  524. # Default is 2 weeks.
  525. ## ttl=1209600
  526. # The cookie containing the users' session ID and csrf cookie will be secure.
  527. # Should only be enabled with HTTPS.
  528. ## secure=false
  529. # The cookie containing the users' session ID and csrf cookie will use the HTTP only flag.
  530. ## http_only=true
  531. # Use session-length cookies. Logs out the user when she closes the browser window.
  532. ## expire_at_browser_close=false
  533. # If set, limits the number of concurrent user sessions. 1 represents 1 browser session per user. Default: 0 (unlimited sessions per user)
  534. ## concurrent_user_session_limit=0
  535. # A list of hosts which are trusted origins for unsafe requests. See django's CSRF_TRUSTED_ORIGINS for more information
  536. ## trusted_origins=.cloudera.com
  537. # Configuration options for connecting to an external SMTP server
  538. # ------------------------------------------------------------------------
  539. [[smtp]]
  540. # The SMTP server information for email notification delivery
  541. host=localhost
  542. port=25
  543. user=
  544. password=
  545. # Whether to use a TLS (secure) connection when talking to the SMTP server
  546. tls=no
  547. # Default email address to use for various automated notification from Hue
  548. ## default_from_email=hue@localhost
  549. # Configuration options for KNOX integration for secured CDPD cluster
  550. # ------------------------------------------------------------------------
  551. [[knox]]
  552. # This is a list of hosts that knox proxy requests can come from
  553. ## knox_proxyhosts=server1.domain.com,server2.domain.com
  554. # List of Kerberos principal name which is allowed to impersonate others
  555. ## knox_principal=knox1,knox2
  556. # Comma separated list of strings representing the ports that the Hue server can trust as knox port.
  557. ## knox_ports=80,8443
  558. # Configuration options for Kerberos integration for secured Hadoop clusters
  559. # ------------------------------------------------------------------------
  560. [[kerberos]]
  561. # Path to Hue's Kerberos keytab file
  562. ## hue_keytab=
  563. # Kerberos principal name for Hue
  564. ## hue_principal=hue/hostname.foo.com
  565. # Frequency in seconds with which Hue will renew its keytab
  566. ## REINIT_FREQUENCY=3600
  567. # Path to keep Kerberos credentials cached
  568. ## ccache_path=/var/run/hue/hue_krb5_ccache
  569. # Path to kinit
  570. ## kinit_path=/path/to/kinit
  571. # Set to false if renew_lifetime in krb5.conf is set to 0m
  572. ## krb5_renewlifetime_enabled=true
  573. # Mutual authentication from the server, attaches HTTP GSSAPI/Kerberos Authentication to the given Request object
  574. ## mutual_authentication="OPTIONAL" or "REQUIRED" or "DISABLED"
  575. # Configuration options for using OAuthBackend (Core) login
  576. # ------------------------------------------------------------------------
  577. [[oauth]]
  578. # The Consumer key of the application
  579. ## consumer_key=XXXXXXXXXXXXXXXXXXXXX
  580. # The Consumer secret of the application
  581. ## consumer_secret=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
  582. # The Request token URL
  583. ## request_token_url=https://api.twitter.com/oauth/request_token
  584. # The Access token URL
  585. ## access_token_url=https://api.twitter.com/oauth/access_token
  586. # The Authorize URL
  587. ## authenticate_url=https://api.twitter.com/oauth/authorize
  588. # Configuration options for using OIDCBackend (Core) login for SSO
  589. # ------------------------------------------------------------------------
  590. [[oidc]]
  591. # The client ID as relay party set in OpenID provider
  592. ## oidc_rp_client_id=XXXXXXXXXXXXXXXXXXXXX
  593. # The client secret as relay party set in OpenID provider
  594. ## oidc_rp_client_secret=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
  595. # The OpenID provider authoriation endpoint
  596. ## oidc_op_authorization_endpoint=https://keycloak.example.com/auth/realms/Cloudera/protocol/openid-connect/auth
  597. # The OpenID provider token endpoint
  598. ## oidc_op_token_endpoint=https://keycloak.example.com/auth/realms/cloudera/protocol/openid-connect/token
  599. # The OpenID provider user info endpoint
  600. ## oidc_op_user_endpoint=https://keycloak.example.com/auth/realms/cloudera/protocol/openid-connect/userinfo
  601. # The OpenID provider signing key in PEM or DER format
  602. ## oidc_rp_idp_sign_key=/path/to/key_file
  603. # The OpenID provider authoriation endpoint
  604. ## oidc_op_jwks_endpoint=https://keycloak.example.com/auth/realms/Cloudera/protocol/openid-connect/certs
  605. # Whether Hue as OpenID Connect client verify SSL cert
  606. ## oidc_verify_ssl=true
  607. # As relay party Hue URL path to redirect to after login
  608. ## login_redirect_url=https://localhost:8888/oidc/callback/
  609. # The OpenID provider URL path to redirect to after logout
  610. ## logout_redirect_url=https://keycloak.example.com/auth/realms/cloudera/protocol/openid-connect/logout
  611. # As relay party Hue URL path to redirect to after login
  612. ## login_redirect_url_failure=https://localhost:8888/hue/oidc_failed/
  613. # Create a new user from OpenID Connect on login if it doesn't exist
  614. ## create_users_on_login=true
  615. # When creating a new user, which 'claims' attribute from the OIDC provider to be used for creating the username.
  616. # Default to 'preferred_username'. Possible values include: 'email'
  617. ## oidc_username_attribute=preferred_username
  618. # The group of users will be created and updated as superuser. To use this feature, setup in Keycloak:
  619. # 1. add the name of the group here
  620. # 2. in Keycloak, go to your_realm --> your_clients --> Mappers, add a mapper
  621. # Mapper Type: Group Membership (this is predefined mapper type)
  622. # Token Claim Name: group_membership (required exact string)
  623. ## superuser_group=hue_superusers
  624. # Configuration options for Metrics
  625. # ------------------------------------------------------------------------
  626. [[metrics]]
  627. # Enable the metrics URL "/desktop/metrics"
  628. ## enable_web_metrics=True
  629. # If specified, Hue will write metrics to this file.
  630. ## location=/var/log/hue/metrics.json
  631. # Time in milliseconds on how frequently to collect metrics
  632. ## collection_interval=30000
  633. # Configuration options for Slack
  634. # ------------------------------------------------------------------------
  635. [[slack]]
  636. # Slack credentials
  637. ## slack_client_id=
  638. ## slack_client_secret=
  639. ## slack_verification_token=
  640. ## slack_bot_user_token=
  641. # Enables Slack application API endpoints
  642. ## is_enabled=true
  643. # Enables direct sharing from Editor to Slack
  644. ## share_from_editor=true
  645. # Configuration options for the request Tracing
  646. # ------------------------------------------------------------------------
  647. [[tracing]]
  648. ## If tracing is enabled.
  649. # enabled=false
  650. ## Trace all the requests instead of a few specific ones like the SQL Editor. Much noisiers.
  651. # trace_all=false
  652. # Configuration options for the Task Server
  653. # ------------------------------------------------------------------------
  654. [[task_server]]
  655. # If resource intensive or blocking can be delegated to an already running task server.
  656. ## enabled=False
  657. # Switch on the integration with the Task Scheduler.
  658. ## beat_enabled=False
  659. # Number of query results rows to fetch into the result storage.
  660. ## fetch_result_limit=2000
  661. # Django file storage class to use to temporarily store query results
  662. ## result_storage='{"backend": "django.core.files.storage.FileSystemStorage", "properties": {"location": "./logs"}}'
  663. # How the task server and tasks communicate.
  664. ## broker_url=amqp://guest:guest@localhost//
  665. # Where to store task results. Defaults to local file system path. Celery comes with a several other backends.
  666. ## celery_result_backend=file:///$HUE_ROOT/logs
  667. # Default options provided to the task server at startup.
  668. ## celeryd_opts='--time-limit=300'
  669. # Django cache to use to store temporarily used data during query execution. This is in addition to result_file_storage and result_backend.
  670. ## execution_storage='{"BACKEND": "django.core.cache.backends.locmem.LocMemCache", "LOCATION": "celery-hue"}'
  671. # Path to a file containing a list of beat schedules.
  672. # beat_schedules_file=/etc/hue/conf/schedules.py
  673. # e.g.
  674. # periodic_tasks = [{
  675. # 'add-every-monday-morning': {
  676. # 'task': 'desktop.celery.debug_task',
  677. # 'schedule': crontab(minute='*'),
  678. # },
  679. # },
  680. # {
  681. # 'customer_count_query': {
  682. # 'task': 'notebook.tasks.run_sync_query',
  683. # 'schedule': crontab(minute='*'),
  684. # 'args': (None, None),
  685. # },
  686. # }
  687. # ]
  688. # Settings for the Google Cloud lib
  689. # ------------------------------------------------------------------------
  690. [[gc_accounts]]
  691. [[[default]]]
  692. # The JSON credentials to authenticate to Google Cloud e.g. '{ "type": "service_account", "project_id": .... }'
  693. # json_credentials=None
  694. ## Configuration for RAZ service integration
  695. # ------------------------------------------------------------------------
  696. [[raz]]
  697. ## Turns on the integration as ready to use
  698. # is_enabled=false
  699. ## Endpoint to contact
  700. # api_url=https://localhost:8080
  701. ## How to authenticate against: KERBEROS or JWT (not supported yet)
  702. # api_authentication=KERBEROS
  703. ## Autocreate the user home directory in the remote home storage path.
  704. # autocreate_user_dir=true
  705. ###########################################################################
  706. # Settings to configure the snippets available in the Notebook
  707. ###########################################################################
  708. [notebook]
  709. ## Show the notebook menu or not
  710. # show_notebooks=true
  711. ## Flag to enable the selection of queries from files, saved queries into the editor or as snippet.
  712. # enable_external_statements=false
  713. ## Flag to enable the bulk submission of queries as a background task through Oozie.
  714. # enable_batch_execute=true
  715. ## Flag to turn on the SQL indexer.
  716. # enable_sql_indexer=false
  717. ## Flag to turn on the Presentation mode of the editor.
  718. # enable_presentation=true
  719. ## Flag to enable the SQL query builder of the table assist (deprecated).
  720. # enable_query_builder=false
  721. ## Flag to enable the creation of a coordinator for the current SQL query.
  722. # enable_query_scheduling=false
  723. ## Main flag to override the automatic starting of the DBProxy server.
  724. # enable_dbproxy_server=true
  725. ## Classpath to be appended to the default DBProxy server classpath.
  726. # dbproxy_extra_classpath=
  727. ## Comma separated list of interpreters that should be shown on the wheel. This list takes precedence over the
  728. ## order in which the interpreter entries appear. Only the first 5 interpreters will appear on the wheel.
  729. # interpreters_shown_on_wheel=
  730. ## Default limit to use in SELECT statements if not present. Set to 0 to disable.
  731. # default_limit=5000
  732. # One entry for each type of snippet.
  733. [[interpreters]]
  734. # Define the name and how to connect and execute the language.
  735. # https://docs.gethue.com/administrator/configuration/editor/
  736. # [[[mysql]]]
  737. # name = MySQL
  738. # interface=sqlalchemy
  739. # ## https://docs.sqlalchemy.org/en/latest/dialects/mysql.html
  740. # options='{"url": "mysql://root:secret@database:3306/hue"}'
  741. # ## options='{"url": "mysql://${USER}:${PASSWORD}@localhost:3306/hue"}'
  742. # [[[hive]]]
  743. # name=Hive
  744. # interface=hiveserver2
  745. # [[[hplsql]]]
  746. # name=Hplsql
  747. # interface=hiveserver2
  748. # [[[llap]]]
  749. # name=LLAP
  750. # interface=hiveserver2
  751. # [[[impala]]]
  752. # name=Impala
  753. # interface=hiveserver2
  754. # [[[postgresql]]]
  755. # name = postgresql
  756. # interface=sqlalchemy
  757. # options='{"url": "postgresql://hue:hue@host:5432/hue"}'
  758. # [[[druid]]]
  759. # name = Druid
  760. # interface=sqlalchemy
  761. # options='{"url": "druid://host:8082/druid/v2/sql/"}'
  762. # [[[sparksql]]]
  763. # name = Spark Sql
  764. # interface=sqlalchemy
  765. # options='{"url": "hive://user:password@localhost:10000/database"}'
  766. # [[[sparksql]]]
  767. # name=SparkSql
  768. # interface=livy
  769. # [[[spark]]]
  770. # name=Scala
  771. # interface=livy
  772. # [[[pyspark]]]
  773. # name=PySpark
  774. # interface=livy
  775. # [[[r]]]
  776. # name=R
  777. # interface=livy
  778. # [[jar]]]
  779. # name=Spark Submit Jar
  780. # interface=livy-batch
  781. # [[[py]]]
  782. # name=Spark Submit Python
  783. # interface=livy-batch
  784. # [[[text]]]
  785. # name=Text
  786. # interface=text
  787. # [[[markdown]]]
  788. # name=Markdown
  789. # interface=text
  790. # [[[sqlite]]]
  791. # name = SQLite
  792. # interface=rdbms
  793. # [[[oracle]]]
  794. # name = Oracle
  795. # interface=rdbms
  796. # [[[solr]]]
  797. # name = Solr SQL
  798. # interface=solr
  799. # ## Name of the collection handler
  800. # options='{"collection": "default"}'
  801. # [[[pig]]]
  802. # name=Pig
  803. # interface=oozie
  804. # [[[java]]]
  805. # name=Java
  806. # interface=oozie
  807. # [[[spark2]]]
  808. # name=Spark
  809. # interface=oozie
  810. # [[[mapreduce]]]
  811. # name=MapReduce
  812. # interface=oozie
  813. # [[[sqoop1]]]
  814. # name=Sqoop1
  815. # interface=oozie
  816. # [[[distcp]]]
  817. # name=Distcp
  818. # interface=oozie
  819. # [[[shell]]]
  820. # name=Shell
  821. # interface=oozie
  822. # [[[presto]]]
  823. # name=Presto SQL
  824. # interface=presto
  825. # ## Specific options for connecting to the Presto server.
  826. # ## The JDBC driver presto-jdbc.jar need to be in the CLASSPATH environment variable.
  827. # ## If 'user' and 'password' are omitted, they will be prompted in the UI.
  828. # options='{"url": "jdbc:presto://localhost:8080/catalog/schema", "driver": "io.prestosql.jdbc.PrestoDriver", "user": "root", "password": "root"}'
  829. # ## Impersonation on.
  830. # # options='{"url": "presto://localhost:8080/hive/default", "has_impersonation": true}'
  831. # ## Kerberos.
  832. # # options='{"url": "presto://localhost:8080/hive/default?KerberosKeytabPath=/path/to/keytab&KerberosPrincipal=principal&KerberosRemoteServiceName=service&protocol=https"'
  833. # ## LDAPS enabled over HTTPS.
  834. # # options='{"url": "presto://username:password@localhost:8443/tpch/default","connect_args":"{\"protocol\": \"https\"}"}'
  835. # ## Presto Session properties along with HTTPS.
  836. # # options='{"url": "presto://username:password@localhost:8443/tpch/default","connect_args":"{\"protocol\": \"https\", \"session_props\": {\"query_max_run_time\": \"1m\"}}"}'
  837. # ## Presto Session properties when HTTPS is not enabled.
  838. # # options='{"url": "presto://username:password@localhost:8080/tpch/default","connect_args":"{\"session_props\": {\"query_max_run_time\": \"1m\"}}"}'
  839. # [[[dasksql]]]
  840. # name=Dask-SQL
  841. # interface=sqlalchemy
  842. # ## Specific options for connecting to the dask-sql server.
  843. # ## Please note, that dask-sql uses the presto protocol.
  844. # # options='{"url": "presto://localhost:8080/catalog/default"}'
  845. # [[[clickhouse]]]
  846. # name=ClickHouse
  847. # interface=sqlalchemy
  848. # e.g. clickhouse://user:password@example.com:8124/test?protocol=https
  849. # options='{"url": "clickhouse://localhost:8123"}'
  850. # [[[vertica]]]
  851. # name=Vertica
  852. # interface=jdbc
  853. # ## Specific options for connecting to a Vertica server.
  854. # ## The JDBC driver vertica-jdbc-*.jar and its related jars need to be in the CLASSPATH environment variable.
  855. # ## If 'user' and 'password' are omitted, they will be prompted in the UI.
  856. # options='{"url": "jdbc:vertica://localhost:5434", "driver": "com.vertica.jdbc.Driver"}'
  857. ## Define which query and table examples can be automatically setup for the available dialects.
  858. # [[examples]]
  859. ## If installing the examples automatically at startup.
  860. # auto_load=false
  861. ## If automatically loading the dialect example at Editor opening.
  862. # auto_open=false
  863. ## Names of the saved queries to install. All if empty.
  864. # queries=
  865. ## Names of the tables to install. All if empty.
  866. # tables=
  867. ###########################################################################
  868. # Settings to configure your Analytics Dashboards
  869. ###########################################################################
  870. [dashboard]
  871. # Activate the Dashboard link in the menu.
  872. ## is_enabled=true
  873. # Activate the SQL Dashboard (beta).
  874. ## has_sql_enabled=false
  875. # Activate the Query Builder (beta).
  876. ## has_query_builder_enabled=false
  877. # Activate the static report layout (beta).
  878. ## has_report_enabled=false
  879. # Activate the new grid layout system.
  880. ## use_gridster=true
  881. # Activate the widget filter and comparison (beta).
  882. ## has_widget_filter=false
  883. # Activate the tree widget (to drill down fields as dimensions, alpha).
  884. ## has_tree_widget=false
  885. # Setting this value to true opens up for possible xss attacks.
  886. ## allow_unsecure_html=false
  887. [[engines]]
  888. # [[[solr]]]
  889. # Requires Solr 6+
  890. ## analytics=true
  891. ## nesting=false
  892. # [[[sql]]]
  893. ## analytics=true
  894. ## nesting=false
  895. ###########################################################################
  896. # Settings to configure your Hadoop cluster.
  897. ###########################################################################
  898. [hadoop]
  899. # Configuration for HDFS NameNode
  900. # ------------------------------------------------------------------------
  901. [[hdfs_clusters]]
  902. # HA support by using HttpFs
  903. [[[default]]]
  904. # Enter the filesystem uri
  905. fs_defaultfs=hdfs://localhost:8020
  906. # NameNode logical name.
  907. ## logical_name=
  908. # Use WebHdfs/HttpFs as the communication mechanism.
  909. # Domain should be the NameNode or HttpFs host.
  910. # Default port is 14000 for HttpFs.
  911. ## webhdfs_url=http://localhost:50070/webhdfs/v1
  912. # Change this if your HDFS cluster is Kerberos-secured
  913. ## security_enabled=false
  914. # In secure mode (HTTPS), if SSL certificates from YARN Rest APIs
  915. # have to be verified against certificate authority
  916. ## ssl_cert_ca_verify=True
  917. # Directory of the Hadoop configuration
  918. ## hadoop_conf_dir=$HADOOP_CONF_DIR when set or '/etc/hadoop/conf'
  919. # Whether Hue should list this HDFS cluster. For historical reason there is no way to disable HDFS.
  920. ## is_enabled=true
  921. # Configuration for YARN (MR2)
  922. # ------------------------------------------------------------------------
  923. [[yarn_clusters]]
  924. [[[default]]]
  925. # Enter the host on which you are running the ResourceManager
  926. ## resourcemanager_host=localhost
  927. # The port where the ResourceManager IPC listens on
  928. ## resourcemanager_port=8032
  929. # Whether to submit jobs to this cluster
  930. submit_to=True
  931. # Resource Manager logical name (required for HA)
  932. ## logical_name=
  933. # Change this if your YARN cluster is Kerberos-secured
  934. ## security_enabled=false
  935. # URL of the ResourceManager API
  936. ## resourcemanager_api_url=http://localhost:8088
  937. # URL of the ProxyServer API
  938. ## proxy_api_url=http://localhost:8088
  939. # URL of the HistoryServer API
  940. ## history_server_api_url=http://localhost:19888
  941. # URL of the Spark History Server
  942. ## spark_history_server_url=http://localhost:18088
  943. # Change this if your Spark History Server is Kerberos-secured
  944. ## spark_history_server_security_enabled=false
  945. # In secure mode (HTTPS), if SSL certificates from YARN Rest APIs
  946. # have to be verified against certificate authority
  947. ## ssl_cert_ca_verify=True
  948. # HA support by specifying multiple clusters.
  949. # Redefine different properties there.
  950. # e.g.
  951. # [[[ha]]]
  952. # Resource Manager logical name (required for HA)
  953. ## logical_name=my-rm-name
  954. # Un-comment to enable
  955. ## submit_to=True
  956. # URL of the ResourceManager API
  957. ## resourcemanager_api_url=http://localhost:8088
  958. # ...
  959. ###########################################################################
  960. # Settings to configure Beeswax with Hive
  961. ###########################################################################
  962. [beeswax]
  963. # Host where HiveServer2 is running.
  964. # If Kerberos security is enabled, use fully-qualified domain name (FQDN).
  965. ## hive_server_host=localhost
  966. # Binary thrift port for HiveServer2.
  967. ## hive_server_port=10000
  968. # Http thrift port for HiveServer2.
  969. ## hive_server_http_port=10001
  970. # Host where LLAP is running
  971. ## llap_server_host = localhost
  972. # LLAP binary thrift port
  973. ## llap_server_port = 10500
  974. # LLAP HTTP Thrift port
  975. ## llap_server_thrift_port = 10501
  976. # Alternatively, use Service Discovery for LLAP (Hive Server Interactive) and/or Hiveserver2, this will override server and thrift port
  977. # Whether to use Service Discovery for LLAP
  978. ## hive_discovery_llap = true
  979. # is llap (hive server interactive) running in an HA configuration (more than 1)
  980. # important as the zookeeper structure is different
  981. ## hive_discovery_llap_ha = false
  982. # Shortcuts to finding LLAP znode Key
  983. # Non-HA - hiveserver-interactive-site - hive.server2.zookeeper.namespace ex hive2 = /hive2
  984. # HA-NonKerberized - <llap_app_name>_llap ex app name llap0 = /llap0_llap
  985. # HA-Kerberized - <llap_app_name>_llap-sasl ex app name llap0 = /llap0_llap-sasl
  986. ## hive_discovery_llap_znode = /hiveserver2-hive2
  987. # Whether to use Service Discovery for HiveServer2
  988. ## hive_discovery_hs2 = true
  989. # Hiveserver2 is hive-site hive.server2.zookeeper.namespace ex hiveserver2 = /hiverserver2
  990. ## hive_discovery_hiveserver2_znode = /hiveserver2
  991. # Applicable only for LLAP HA
  992. # To keep the load on zookeeper to a minimum
  993. # ---- we cache the LLAP activeEndpoint for the cache_timeout period
  994. # ---- we cache the hiveserver2 endpoint for the length of session
  995. # configurations to set the time between zookeeper checks
  996. ## cache_timeout = 60
  997. # Host where Hive Metastore Server (HMS) is running.
  998. # If Kerberos security is enabled, the fully-qualified domain name (FQDN) is required.
  999. ## hive_metastore_host=localhost
  1000. # Configure the port the Hive Metastore Server runs on.
  1001. ## hive_metastore_port=9083
  1002. # Hive configuration directory, where hive-site.xml is located
  1003. ## hive_conf_dir=/etc/hive/conf
  1004. # Timeout in seconds for thrift calls to Hive service
  1005. ## server_conn_timeout=120
  1006. # Choose whether to use the old GetLog() thrift call from before Hive 0.14 to retrieve the logs.
  1007. # If false, use the FetchResults() thrift call from Hive 1.0 or more instead.
  1008. ## use_get_log_api=false
  1009. # Limit the number of partitions that can be listed.
  1010. ## list_partitions_limit=10000
  1011. # The maximum number of partitions that will be included in the SELECT * LIMIT sample query for partitioned tables.
  1012. ## query_partitions_limit=10
  1013. # A limit to the number of rows that can be downloaded from a query before it is truncated.
  1014. # A value of -1 means there will be no limit.
  1015. ## download_row_limit=100000
  1016. # A limit to the number of bytes that can be downloaded from a query before it is truncated.
  1017. # A value of -1 means there will be no limit.
  1018. ## download_bytes_limit=-1
  1019. # Hue will try to close the Hive query when the user leaves the editor page.
  1020. # This will free all the query resources in HiveServer2, but also make its results inaccessible.
  1021. ## close_queries=false
  1022. # Hue will use at most this many HiveServer2 sessions per user at a time.
  1023. # For Tez, increase the number to more if you need more than one query at the time, e.g. 2 or 3 (Tez has a maximum of 1 query by session).
  1024. # -1 is unlimited number of sessions.
  1025. ## max_number_of_sessions=1
  1026. # When set to True, Hue will close sessions created for background queries and open new ones as needed.
  1027. # When set to False, Hue will keep sessions created for background queries opened and reuse them as needed.
  1028. # This flag is useful when max_number_of_sessions != 1
  1029. ## close_sessions=max_number_of_sessions != 1
  1030. # Thrift version to use when communicating with HiveServer2.
  1031. # Version 11 comes with Hive 3.0. If issues, try 7.
  1032. ## thrift_version=11
  1033. # A comma-separated list of white-listed Hive configuration properties that users are authorized to set.
  1034. ## config_whitelist=hive.map.aggr,hive.exec.compress.output,hive.exec.parallel,hive.execution.engine,mapreduce.job.queuename
  1035. # Override the default desktop username and password of the hue user used for authentications with other services.
  1036. # e.g. Used for LDAP/PAM pass-through authentication.
  1037. ## auth_username=hue
  1038. ## auth_password=
  1039. # Use SASL framework to establish connection to host.
  1040. ## use_sasl=false
  1041. # Max number of objects (columns, tables, databases) available to list in the left assist, autocomplete, table browser etc.
  1042. # Setting this higher than the default can degrade performance.
  1043. ## max_catalog_sql_entries=5000
  1044. [[ssl]]
  1045. # Path to Certificate Authority certificates.
  1046. ## cacerts=/etc/hue/cacerts.pem
  1047. # Choose whether Hue should validate certificates received from the server.
  1048. ## validate=true
  1049. ###########################################################################
  1050. # Settings to configure Metastore
  1051. ###########################################################################
  1052. [metastore]
  1053. # Flag to turn on the new version of the create table wizard.
  1054. ## enable_new_create_table=true
  1055. # Flag to force all metadata calls (e.g. list tables, table or column details...) to happen via HiveServer2 if available instead of Impala.
  1056. ## force_hs2_metadata=false
  1057. # Choose whether to show the table ERD component. Default false
  1058. ## show_table_erd=false
  1059. ###########################################################################
  1060. # Settings to configure Impala
  1061. ###########################################################################
  1062. [impala]
  1063. # Host of the Impala Server (one of the Impalad)
  1064. ## server_host=localhost
  1065. # Port of the Impala Server
  1066. ## server_port=21050
  1067. # Endpoint of the Impala Proxy Server, for example: '/endpoint'.
  1068. # Note that SERVER_PORT will be used when set.
  1069. ## proxy_endpoint=
  1070. # URL of the Impala Coordinator Server.
  1071. ## coordinator_url=localhost:25000
  1072. # Kerberos principal
  1073. ## impala_principal=impala/hostname.foo.com
  1074. # Turn on/off impersonation mechanism when talking to Impala
  1075. ## impersonation_enabled=False
  1076. # Number of initial rows of a result set to ask Impala to cache in order
  1077. # to support re-fetching them for downloading them.
  1078. # Set to 0 for disabling the option and backward compatibility.
  1079. ## querycache_rows=50000
  1080. # Timeout in seconds for thrift calls
  1081. ## server_conn_timeout=120
  1082. # Hue will try to close the Impala query when the user leaves the editor page.
  1083. # This will free all the query resources in Impala, but also make its results inaccessible.
  1084. ## close_queries=true
  1085. # If > 0, the query will be timed out (i.e. cancelled) if Impala does not do any work
  1086. # (compute or send back results) for that query within QUERY_TIMEOUT_S seconds.
  1087. ## query_timeout_s=300
  1088. # If > 0, the session will be timed out (i.e. cancelled) if Impala does not do any work
  1089. # (compute or send back results) for that session within SESSION_TIMEOUT_S seconds (default 15 min).
  1090. ## session_timeout_s=900
  1091. # Override the desktop default username and password of the hue user used for authentications with other services.
  1092. # e.g. Used for LDAP/PAM pass-through authentication.
  1093. ## auth_username=hue
  1094. ## auth_password=
  1095. # Username and password for Impala Daemon Web interface for getting Impala queries in JobBrowser
  1096. ## daemon_api_username=
  1097. ## daemon_api_password=
  1098. # Execute this script to produce the password to avoid entering in clear text
  1099. ## daemon_api_password_script=
  1100. # Set to 'digest' when webserver_htpassword_user and webserver_htpassword_password are set for Impala, or set to
  1101. # 'basic' if webserver_require_ldap is set
  1102. ## daemon_api_auth_scheme=digest
  1103. # A comma-separated list of white-listed Impala configuration properties that users are authorized to set.
  1104. # config_whitelist=debug_action,explain_level,mem_limit,optimize_partition_key_scans,query_timeout_s,request_pool
  1105. # Path to the impala configuration dir which has impalad_flags file
  1106. ## impala_conf_dir=${HUE_CONF_DIR}/impala-conf
  1107. # Use SASL framework to establish connection to host.
  1108. ## use_sasl=true
  1109. # Use Thrift over HTTP for the transport mode.
  1110. ## use_thrift_http=false
  1111. # Due to IMPALA-10272, the importer fails with READ permissions.
  1112. # Setting this to True, means setting the scratch directory and its file to 777 so the importer does not fail with permission issue
  1113. ## user_scratch_dir_permission=false
  1114. [[ssl]]
  1115. # SSL communication enabled for this server.
  1116. ## enabled=false
  1117. # Path to Certificate Authority certificates.
  1118. ## cacerts=/etc/hue/cacerts.pem
  1119. # Choose whether Hue should validate certificates received from the server.
  1120. ## validate=true
  1121. ###########################################################################
  1122. # Settings to configure the Spark application.
  1123. ###########################################################################
  1124. [spark]
  1125. # The Livy Server URL.
  1126. ## livy_server_url=http://localhost:8998
  1127. # Whether Livy requires client to perform Kerberos authentication.
  1128. ## security_enabled=false
  1129. # Whether Livy requires client to use csrf protection.
  1130. ## csrf_enabled=false
  1131. # Host of the Spark Thrift Server
  1132. # https://spark.apache.org/docs/latest/sql-distributed-sql-engine.html
  1133. ## sql_server_host=localhost
  1134. # Port of the Spark Thrift Server
  1135. ## sql_server_port=10000
  1136. # Choose whether Hue should validate certificates received from the server.
  1137. ## ssl_cert_ca_verify=true
  1138. # Use SASL framework to establish connection to host.
  1139. ## use_sasl=false
  1140. ###########################################################################
  1141. # Settings to configure the Oozie app
  1142. ###########################################################################
  1143. [oozie]
  1144. # Location on local FS where the examples are stored.
  1145. ## local_data_dir=..../examples
  1146. # Location on local FS where the data for the examples is stored.
  1147. ## sample_data_dir=...thirdparty/sample_data
  1148. # Location on HDFS where the oozie examples and workflows are stored.
  1149. # Parameters are $TIME and $USER, e.g. /user/$USER/hue/workspaces/workflow-$TIME
  1150. ## remote_data_dir=/user/hue/oozie/workspaces
  1151. # Maximum of Oozie workflows or coodinators to retrieve in one API call.
  1152. ## oozie_jobs_count=100
  1153. # Use Cron format for defining the frequency of a Coordinator instead of the old frequency number/unit.
  1154. ## enable_cron_scheduling=true
  1155. # Flag to enable the saved Editor queries to be dragged and dropped into a workflow.
  1156. ## enable_document_action=true
  1157. # Flag to enable Oozie backend filtering instead of doing it at the page level in Javascript. Requires Oozie 4.3+.
  1158. ## enable_oozie_backend_filtering=true
  1159. # Flag to enable the Impala action.
  1160. ## enable_impala_action=false
  1161. # Flag to enable the Altus action.
  1162. ## enable_altus_action=false
  1163. ###########################################################################
  1164. # Settings to configure the Filebrowser app
  1165. ###########################################################################
  1166. [filebrowser]
  1167. # Location on local filesystem where the uploaded archives are temporary stored.
  1168. ## archive_upload_tempdir=/tmp
  1169. # Show Download Button for HDFS file browser.
  1170. ## show_download_button=true
  1171. # Show Upload Button for HDFS file browser.
  1172. ## show_upload_button=true
  1173. # Flag to enable the extraction of a uploaded archive in HDFS.
  1174. ## enable_extract_uploaded_archive=true
  1175. # Redirect client to WebHdfs or S3 for file download. Note: Turning this on will override notebook/redirect_whitelist for user selected file downloads on WebHdfs & S3.
  1176. ## redirect_download=false
  1177. # Optionally set this if you want a different home directory path. e.g. s3a://gethue.
  1178. ## remote_storage_home=s3a://gethue
  1179. ###########################################################################
  1180. # Settings to configure Pig
  1181. ###########################################################################
  1182. [pig]
  1183. # Path to directory with piggybank.jar on local filesystem.
  1184. ## local_sample_dir=/usr/share/hue/apps/pig/examples
  1185. # Location piggybank.jar will be copied to in HDFS.
  1186. ## remote_data_dir=/user/hue/pig/examples
  1187. ###########################################################################
  1188. # Settings to configure Sqoop2
  1189. ###########################################################################
  1190. [sqoop]
  1191. # If the Sqoop2 app is enabled. Sqoop2 project is deprecated. Sqoop1 is recommended.
  1192. ## is_enabled=false
  1193. # Sqoop server URL
  1194. ## server_url=http://localhost:12000/sqoop
  1195. # Path to configuration directory
  1196. ## sqoop_conf_dir=/etc/sqoop2/conf
  1197. # Choose whether Hue should validate certificates received from the server.
  1198. ## ssl_cert_ca_verify=true
  1199. # For autocompletion, fill out the librdbms section.
  1200. ###########################################################################
  1201. # Settings to configure Proxy
  1202. ###########################################################################
  1203. [proxy]
  1204. # Comma-separated list of regular expressions,
  1205. # which match 'host:port' of requested proxy target.
  1206. ## whitelist=(localhost|127\.0\.0\.1):(50030|50070|50060|50075)
  1207. # Comma-separated list of regular expressions,
  1208. # which match any prefix of 'host:port/path' of requested proxy target.
  1209. # This does not support matching GET parameters.
  1210. ## blacklist=
  1211. ###########################################################################
  1212. # Settings to configure HBase Browser
  1213. ###########################################################################
  1214. [hbase]
  1215. # Comma-separated list of HBase Thrift servers for clusters in the format of '(name|host:port)'.
  1216. # Use full hostname. If hbase.thrift.ssl.enabled in hbase-site is set to true, https will be used otherwise it will use http
  1217. # If using Kerberos we assume GSSAPI SASL, not PLAIN.
  1218. ## hbase_clusters=(Cluster|localhost:9090)
  1219. # HBase configuration directory, where hbase-site.xml is located.
  1220. ## hbase_conf_dir=/etc/hbase/conf
  1221. # Hard limit of rows or columns per row fetched before truncating.
  1222. ## truncate_limit = 500
  1223. # Should come from hbase-site.xml, do not set. 'framed' is used to chunk up responses, used with the nonblocking server in Thrift but is not supported in Hue.
  1224. # 'buffered' used to be the default of the HBase Thrift Server. Default is buffered when not set in hbase-site.xml.
  1225. ## thrift_transport=buffered
  1226. # Choose whether Hue should validate certificates received from the server.
  1227. ## ssl_cert_ca_verify=true
  1228. ###########################################################################
  1229. # Settings to configure Solr Search
  1230. ###########################################################################
  1231. [search]
  1232. # URL of the Solr Server
  1233. ## solr_url=http://localhost:8983/solr/
  1234. # Requires FQDN in solr_url if enabled
  1235. ## security_enabled=false
  1236. ## Query sent when no term is entered
  1237. ## empty_query=*:*
  1238. ## Download limit with max of 15k
  1239. ## download_limit=1000
  1240. ###########################################################################
  1241. # Settings to configure Solr API lib
  1242. ###########################################################################
  1243. [libsolr]
  1244. # Choose whether Hue should validate certificates received from the server.
  1245. ## ssl_cert_ca_verify=true
  1246. # Default path to Solr in ZooKeeper.
  1247. ## solr_zk_path=/solr
  1248. ###########################################################################
  1249. # Settings to configure the Data Import Wizard
  1250. ###########################################################################
  1251. [indexer]
  1252. # Filesystem directory containing Solr Morphline indexing libs.
  1253. ## config_indexer_libs_path=/tmp/smart_indexer_lib
  1254. # Filesystem directory containing JDBC libs.
  1255. ## config_jdbc_libs_path=/user/oozie/libext/jdbc_drivers
  1256. # Filesystem directory containing jar libs.
  1257. ## config_jars_libs_path=/user/oozie/libext/libs
  1258. # Flag to turn on the Solr Morphline indexer.
  1259. ## enable_scalable_indexer=true
  1260. # Flag to turn on Sqoop ingest.
  1261. ## enable_sqoop=true
  1262. # Flag to turn on Kafka topic ingest.
  1263. ## enable_kafka=false
  1264. # Flag to turn on the direct upload of a small file.
  1265. ## enable_direct_upload=true
  1266. ###########################################################################
  1267. # Settings to configure Job Designer
  1268. ###########################################################################
  1269. [jobsub]
  1270. # Location on local FS where examples and template are stored.
  1271. ## local_data_dir=..../data
  1272. # Location on local FS where sample data is stored
  1273. ## sample_data_dir=...thirdparty/sample_data
  1274. ###########################################################################
  1275. # Settings to configure Job Browser.
  1276. ###########################################################################
  1277. [jobbrowser]
  1278. # Share submitted jobs information with all users. If set to false,
  1279. # submitted jobs are visible only to the owner and administrators.
  1280. ## share_jobs=true
  1281. # Whether to disalbe the job kill button for all users in the jobbrowser
  1282. ## disable_killing_jobs=false
  1283. # Offset in bytes where a negative offset will fetch the last N bytes for the given log file (default 1MB).
  1284. ## log_offset=-1000000
  1285. # Maximum number of jobs to fetch and display when pagination is not supported for the type.
  1286. ## max_job_fetch=500
  1287. # Show the version 2 of app which unifies all the past browsers into one.
  1288. ## enable_v2=true
  1289. # Show the Impala query section for listing and showing more troubleshooting information.
  1290. ## enable_query_browser=true
  1291. # Show the Hive section for listing the query history and providing more troubleshooting information.
  1292. ## enable_hive_query_browser=false
  1293. # Show the Queries section for listing Hive/Impala query history and providing more troubleshooting information.
  1294. ## enable_queries_list=false
  1295. # Use the proxy API instead of the ORM to access the query_store.
  1296. ## use_proxy=true
  1297. [[query_store]]
  1298. # URL of Query Store API server.
  1299. ##server_url=http://localhost:8080/
  1300. ###########################################################################
  1301. # Settings to configure Sentry / Security App.
  1302. ###########################################################################
  1303. [security]
  1304. # Use Sentry API V1 for Hive.
  1305. ## hive_v1=true
  1306. # Use Sentry API V2 for Hive.
  1307. ## hive_v2=false
  1308. # Use Sentry API V2 for Solr.
  1309. ## solr_v2=true
  1310. ###########################################################################
  1311. # Settings to configure the Zookeeper application.
  1312. ###########################################################################
  1313. [zookeeper]
  1314. [[clusters]]
  1315. [[[default]]]
  1316. # Zookeeper ensemble. Comma separated list of Host/Port.
  1317. # e.g. localhost:2181,localhost:2182,localhost:2183
  1318. ## host_ports=localhost:2181
  1319. # The URL of the REST contrib service (required for znode browsing).
  1320. ## rest_url=http://localhost:9998
  1321. # Name of Kerberos principal when using security.
  1322. ## principal_name=zookeeper
  1323. ###########################################################################
  1324. # Settings for the User Admin application
  1325. ###########################################################################
  1326. [useradmin]
  1327. # Default home directory permissions
  1328. ## home_dir_permissions=0755
  1329. # Disable to use umask from hdfs else new user home directory would be created with the permissions from home_dir_permissions
  1330. ## use_home_dir_permissions=true
  1331. # The name of the default user group that users will be a member of
  1332. ## default_user_group=default
  1333. [[password_policy]]
  1334. # Set password policy to all users. The default policy requires password to be at least 8 characters long,
  1335. # and contain both uppercase and lowercase letters, numbers, and special characters.
  1336. ## is_enabled=false
  1337. ## pwd_regex="^(?=.*?[A-Z])(?=(.*[a-z]){1,})(?=(.*[\d]){1,})(?=(.*[\W_]){1,}).{8,}$"
  1338. ## pwd_hint="The password must be at least 8 characters long, and must contain both uppercase and lowercase letters, at least one number, and at least one special character."
  1339. ## pwd_error_message="The password must be at least 8 characters long, and must contain both uppercase and lowercase letters, at least one number, and at least one special character."
  1340. ###########################################################################
  1341. # Settings to configure liboozie
  1342. ###########################################################################
  1343. [liboozie]
  1344. # The URL where the Oozie service runs on. This is required in order for
  1345. # users to submit jobs. Empty value disables the config check.
  1346. ## oozie_url=http://localhost:11000/oozie
  1347. # Requires FQDN in oozie_url if enabled
  1348. ## security_enabled=false
  1349. # Location on HDFS where the workflows/coordinator are deployed when submitted.
  1350. ## remote_deployement_dir=/user/hue/oozie/deployments
  1351. ###########################################################################
  1352. # Settings for the AWS lib
  1353. ###########################################################################
  1354. [aws]
  1355. # Enable the detection of an IAM role providing the credentials automatically. It can take a few seconds.
  1356. ## has_iam_detection=false
  1357. [[aws_accounts]]
  1358. # Default AWS account
  1359. ## [[[default]]]
  1360. # AWS credentials
  1361. ## access_key_id=
  1362. ## secret_access_key=
  1363. ## security_token=
  1364. # Execute this script to produce the AWS access key ID.
  1365. ## access_key_id_script=/path/access_key_id.sh
  1366. # Execute this script to produce the AWS secret access key.
  1367. ## secret_access_key_script=/path/secret_access_key.sh
  1368. # Allow to use either environment variables or
  1369. # EC2 InstanceProfile to retrieve AWS credentials.
  1370. ## allow_environment_credentials=yes
  1371. # AWS region to use, if no region is specified, will attempt to connect to standard s3.amazonaws.com endpoint
  1372. ## region=us-east-1
  1373. # Endpoint overrides
  1374. ## host=
  1375. # Proxy address and port
  1376. ## proxy_address=
  1377. ## proxy_port=8080
  1378. ## proxy_user=
  1379. ## proxy_pass=
  1380. # Secure connections are the default, but this can be explicitly overridden:
  1381. ## is_secure=true
  1382. # The default calling format uses https://<bucket-name>.s3.amazonaws.com but
  1383. # this may not make sense if DNS is not configured in this way for custom endpoints.
  1384. # e.g. Use boto.s3.connection.OrdinaryCallingFormat for https://s3.amazonaws.com/<bucket-name>
  1385. ## calling_format=boto.s3.connection.OrdinaryCallingFormat
  1386. # The time in seconds before a delegate key is expired. Used when filebrowser/redirect_download is used. Default to 4 Hours.
  1387. ## key_expiry=14400
  1388. ###########################################################################
  1389. # Settings for the Azure lib
  1390. ###########################################################################
  1391. [azure]
  1392. [[azure_accounts]]
  1393. # Default Azure account
  1394. [[[default]]]
  1395. # Azure credentials
  1396. ## client_id=
  1397. # Execute this script to produce the ADLS client id.
  1398. ## client_id_script=/path/client_id.sh
  1399. ## client_secret=
  1400. # Execute this script to produce the ADLS client secret.
  1401. ## client_secret_script=/path/client_secret.sh
  1402. ## tenant_id=
  1403. # Execute this script to produce the ADLS tenant id.
  1404. ## tenant_id_script=/path/tenant_id.sh
  1405. [[adls_clusters]]
  1406. # Default ADLS cluster
  1407. [[[default]]]
  1408. ## fs_defaultfs=adl://<account_name>.azuredatalakestore.net
  1409. ## webhdfs_url=https://<account_name>.azuredatalakestore.net/webhdfs/v1
  1410. [[abfs_clusters]]
  1411. # Default ABFS cluster
  1412. [[[default]]]
  1413. ## enable_defaultfs_from_coresite=true
  1414. ## fs_defaultfs=abfs://<container_name>@<account_name>.dfs.core.windows.net
  1415. ## webhdfs_url=https://<account_name>.dfs.core.windows.net
  1416. ###########################################################################
  1417. # Settings for the Sentry lib
  1418. ###########################################################################
  1419. [libsentry]
  1420. # Hostname or IP of server.
  1421. ## hostname=localhost
  1422. # Port the sentry service is running on.
  1423. ## port=8038
  1424. # Sentry configuration directory, where sentry-site.xml is located.
  1425. ## sentry_conf_dir=/etc/sentry/conf
  1426. # Number of seconds when the privilege list of a user is cached.
  1427. ## privilege_checker_caching=300
  1428. ###########################################################################
  1429. # Settings to configure the ZooKeeper Lib
  1430. ###########################################################################
  1431. [libzookeeper]
  1432. # ZooKeeper ensemble. Comma separated list of Host/Port.
  1433. # e.g. localhost:2181,localhost:2182,localhost:2183
  1434. ## ensemble=localhost:2181
  1435. # Name of Kerberos principal when using security.
  1436. ## principal_name=zookeeper
  1437. ###########################################################################
  1438. # Settings for the RDBMS application
  1439. ###########################################################################
  1440. [librdbms]
  1441. # The RDBMS app can have any number of databases configured in the databases
  1442. # section. A database is known by its section name
  1443. # (IE sqlite, mysql, psql, and oracle in the list below).
  1444. [[databases]]
  1445. # sqlite configuration.
  1446. ## [[[sqlite]]]
  1447. # Name to show in the UI.
  1448. ## nice_name=SQLite
  1449. # For SQLite, name defines the path to the database.
  1450. ## name=/tmp/sqlite.db
  1451. # Database backend to use.
  1452. ## engine=sqlite
  1453. # Database options to send to the server when connecting.
  1454. # https://docs.djangoproject.com/en/1.4/ref/databases/
  1455. ## options={}
  1456. # mysql, oracle, or postgresql configuration.
  1457. ## [[[mysql]]]
  1458. # Name to show in the UI.
  1459. ## nice_name="My SQL DB"
  1460. # For MySQL and PostgreSQL, name is the name of the database.
  1461. # For Oracle, Name is instance of the Oracle server. For express edition
  1462. # this is 'xe' by default.
  1463. ## name=mysqldb
  1464. # Database backend to use. This can be:
  1465. # 1. mysql
  1466. # 2. postgresql
  1467. # 3. oracle
  1468. ## engine=mysql
  1469. # IP or hostname of the database to connect to.
  1470. ## host=localhost
  1471. # Port the database server is listening to. Defaults are:
  1472. # 1. MySQL: 3306
  1473. # 2. PostgreSQL: 5432
  1474. # 3. Oracle Express Edition: 1521
  1475. ## port=3306
  1476. # Username to authenticate with when connecting to the database.
  1477. ## user=example
  1478. # Password matching the username to authenticate with when
  1479. # connecting to the database.
  1480. ## password=example
  1481. # Database options to send to the server when connecting.
  1482. # https://docs.djangoproject.com/en/1.4/ref/databases/
  1483. ## options={}
  1484. ###########################################################################
  1485. # Settings to configure SAML
  1486. ###########################################################################
  1487. [libsaml]
  1488. # Xmlsec1 binary path. This program should be executable by the user running Hue.
  1489. ## xmlsec_binary=/usr/local/bin/xmlsec1
  1490. # Entity ID for Hue acting as service provider.
  1491. # Can also accept a pattern where '<base_url>' will be replaced with server URL base.
  1492. ## entity_id="<base_url>/saml2/metadata/"
  1493. # Create users from SSO on login.
  1494. ## create_users_on_login=true
  1495. # Required attributes to ask for from IdP.
  1496. # This requires a comma separated list.
  1497. ## required_attributes=uid
  1498. # Optional attributes to ask for from IdP.
  1499. # This requires a comma separated list.
  1500. ## optional_attributes=
  1501. # IdP metadata in the form of a file. This is generally an XML file containing metadata that the Identity Provider generates.
  1502. ## metadata_file=
  1503. # Private key to encrypt metadata with.
  1504. ## key_file=
  1505. # Signed certificate to send along with encrypted metadata.
  1506. ## cert_file=
  1507. # If your computer and another computer that you are communicating with are not in synch regarding the computer clock, then here you can state how big a difference you are prepared to accept in milliseconds.
  1508. ## accepted_time_diff=0
  1509. # Path to a file containing the password private key.
  1510. ## key_file_password=/path/key
  1511. # Execute this script to produce the private key password. This will be used when 'key_file_password' is not set.
  1512. ## key_file_password_script=/path/pwd.sh
  1513. # A mapping from attributes in the response from the IdP to django user attributes.
  1514. ## user_attribute_mapping={'uid': ('username', )}
  1515. # Have Hue initiated authn requests be signed and provide a certificate.
  1516. ## authn_requests_signed=false
  1517. # Have Hue initiated authn response be signed.
  1518. ## want_response_signed=false
  1519. # Have Hue initiated authn assertions response be signed.
  1520. ## want_assertions_signed=false
  1521. # Have Hue initiated logout requests be signed and provide a certificate.
  1522. ## logout_requests_signed=false
  1523. # Username can be sourced from 'attributes' or 'nameid'.
  1524. ## username_source=attributes
  1525. # Performs the logout or not.
  1526. ## logout_enabled=true
  1527. # Comma separated list of group names which are all required to complete the authentication. e.g. admin,sales.
  1528. ## required_groups=
  1529. # Name of the SAML attribute containing the list of groups the user belongs to.
  1530. ## required_groups_attribute=groups
  1531. ###########################################################################
  1532. # Settings to configure OAuth
  1533. ###########################################################################
  1534. [liboauth]
  1535. # NOTE:
  1536. # To work, each of the active (i.e. uncommented) service must have
  1537. # applications created on the social network.
  1538. # Then the "consumer key" and "consumer secret" must be provided here.
  1539. #
  1540. # The addresses where to do so are:
  1541. # Twitter: https://dev.twitter.com/apps
  1542. # Google+ : https://cloud.google.com/
  1543. # Facebook: https://developers.facebook.com/apps
  1544. # Linkedin: https://www.linkedin.com/secure/developer
  1545. #
  1546. # Additionnaly, the following must be set in the application settings:
  1547. # Twitter: Callback URL (aka Redirect URL) must be set to http://YOUR_HUE_IP_OR_DOMAIN_NAME/oauth/social_login/oauth_authenticated
  1548. # Google+ : CONSENT SCREEN must have email address
  1549. # Facebook: Sandbox Mode must be DISABLED
  1550. # Linkedin: "In OAuth User Agreement", r_emailaddress is REQUIRED
  1551. # The Consumer key of the application
  1552. ## consumer_key_twitter=
  1553. ## consumer_key_google=
  1554. ## consumer_key_facebook=
  1555. ## consumer_key_linkedin=
  1556. # The Consumer secret of the application
  1557. ## consumer_secret_twitter=
  1558. ## consumer_secret_google=
  1559. ## consumer_secret_facebook=
  1560. ## consumer_secret_linkedin=
  1561. # The Request token URL
  1562. ## request_token_url_twitter=https://api.twitter.com/oauth/request_token
  1563. ## request_token_url_google=https://accounts.google.com/o/oauth2/auth
  1564. ## request_token_url_linkedin=https://www.linkedin.com/uas/oauth2/authorization
  1565. ## request_token_url_facebook=https://graph.facebook.com/oauth/authorize
  1566. # The Access token URL
  1567. ## access_token_url_twitter=https://api.twitter.com/oauth/access_token
  1568. ## access_token_url_google=https://accounts.google.com/o/oauth2/token
  1569. ## access_token_url_facebook=https://graph.facebook.com/oauth/access_token
  1570. ## access_token_url_linkedin=https://api.linkedin.com/uas/oauth2/accessToken
  1571. # The Authenticate URL
  1572. ## authenticate_url_twitter=https://api.twitter.com/oauth/authorize
  1573. ## authenticate_url_google=https://www.googleapis.com/oauth2/v1/userinfo?access_token=
  1574. ## authenticate_url_facebook=https://graph.facebook.com/me?access_token=
  1575. ## authenticate_url_linkedin=https://api.linkedin.com/v1/people/~:(email-address)?format=json&oauth2_access_token=
  1576. # Username Map. Json Hash format.
  1577. # Replaces username parts in order to simplify usernames obtained
  1578. # Example: {"@sub1.domain.com":"_S1", "@sub2.domain.com":"_S2"}
  1579. # converts 'email@sub1.domain.com' to 'email_S1'
  1580. ## username_map={}
  1581. # Whitelisted domains (only applies to Google OAuth). CSV format.
  1582. ## whitelisted_domains_google=
  1583. ###########################################################################
  1584. # Settings to configure Kafka
  1585. ###########################################################################
  1586. [kafka]
  1587. [[kafka]]
  1588. # Enable the Kafka integration.
  1589. ## is_enabled=false
  1590. # URL of Kafka REST API.
  1591. ## api_url=http://localhost:8082
  1592. # URL of Kafka Ksql API.
  1593. ## ksql_api_url=http://localhost:8088
  1594. # URL of Schema Registry API.
  1595. ## schema_registry_api_url=http://localhost:8081
  1596. ###########################################################################
  1597. # Settings to configure Metadata
  1598. ###########################################################################
  1599. [metadata]
  1600. [[manager]]
  1601. # Cloudera Manager API URL (without version suffix).
  1602. ## api_url=http://localhost:7180/api
  1603. [[optimizer]]
  1604. # Mode of optimization: off, local, api.
  1605. ## mode=off
  1606. # Type of Optimizer connector to use, e.g. optimizer, navopt, dummy.
  1607. ## interface=navopt
  1608. # Hostname of Optimizer API service.
  1609. ## hostname=navoptapi.us-west-1.optimizer.altus.cloudera.com
  1610. # The name of the key of the service.
  1611. ## auth_key_id=e0819f3a-1e6f-4904-be69-5b704bacd1245
  1612. # The private part of the key associated with the auth_key.
  1613. ## auth_key_secret='-----BEGIN PRIVATE KEY....'
  1614. # Execute this script to produce the auth_key secret. This will be used when `auth_key_secret` is not set.
  1615. ## auth_key_secret_script=/path/to/script.sh
  1616. # The name of the workload where queries are uploaded and optimizations are calculated from. Automatically guessed from auth_key and cluster_id if not specified.
  1617. ## tenant_id=
  1618. # Perform Sentry privilege filtering.
  1619. # Default to true automatically if the cluster is secure.
  1620. ## apply_sentry_permissions=False
  1621. # Cache timeout in milliseconds for the Optimizer metadata used in assist, autocomplete, etc.
  1622. # Defaults to 10 days, set to 0 to disable caching.
  1623. ## cacheable_ttl=864000000
  1624. # Automatically upload queries after their execution in order to improve recommendations.
  1625. ## auto_upload_queries=true
  1626. # Automatically upload queried tables DDL in order to improve recommendations.
  1627. ## auto_upload_ddl=true
  1628. # Automatically upload queried tables and columns stats in order to improve recommendations.
  1629. ## auto_upload_stats=false
  1630. # Allow admins to upload the last N executed queries in the quick start wizard. Use 0 to disable.
  1631. ## query_history_upload_limit=10000
  1632. [[catalog]]
  1633. # The type of Catalog: Apache Atlas, Cloudera Navigator...
  1634. ## interface=atlas
  1635. # Catalog API URL (without version suffix).
  1636. ## api_url=http://localhost:21000/atlas/v2
  1637. # Username of the CM user used for authentication.
  1638. ## server_user=hue
  1639. # Password of the user used for authentication.
  1640. ## server_password=
  1641. # Limits found entities to a specific cluster. When empty the entities from all clusters will be included in the
  1642. # search results.
  1643. ## search_cluster=
  1644. # Set to true when authenticating via kerberos instead of username/password
  1645. ## kerberos_enabled=core_site.is_kerberos_enabled()
  1646. # Directory of the configurations.
  1647. ## conf_dir=HUE_CONF_DIR/hive-conf
  1648. # Deprecated by [[catalog]]
  1649. [[navigator]]
  1650. # Navigator API URL (without version suffix).
  1651. ## api_url=http://localhost:7187/api
  1652. # Which authentication to use: CM or external via LDAP or SAML.
  1653. ## navmetadataserver_auth_type=CMDB
  1654. # Username of the CM user used for authentication.
  1655. ## navmetadataserver_cmdb_user=hue
  1656. # CM password of the user used for authentication.
  1657. ## navmetadataserver_cmdb_password=
  1658. # Execute this script to produce the CM password. This will be used when the plain password is not set.
  1659. # navmetadataserver_cmdb_password_script=
  1660. # Username of the LDAP user used for authentication.
  1661. ## navmetadataserver_ldap_user=hue
  1662. # LDAP password of the user used for authentication.
  1663. ## navmetadataserver_ldap_ppassword=
  1664. # Execute this script to produce the LDAP password. This will be used when the plain password is not set.
  1665. ## navmetadataserver_ldap_password_script=
  1666. # Username of the SAML user used for authentication.
  1667. ## navmetadataserver_saml_user=hue
  1668. ## SAML password of the user used for authentication.
  1669. # navmetadataserver_saml_password=
  1670. # Execute this script to produce the SAML password. This will be used when the plain password is not set.
  1671. ## navmetadataserver_saml_password_script=
  1672. # Perform Sentry privilege filtering.
  1673. # Default to true automatically if the cluster is secure.
  1674. ## apply_sentry_permissions=False
  1675. # Max number of items to fetch in one call in object search.
  1676. ## fetch_size_search=450
  1677. # Max number of items to fetch in one call in object search autocomplete.
  1678. ## fetch_size_search_interactive=450
  1679. # If metadata search is enabled, also show the search box in the left assist.
  1680. ## enable_file_search=false
  1681. [[prometheus]]
  1682. # Configuration options for Prometheus API.
  1683. ## api_url=http://localhost:9090/api