I can see you are in HDP but you are using Cloudera Driver(https://www.cloudera.com/downloads/connectors/hive/odbc/2-6-4.html) The first thing you need to do is start using Hortonworks Driver if you are using Ambari, link to download and configure is present in https://www.cloudera.com/downloads/hdp.html   How to configure it? Check out the below link https://docs.cloudera.com/HDPDocuments/other/connectors/hive-jdbc/2.6.7/Simba-Hive-JDBC-Install-and-Configuration-Guide.pdf   The error which had been shared should not harm connecting to Hive.   To figure out the exact reason for the ODBC failure you need to enable TRACE logs as below You can configure the log level following those ways: If the client uses an ODBC on MS Windows machines, set the Log level on the Driver to TRACE and try a connection attempt, gather the driver logs: ODBC Driver Configuration > DataSourceAdministrator> select the DSN> Configure > Logging Options > set LogLevel: TRACE ODBC Driver Configuration > DataSourceAdministrator> select the DSN> Configure > Logging Options > set Log Path: "C:/" OK > OK ODBC Driver Configuration > DataSourceAdministrator> select the DSN> Configure > Test... ... View more

Hi @srinivasp    I believe you are missing SELECT and LIST privilege for the table in ranger for the user. Can you try to list the tables using Hive user from beeline and check whether you are seeing the same problem? ... View more

Hi @K_K, has the reply helped resolve your issue? If so, can please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future?  ... View more

@prasanna06 Cloudera Enterprise supports TLS. So you need to be on Enterprise version first.  For reference: https://docs.cloudera.com/documentation/enterprise/6/6.2/topics/cm_ag_licenses.html#cmug_topic_13_7__section_ed1_nz1_wr ... View more

@Bryan_zh I believe HDP 3.1.5 supports Spark 2.X only. Please check the below link https://docs.cloudera.com/HDPDocuments/HDP3/HDP-3.1.5/spark-overview/content/analyzing_data_with_apache_spark.html   How to integrate Hive and Spark? https://docs.cloudera.com/HDPDocuments/HDP3/HDP-3.0.1/integrating-hive/content/hive_hivewarehouseconnector_for_handling_apache_spark_data.html ... View more

I have installed using apache bigtops via ambari ... View more

Thanks for your reply.   1: the google test was successful. 2: the command you suggested did not give me any response. which which directory do i need to run it? ... View more

Hello @Enigmat  Could you try DISTINCT to remove similar entries? https://dwgeek.com/identify-and-remove-duplicate-records-from-hive-table.html/ https://stackoverflow.com/questions/43280052/how-to-delete-duplicate-records-from-hive-table ... View more