Support Questions
Find answers, ask questions, and share your expertise
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Error while connecting to Hive in LInux

Error while connecting to Hive in LInux

New Contributor

(ODBC_ERROR) [unixODBC][Hortonworks][ODBC] (10380) Unable to establish a connection with data source. Missing settings: {[Host] [Port]}


Re: Error while connecting to Hive in LInux

Rising Star

@Prameela Janardanan the error suggests that you are missing the host and port parts of the connection string. A properly formatted connection (using Beeline as an example) would look similar to this: beeline -u jdbc:hive2://localhost:10000/default -n scott -w password_file. The bolded parts are what you are receiving the error about, the connect string needs to contain the hostname of the server you are connecting to (localhost in the example) and the port number (10000 in this example, which is the default port for HiveServer2). Tf you find this post helpful, please don't forget to "accept" the answer.

Don't have an account?
Coming from Hortonworks? Activate your account here