Hi @Israr, It looks like you have enabled HA, but there is no secondary name node in your cluster. This complains about the configuration issue. Can you review your HDFS configs once? Let us know if this helps. ... View more

Are you using the same user account to connect via ODBC which you used to log in to Hue? Please verify that.  ... View more

Hello @hadoopranger , If you are using Cloudera Manager to manage your services, you can add new services using this document https://docs.cloudera.com/cdp-private-cloud-base/7.1.9/managing-clusters/topics/cm-adding-a-service.html Also, you can use CM API to add the services to the cluster.  https://docs.cloudera.com/cdp-private-cloud-base/7.1.9/configuring-clusters/topics/cm-api-cluster-automation.html   Hope this helps! Cheers!  ... View more

@ldylag you can check which database the service uses by checking its configuration in the cloudera manager. For instance, go to hive service » configuration » and search for database. The configuration named "hive_metastore_database_name" will tell you the actual database hive service is using.  I hope this helps! ... View more

Hello @Bartlomiej, You can change the timezone for Hue using the steps below: Log in to Clouder Manager as an Administrator. Go to Clusters > Hue > Configuration > Time Zone and set a desired value. The default value is America/Los_Angeles. You can refer to https://timezonedb.com/time-zones for information on the timezones. Click Save Changes. Restart the Hue service. Let me know if this helps. Cheers! ... View more

@adsejnf, Welcome to Cloudera community! Do you see any issues in the Hive logs? Or try checking the application logs via CLI: » yarn logs -applicationId <application ID> -appOwner <AppOwner> ... View more

Hi @adsejnf, have you tried using the username and password as hive & hive respectively? If not, please try it once. Thanks! ... View more

try adding to your existing connection string that you are using in JDBC: SSL=1;SSLTrustStore=/var/lib/cloudera-scm-agent/agent-cert/cm-auto-global_truststore.jks ... View more

Hi @MorganMcEvoy, You can create string using the way mentioned here https://community.cloudera.com/t5/Community-Articles/How-to-Connect-to-Hiveserver2-Using-Cloudera-JDBC-driver/ta-p/376336 Cheers! ... View more

Hi @gowthamsanjam, We recommend using the Cloudera JDBC Jar to connect to third-party tools using JDBC URLs. You can view more information here: https://docs.cloudera.com/cdw-runtime/1.5.1/integrating-hive-and-bi/topics/dw-integrating-third-party-tools.html https://www.cloudera.com/downloads/connectors/hive/jdbc/2-6-25.html Let me know if this helps! Cheers! ... View more