hue.ini 78 KB

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