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

@lv_antel what is the complete command you are using? can you please share the complete stack trace? ... View more

@frbelotto , a sample code to test connectivity from Python to Hive.  from pyhive import hive import logging import os logging.basicConfig(level=logging.DEBUG) conn = hive.Connection(host="hs_host",port=10000,database='default') cursor = conn.cursor() cursor.execute("show databases") res = cursor.fetchall() print (res) #connect = hive.Connection(host=db_host, port=db_port, username=db_user, password=db_password, database=db_name,auth='KERBEROS',kerberos_service_name='hive') make sure to install the below dependencies before running the code: pip3.8 install pyhive pip3.8 install thrift pip3.8 install thrift_sasl I hope this helps! Cheers! ... View more

@damnworld can you share the listing of "/opt/cloudera/"? Do you have any folder as "/opt/cloudera/csd" and within that do you have the kyuubi folder available? If yes, kindly remove that. ... View more

Hi @damnworld, can you please let us know which parcel you added? and what service type do you see? Can you share the snapshot? ... View more

very detailed and useful article. Thank you @asish!  ... View more