copied antlr-runtime-xxx.jar from the standard lib of hive into the standard jar lib of spark, ... View more

Apologies for the late reply .We need the driver logs. Please check the below document to get the JDBC driver logs.    https://www.simba.com/resources/drivers/enable-logging-odbc-driver/ ... View more

Is the connection string correct? I see below message: org.apache.hadoop.hive.metastore.api.MetaException No such database row ... View more

The location would be in odbc.ini ... View more

1. Do you use HDP/CDH/CDP? 2. What is the version? 3. What is the driver version? 4. Driver logs 5. Is your cluster SSL/Kerberos enabled? ... View more

Do you face same issue when you connect via beeline ? If yes we need to check HMS logs.     ... View more

Where do you want to implement HDP/CDH/CDP ? What is your version ? ... View more

The task is not getting launched   ----------------------------------------------------------------------------------------------  VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED ---------------------------------------------------------------------------------------------- Map 1 container INITIALIZING -1 0 0 -1 0 0 Reducer 2 container INITED 1 0 0 1 0 0 ---------------------------------------------------------------------------------------------- VERTICES: 00/02 [>>--------------------------] 0% ELAPSED TIME: 29.84 s ---------------------------------------------------------------------------------------------- ERROR : Status: Failed   Can you try with the below settings:   Navigato Ambari => Tez ==> tez.am.resource.memory.mb =5120 and restart hive and tez.   Set the below in beeline or at the client session and try: +++++ set hive.tez.container.size=5120; set hive.tez.java.opts=-Xmx4096m; set tez.runtime.io.sort.mb=2048; set tez.task.resource.memory.mb=4096; +++++++++ If issue persist try with below: set hive.tez.container.size=10240; set hive.tez.java.opts=-Xmx8192m; set tez.runtime.io.sort.mb=4096; set tez.task.resource.memory.mb=7680;   If it fails then issue might be with Kafka or  the yarn ... View more

I can see that none of the containers are initialised yet:   Map 1 container INITIALIZING -1 0 0 -1 0 0 Reducer 2 container INITED 1 0 0 1 0 0   and eventually fails with timeout exception:    java.io.IOException: java.util.concurrent.TimeoutException   Action Plan:    1. The issue seems to be with yarn contention issue. Set a queue where it is unutilised.   set tez.queue.name=<under utilised queue>   2. Increase the task container timeout         set tez.task.timeout-ms=6000   Set the above values in beeline session (not in AMbari cluster) and re-run the query.   Attach below if query fails:    1. set -v   2. APplication logs  3. Console output ... View more

You can check the explain plan . It provided the order of the execution.   It is not a rule that certain reucers would start after all the mapper phase.   The ceratin mapper phase depends on the results from the reducers too. You can check the explain plan .   If you want map join then you can set property map.auto.conevrt.join =true ... View more

She meant to say for non managed HDP/CDH. ... View more

It wont work in CDH or HDP managed cluster.   You need to try in independent not managed by CDH or HDP as per Sindhu's comment ... View more

Does this hiveserver2 managed by CDH cluster or independent of CDH ? ... View more

Please share the updated logs.I want to check the error ... View more

COuld you adjust the value bit more than   6518628  and check? ... View more

The latest ODBC driver is 2.6.9   Please download https://www.cloudera.com/downloads/connectors/impala/odbc/2-6-9.html ... View more

Can you provide the output from MySQL     show variables like 'max_allowed_packet';     Please also increase the variable in MySQL: https://dev.mysql.com/doc/refman/8.0/en/packet-too-large.html  ... View more

The serde class is no more supported in HDP 3.0. It's replaced with 'AbstractSerDe'. ... View more

1. Follow  below document to run Oozie in time basis (weekly/daily/hourly)        https://docs.cloudera.com/documentation/enterprise/6/6.3/topics/admin_oozie_cron.html   2. Follow below document for Oozie email action          http://oozie.apache.org/docs/5.2.0/DG_EmailActionExtension.html ... View more

My understanding is ,you can access from  Tableau via ODBC driver  to Hive.    Could you please explain in brief ?      Is it possible to get the server name, etc without access to admin links/directories?     ... View more

In my understanding, you want to connect Tableu to CDP.   You need to use ODBC driver .Please follow below document     https://docs.cloudera.com/runtime/7.2.0/integrating-hive-and-bi/topics/hive_connecting_hive_to_bi_tools.html ... View more