方案:在 Azure HDInsight 中提取查询结果时,Apache Hive 视图超时Scenario: Apache Hive View times out when fetching a query result in Azure HDInsight

本文介绍在 Azure HDInsight 群集中使用交互式查询组件时出现的问题的故障排除步骤和可能的解决方案。This article describes troubleshooting steps and possible resolutions for issues when using Interactive Query components in Azure HDInsight clusters.

问题Issue

从 Apache Hive 视图运行某些查询时,可能会遇到以下错误:When running certain queries from the Apache Hive view, the following error may be encountered:

result fetch timed out
java.util.concurrent.TimeoutException: deadline passed

原因Cause

Hive 视图默认超时值可能不适用于正在运行的查询。The Hive View default timeout value may not be suitable for the query you are running. 指定的时间段对于 Hive 视图而言太短,无法提取查询结果。The specified time period is too short for the Hive View to fetch the query result.

解决方法Resolution

通过在 /etc/ambari-server/conf/ambari.properties 中设置以下属性来增加 Apache Ambari Hive 视图超时。Increase the Apache Ambari Hive View timeouts by setting the following properties in /etc/ambari-server/conf/ambari.properties.

views.ambari.request.read.timeout.millis=300000
views.request.read.timeout.millis=300000
views.ambari.hive<HIVE_VIEW_INSTANCE_NAME>.result.fetch.timeout=300000

HIVE_VIEW_INSTANCE_NAME 的值可在 Hive 视图 URL 的末尾找到。The value of HIVE_VIEW_INSTANCE_NAME is available at the end of the Hive View URL.

后续步骤Next steps

如果你的问题未在本文中列出,或者无法解决问题,请访问以下渠道以获取更多支持:If you didn't see your problem or are unable to solve your issue, visit the following channel for more support:

  • 如果需要更多帮助,可以从 Azure 门户提交支持请求。If you need more help, you can submit a support request from the Azure portal. 从菜单栏中选择“支持” ,或打开“帮助 + 支持” 中心。Select Support from the menu bar or open the Help + support hub.