Skip to content

Commit dcdfddb

Browse files
Ja-DunnJa-Dunn
authored
Merge pull request #85582 from dagiro/ts_hive12
ts_hive12
2 parents 89a27fd + 3ce2c61 commit dcdfddb

File tree

1 file changed

+26
-33
lines changed

1 file changed

+26
-33
lines changed

‎articles/hdinsight/hdinsight-troubleshoot-hive.md

Lines changed: 26 additions & 33 deletions
Original file line numberDiff line numberDiff line change
@@ -3,20 +3,18 @@ title: Troubleshoot Hive by using Azure HDInsight
33
description: Get answers to common questions about working with Apache Hive and Azure HDInsight.
44
keywords: Azure HDInsight, Hive, FAQ, troubleshooting guide, common questions
55
ms.service: hdinsight
6-
author: dharmeshkakadia
7-
ms.author: dkakadia
8-
ms.topic: conceptual
9-
ms.date: 11/2/2017
6+
author: hrasheed-msft
7+
ms.author: hrasheed
8+
ms.topic: troubleshooting
9+
ms.date: 08/15/2019
1010
---
1111

1212
# Troubleshoot Apache Hive by using Azure HDInsight
1313

1414
Learn about the top questions and their resolutions when working with Apache Hive payloads in Apache Ambari.
1515

16-
1716
## How do I export a Hive metastore and import it on another cluster?
1817

19-
2018
### Resolution steps
2119

2220
1. Connect to the HDInsight cluster by using a Secure Shell (SSH) client. For more information, see [Additional reading](#additional-reading-end).
@@ -31,17 +29,16 @@ Learn about the top questions and their resolutions when working with Apache Hiv
3129
3230
3. Copy the file alltables.sql to the new HDInsight cluster, and then run the following command:
3331
34-
```apache
35-
hive -f alltables.sql
36-
```
32+
```apache
33+
hive -f alltables.sql
34+
```
3735
38-
The code in the resolution steps assumes that data paths on the new cluster are the same as the data paths on the old cluster. If the data paths are different, you can manually edit the generated alltables.sql file to reflect any changes.
36+
The code in the resolution steps assumes that data paths on the new cluster are the same as the data paths on the old cluster. If the data paths are different, you can manually edit the generated `alltables.sql` file to reflect any changes.
3937
4038
### Additional reading
4139
4240
- [Connect to an HDInsight cluster by using SSH](hdinsight-hadoop-linux-use-ssh-unix.md)
4341
44-
4542
## How do I locate Hive logs on a cluster?
4643
4744
### Resolution steps
@@ -51,34 +48,33 @@ The code in the resolution steps assumes that data paths on the new cluster are
5148
2. To view Hive client logs, use the following command:
5249
5350
```apache
54-
/tmp/<username>/hive.log
51+
/tmp/<username>/hive.log
5552
```
5653

5754
3. To view Hive metastore logs, use the following command:
5855

5956
```apache
60-
/var/log/hive/hivemetastore.log
57+
/var/log/hive/hivemetastore.log
6158
```
6259

63-
4. To view Hiveserver logs, use the following command:
60+
4. To view Hive server logs, use the following command:
6461

6562
```apache
66-
/var/log/hive/hiveserver2.log
63+
/var/log/hive/hiveserver2.log
6764
```
6865

6966
### Additional reading
7067

7168
- [Connect to an HDInsight cluster by using SSH](hdinsight-hadoop-linux-use-ssh-unix.md)
7269

73-
7470
## How do I launch the Hive shell with specific configurations on a cluster?
7571

7672
### Resolution steps
7773

7874
1. Specify a configuration key-value pair when you start the Hive shell. For more information, see [Additional reading](#additional-reading-end).
7975

8076
```apache
81-
hive -hiveconf a=b
77+
hive -hiveconf a=b
8278
```
8379

8480
2. To list all effective configurations on Hive shell, use the following command:
@@ -90,23 +86,21 @@ The code in the resolution steps assumes that data paths on the new cluster are
9086
For example, use the following command to start Hive shell with debug logging enabled on the console:
9187

9288
```apache
93-
hive -hiveconf hive.root.logger=ALL,console
89+
hive -hiveconf hive.root.logger=ALL,console
9490
```
9591

9692
### Additional reading
9793

9894
- [Hive configuration properties](https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties)
9995

100-
10196
## <a name="how-do-i-analyze-tez-dag-data-on-a-cluster-critical-path"></a>How do I analyze Apache Tez DAG data on a cluster-critical path?
10297

103-
10498
### Resolution steps
105-
99+
106100
1. To analyze an Apache Tez directed acyclic graph (DAG) on a cluster-critical graph, connect to the HDInsight cluster by using SSH. For more information, see [Additional reading](#additional-reading-end).
107101

108102
2. At a command prompt, run the following command:
109-
103+
110104
```apache
111105
hadoop jar /usr/hdp/current/tez-client/tez-job-analyzer-*.jar CriticalPath --saveResults --dagId <DagId> --eventFileName <DagData.zip>
112106
```
@@ -132,42 +126,41 @@ The code in the resolution steps assumes that data paths on the new cluster are
132126
- **TaskConcurrencyAnalyzer**: Print the task concurrency details in a DAG
133127
- **VertexLevelCriticalPathAnalyzer**: Find the critical path at vertex level in a DAG
134128

135-
136129
### Additional reading
137130

138131
- [Connect to an HDInsight cluster by using SSH](hdinsight-hadoop-linux-use-ssh-unix.md)
139132

140-
141133
## How do I download Tez DAG data from a cluster?
142134

143-
144135
#### Resolution steps
145136

146137
There are two ways to collect the Tez DAG data:
147138

148139
- From the command line:
149-
140+
150141
Connect to the HDInsight cluster by using SSH. At the command prompt, run the following command:
151142

152143
```apache
153-
hadoop jar /usr/hdp/current/tez-client/tez-history-parser-*.jar org.apache.tez.history.ATSImportTool -downloadDir . -dagId <DagId>
144+
hadoop jar /usr/hdp/current/tez-client/tez-history-parser-*.jar org.apache.tez.history.ATSImportTool -downloadDir . -dagId <DagId>
154145
```
155146

156147
- Use the Ambari Tez view:
157-
158-
1. Go to Ambari.
159-
2. Go to Tez view (under the tiles icon in the upper-right corner).
148+
149+
1. Go to Ambari.
150+
2. Go to Tez view (under the tiles icon in the upper-right corner).
160151
3. Select the DAG you want to view.
161152
4. Select **Download data**.
162153

163154
### <a name="additional-reading-end"></a>Additional reading
164155

165156
[Connect to an HDInsight cluster by using SSH](hdinsight-hadoop-linux-use-ssh-unix.md)
166157

158+
## Next steps
167159

168-
### See Also
169-
[Troubleshoot by Using Azure HDInsight](hdinsight-troubleshoot-guide.md)
170-
160+
If you didn't see your problem or are unable to solve your issue, visit one of the following channels for more support:
171161

162+
- Get answers from Azure experts through [Azure Community Support](https://azure.microsoft.com/support/community/).
172163

164+
- Connect with [@AzureSupport](https://twitter.com/azuresupport) - the official Microsoft Azure account for improving customer experience. Connecting the Azure community to the right resources: answers, support, and experts.
173165

166+
- If you need more help, you can submit a support request from the [Azure portal](https://portal.azure.com/?#blade/Microsoft_Azure_Support/HelpAndSupportBlade/). Select **Support** from the menu bar or open the **Help + support** hub. For more detailed information, review [How to create an Azure support request](https://docs.microsoft.com/azure/azure-supportability/how-to-create-azure-support-request). Access to Subscription Management and billing support is included with your Microsoft Azure subscription, and Technical Support is provided through one of the [Azure Support Plans](https://azure.microsoft.com/support/plans/).

0 commit comments

Comments
 (0)