Symptom
If it takes longer time than usual to import CSV file and you can see threads for IMPORT task in status
"Semaphore Wait CSV_Import_MemoryLimit_Semaphore" and "Semaphore Wait CSV_Import_WorkerRun_Semaphore".
You can also check these thread status by script HANA_SQL_StatementHash_DataCollector_2.00.040+.txt with the statement hash of IMPORT statement.
"Images/data in this KBA from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Read more...
Environment
- SAP HANA Platform Edition 1.0
- SAP HANA Platform Edition 2.0
Product
SAP HANA, platform edition all versions
Keywords
CSV import, CSV file, import, slowness, long time , KBA , HAN-DB , SAP HANA Database , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.