The error you're encountering (OperationalError: TExecuteStatementResp(status=TStatus(statusCode=3, ...) indicates that there was an issue during the execution of the Hive query. The specific error message within the response is Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask. Here are a few steps you can take to troubleshoot and resolve the issue: Check Hive Query Logs: Review the Hive query logs to get more details about the error. The logs might provide information about the specific query or task that failed, including any error messages or stack traces. You can find the logs in the Hive logs directory. The location may vary based on your Hadoop distribution and configuration. Inspect Query Syntax: Double-check the syntax of your Hive SQL query. Ensure that the query is valid and properly formed. Sometimes, a syntax error can lead to execution failures. Verify Hive Table Existence: Confirm that the Hive table you're querying actually exists. If the table or the specified database is missing, it can lead to errors. Check Permissions: Verify that the user running the Python query has the necessary permissions to access and query the Hive table. Lack of permissions can result in execution errors. Examine Tez Configuration: If your Hive queries use the Tez execution engine, check the Tez configuration. Ensure that Tez is properly configured on your cluster and that there are no issues with the Tez execution. Look for Resource Constraints: The error message mentions TezTask, so consider checking if there are any resource constraints on the Tez execution, such as memory or container size limitations. Update Python Library: Ensure that you are using a compatible version of the Python library for interacting with Hive (e.g., pyhive or pyhive[hive]). Updating the library to the latest version might help resolve certain issues. Test with a Simple Query: Simplify your query to a basic one and see if it executes successfully. This can help isolate whether the issue is specific to the query or a more general problem. After reviewing the logs and checking the mentioned aspects, you should have more insights into what might be causing the error. If the issue persists, consider providing more details about the Hive query and the surrounding context, so we can offer more targeted assistance. ... View more

Welcome to the community @Ryand2. I hope @Ayuuu has helped you identify the issue here. If so, please use the accept as solution button to mark his reply as the answer. ... View more

Hello Vidya, would you support me in this as well?   regards, Mahrous Badr ... View more

I do not want to be harsh, but I do not know better ways to show my disappointment with your support. All I wanted was to locate VMs for use with training and you failed on multiple occasions to point me to the site.    Instead, I get links with limited explanations, or replied asking me if the problem was solved with no prior attempts to answer the questions. I did get that the training was relevant, but that was it and all that I now expect. I have no confidence that those who replied even checked the information about which I inquired.   If there is not time to answer the question, then do not answer the question with half hearted responses. I looks bad for a company I once had interest  and thought well of.  You can mark this closed and unresolved as you have not answered the question and I no longer care to hear from your support team.  I have wasted enough time for what should be a simple answer. ... View more

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

Thank you for posting your findings @HanzalaShaikh  ... View more

Congratulations on resolving the issue and thanks for sharing the solution.  ... View more

Thank you @MattWho for the answer and @cjervis for the tags. That did solve my issue but it took me a couple tries.  I will be marking yours as the solution but including this note for future readers in case they run into the same thing I did.  I had been copy-pasting commands in order to keep notes on my steps and at some point one of the two dashes on the --subjectAlternativeNames had been replaced by a different kind of dash character. ... View more

@learner-loading were you able to resolve your issue? If any of the above posts were the solution please mark the appropriate, as it will make it easier for others to find the answer in the future.        ... View more