hue.ini 78 KB

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