Hi,   I got the same error in hue 3.1.0. The sql works fine with beeline but will get same error with hue. And we're also using impala hive HA.   Tried [Set use_get_log_api=true in the beeswax section ], and it's not working. Do you have any other solution? ... View more

Any resolution to this issue.    Will appreciate some feedback or direction.   Regards BigData ... View more

i have similar situation. will say me the other commands thats checks all failed system? tahnk you ... View more

Check the values for below paramaters in database (MYSQL) used for HUE. Login to MYSQL database. mysql> use hue; mysql> select count(*) from desktop_document; mysql> select count(*) from desktop_document2; mysql> select count(*) from beeswax_session; mysql> select count(*) from beeswax_savedquery; mysql> select count(*) from beeswax_queryhistory; mysql> select count(*) from oozie_job;   Remove if more than 30k. It resolved our slowness issue multiple times. ... View more

Hello,   This happens when your user is not in the impala, hive groups. You should add this user to linux hive, impala groups on all nodes. The hive, impala groups are Sentry admin groups by default. That is why after you add the user to hive and impala groups, you can see the databases and tables.   Regards,   Huriye Akbaş ... View more

Hello @Axis_BDL ,   There can be several causes for no databases being found in the Hue Impala app, so it is a good idea to look for more information in the Hue log.  Usually the log file is /var/log/hue/runcpserver.log   Perhaps try tailing that log while you reload the Impala page in Hue.   We'll need some more information to help us learn what the problem is, so the Hue log is a good start. ... View more

I got the charts to work by disabling the beans for CSRF interceptor. This may not be the best for security but for out installation our cluster is in its own network and not accessible from outside.    1) Make backup of xml config file cp /usr/share/cmf/webapp/WEB-INF/spring/mvc-config.xml /usr/share/cmf/webapp/WEB-INF/spring/mvc-config.xml.backup   2) Comment out this line in the config: before: <bean class="com.cloudera.server.web.cmf.csrf.CsrfRefererInterceptor" /> after: <!-- bean class="com.cloudera.server.web.cmf.csrf.CsrfRefererInterceptor" / -->   3) Restart Cloudera Manager Server service cloudera-scm-server restart   I hope that helps.  ... View more

This was just fixed ... View more

Rolling restart of Resource Manager fixed issue for me ... View more

Hi Sonqi, The log files configuration is located in desktop/conf/log.conf: https://github.com/cloudera/hue/blob/master/desktop/conf/log.conf#L51 By default, it is configured to use python's RotatingFileHandler https://docs.python.org/2/library/logging.handlers.html#rotatingfilehandler which is based on the size of the file, but you can change it to use TimeRotatingFileHandler https://docs.python.org/2/library/logging.handlers.html#timedrotatingfilehandler ... View more

Hi,   Has anyone been able to do this?   @Romainr are you suggesting to send a POST request to the API used by the Hue UI?   This could be a good option but I am worried it would break when Hue is upgraded.    A public API as requested in HUE-1450 would be ideal.   Thanks Julien         ... View more

    I got the same error:403 when using hue notebook through livy in a kerberos CDH-5.7.1 cluster.     i kinit the ticket before running livy-server,i also do change the hue code like https://github.com/cloudera/hue/commit/25ed265ab719da51160f242ffe9a92cc6d8a4bec     its still not work.       hue-safe [desktop] app_blacklist=sqoop,zookeeper,hbase use_new_editor=true [spark] security_enabled=true livy_server_host=192.168.103.166 livy_server_port=8998 livy_server_session_kind=yarn livy_impersonation_enabled=true languages='[{"name": "Scala Shell", "type": "spark"},{"name": "PySpark Shell", "type": "pyspark"},{"name": "R Shell", "type": "r"},{"name": "Jar", "type": "Jar"},{"name": "Python", "type": "py"},{"name": "Impala SQL", "type": "impala"},{"name": "Hive SQL", "type": "hive"},{"name": "Text", "type": "text"}]' [notebook] show_notebooks=true enable_batch_execute=true enable_query_builder=true enable_query_scheduling=false [[interpreters]] [[[hive]]] name=Hive interface=hiveserver2 [[[impala]]] name=Impala interface=hiveserver2 [[[spark]]] name=Scala interface=livy [[[pyspark]]] name=PySpark interface=livy [[[jar]]] name=Spark Submit Jar interface=livy-batch [[[py]]] name=Spark Submit Python interface=livy-batch     livy-conf livy.spark.master=yarn livy.spark.deploy-mode=client livy.superusers=hue livy.server.auth.type=kerberos livy.server.auth.kerberos.keytab=/etc/security/keytabs/spnego166.keytab livy.server.auth.kerberos.principal=HTTP/bigdata166.xxxx.com@xxxx.COM livy.server.launch.kerberos.keytab=/etc/security/keytabs/livy.keytab livy.server.launch.kerberos.principal=livy/bigdata166.xxxx.com@xxxx.COM     livy-log 19/04/10 12:56:29 INFO AccessManager: AccessControlManager acls disabled;users with view permission: ;users with modify permission: ;users with super permission: hue;other allowed users: * 19/04/10 12:56:30 INFO LineBufferedStream: stdout: Welcome to 19/04/10 12:56:30 INFO LineBufferedStream: stdout: ____ __ 19/04/10 12:56:30 INFO LineBufferedStream: stdout: / __/__ ___ _____/ /__ 19/04/10 12:56:30 INFO LineBufferedStream: stdout: _\ \/ _ \/ _ `/ __/ '_/ 19/04/10 12:56:30 INFO LineBufferedStream: stdout: /___/ .__/\_,_/_/ /_/\_\ version 1.6.0 19/04/10 12:56:30 INFO LineBufferedStream: stdout: /_/ 19/04/10 12:56:30 INFO LineBufferedStream: stdout: 19/04/10 12:56:30 INFO LineBufferedStream: stdout: Type --help for more information. 19/04/10 12:56:30 INFO StateStore$: Using BlackholeStateStore for recovery. 19/04/10 12:56:30 INFO BatchSessionManager: Recovered 0 batch sessions. Next session id: 0 19/04/10 12:56:30 INFO InteractiveSessionManager: Recovered 0 interactive sessions. Next session id: 0 19/04/10 12:56:30 INFO InteractiveSessionManager: Heartbeat watchdog thread started. 19/04/10 12:56:30 INFO LivyServer: SPNEGO auth enabled (principal = HTTP/bigdata166.xxxx.com@xxxx.COM) 19/04/10 12:56:30 INFO KerberosAuthenticationHandler: Login using keytab /etc/security/keytabs/spnego166.keytab, for principal HTTP/bigdata166.xxxx.com@xxxx.COM 19/04/10 12:56:30 INFO WebServer: Starting server on http://bigdata166.xxxx.com:8998 19/04/10 12:58:21 WARN AuthenticationFilter: Authentication exception: GSSException: No valid credentials provided (Mechanism level: Failed to find any Kerberos credentails) ... View more

@bgooley    idp only returns Name of user but it is not similar to Unix Username due to which sentry authorization will not work becuase authorization provided on Unix user group.   Can you suggest for any method/way or sample example through which i can perform name translation?   - VIjay M ... View more

If you have HA in your cluster, make sure the setting of webhdfs_url in Hue is pointing to the ACTIVE NameNode.   You can find webhdfs_url in: (xxx is some digitals for you current run of Hue) /run/cloudera-scm-agent/process/xxx-hue-HUE_SERVER/hue.ini   And you can find the active NameNode in: (xx is some digitals for you cluster) http://your.cloudera.manager.host:7180/cmf/services/xx/instances   Or, maybe you've missed something after the HA, check below https://www.cloudera.com/documentation/enterprise/latest/topics/cdh_hag_hdfs_ha_cdh_components_config.html#concept_rj1_hsq_bp   ... View more

Hello @prabhat10,   For understanding scenario write, as per your description following is the assumption: Assuming, node1 host =  cm1 haproxy and hs2 are on same host If above assumptions are right and assuming your environment have not option but to keep haproxy and hs2 on different hosts then change the thrift ports.   Hope that helps. ... View more

Hello, any update to this ? I see that issue is still open. So does it mean, that there is no way how to increase dashboard download limit at the moment? ... View more

Hi  minsirv,   Unfortunately, we didn't involve to much about HBase Thrift Authentication.   But Let me share one more thing about HUE Authentication.   HUE default account is "admin", this account maybe cause some permission decline problem.   Please try to set account such as "hive" in HUE, and avoid using "admin".   Hope this poor experience can help you.   ... View more

Users will automatically be logged out after 'n' seconds of inactivity.   any specific number for "n"  ?   ... View more