No Data is Found in the Hive Table Using Presto

Issue

When Presto is used to query a Hive table, no data is found.

Symptom

Presto cannot query the data written by union statements executed by the Tez engine.

Cause Analysis

When Hive uses the Tez engine to execute the union statements, the output file is stored in the HIVE_UNION_SUBDIR directory. However, Presto does not access files in child directories by default. Therefore, data in the HIVE_UNION_SUBDIR directory is not read.

Procedure

1. On the MRS console, click the cluster name, and choose Components > Presto > Service Configuration.
2. Change Basic to All.
3. In the navigation pane on the left, choose Presto > Hive. In the catalog/hive.properties file, add the hive.recursive-directories parameter and set it to true.

   

4. Click Save Configuration and select Restart the affected services or instances.