Help Center/
Data Lake Insight/
FAQs/
Problems Related to SQL Jobs/
O&M Guide/
Why Can't I Query Data After I Manually Add Data to the Partition Directory of an OBS Table?
Updated on 2023-05-19 GMT+08:00
Why Can't I Query Data After I Manually Add Data to the Partition Directory of an OBS Table?
Symptom
Partition data is manually uploaded to a partition of an OBS table. However, the data cannot be queried using DLI SQL editor.
Solution
After manually adding partition data, you need to update the metadata information of the OBS table. Run the following statement on desired table:
MSCK REPAIR TABLE table_name;
Query the data in the OBS partitioned table.
Parent topic: O&M Guide
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot