Hi  THANKS FOR THE INFO. ISSUE RESOLVE .   ... View more

As per you previous conversation All along you claimed you were using MySQL database for your metastore? But the connect string to an oracle database is different,here is the syntax for connecting "jdbc:oracle:thin:@localhost/remote_host:port:db_name"  so according to your shared  hive-site.xml  correct connect is  "jdbc:oracle:thin:@DFJHNNJHJUUI:4355:KKJH0033" "jdbc:oracle:thin:@<hoostname[DFJHNNJHJUUI]>:port[4355]:db_name[KKJH0033] Else connecting  Direct - Binary Transport Mode example below beeline -n hive -p hive -u "jdbc:hive2://osaka.com:10000/sparktest"  ----------------------------------------------------------------------------------------------------------------------------- as per my current configuration file <configuration> <!-- hnj ThriftServer authentication ldap --> <property> <name>hive.server2.authentication</name> <value>LDAP</value> </property> <property> <name>spark.sql.hive.thriftServer.adf.authenticationProvider</name> <value>com.dmz.adf.analyze.spark2adf.thriftserver.auth.hnzLdapAuthenticationProvider</value> </property> 2. am using 10000 port  3. connection url is "jdbc:oracle:thin:@DFJHNNJHJUUI:4355:KKJH0033" and also i have user id and password  4. Transport mode is binary 5. my thrift srver host is (awsdev3344 ) am using awsdev3344 server for connection to thrift server (awsdev3344 ) using beeline  am using below connection string  Beeline version 1.2.1.spark2 by Apache Hive beeline>!connect jdbc:hive2://awsdev3344 :10000  but  connection is closed automatically. i already share you the connection details please share the connection string transport mode is binary so that i can process     ... View more

Thanks for your support but no luck facing same issue connection closed automatically.   can you help me for an important shell script write a shell script to connect spark thrift server using beeline...   request you please share the syntax ..... ... View more

please find the configuration <property> <name>javax.jdo.option.ConnectionDriverName</name> <value>oracle.jdbc.OracleDriver</value> </property> <property> <name>javax.jdo.option.ConnectionURL</name> <value>jdbc:oracle:thin:@DFJHNNJHJUUI:4355:KKJH0033</value> <description>JDBC connect string for a JDBC metastore</description> </property>   please share your suggestion what need to check and configuration  ... View more

when am giving below connect ion string showing below error beeline> !connect jdbc:hive2//awshv2200:10000 scan complete in 0ms 19/10/21 03:40:04 ERROR ClassNameCompleter: Fail to parse the class name from the Jar file due to the exception:java.io.FileNotFoundException: minlog-1.2.jar (No such file or directory) 19/10/21 03:40:04 ERROR ClassNameCompleter: Fail to parse the class name from the Jar file due to the exception:java.io.FileNotFoundException: objenesis-1.2.jar (No such file or directory) 19/10/21 03:40:04 ERROR ClassNameCompleter: Fail to parse the class name from the Jar file due to the exception:java.io.FileNotFoundException: reflectasm-1.07-shaded.jar (No such file or directory) scan complete in 553ms No known driver to handle "jdbc:hive2//awshv2200:10000"     please note as my configuration in hive-site.xml the transport mode is binary can you share me the the connection string when transport mode is binary  am using same same host i;e  am currently login with host awshv2200 and my spark thrift server host is awshv2200 and port no-10000 ... View more

backend database am using spark-sql ... View more

please suggest facing below issue Beeline version 1.2.1.spark2 by Apache Hive beeline> !connect jdbc:hive2//awsdev2185:10000 scan complete in 0ms 19/10/20 04:49:36 ERROR ClassNameCompleter: Fail to parse the class name from the Jar file due to the exception:java.io.FileNotFoundException: minlog-1.2.jar (No such file or directory) 19/10/20 04:49:37 ERROR ClassNameCompleter: Fail to parse the class name from the Jar file due to the exception:java.io.FileNotFoundException: objenesis-1.2.jar (No such file or directory) 19/10/20 04:49:37 ERROR ClassNameCompleter: Fail to parse the class name from the Jar file due to the exception:java.io.FileNotFoundException: reflectasm-1.07-shaded.jar (No such file or directory) scan complete in 1177ms No known driver to handle "jdbc:hive2//awsdev2185:10000" ... View more

facing below error #-> ./bin/beeline Beeline version 1.2.1.spark2 by Apache Hive beeline> !connect jdbc:hive2://host:10001 Connecting to jdbc:hive2://host:10001 Enter username for jdbc:hive2://host:10001: SBarik2 Enter password for jdbc:hive2://host:10001: ******** org/apache/hive/service/cli/thrift/TCLIService$Iface 0: jdbc:hive2://host:10001 (closed)>   can you share what configuration need to check  ... View more

can you share before i connecting to spark thrift server with beeline what configuration need to check ...??? what i  think something wrong with configuration file.... ... View more