I have a CSV file that is uploaded to datalake. Data is readable and available in ATLAS but it shows NULL values in COMPASS. What might be the issue and how it should be resolved?
Mohan,
Try to see if you can see the data if you are following the below steps.
Under Compass search for the object schema you are querying for.
Click on 3 dots and click on SELECT options --> SELECT (All Variations). Query will be populated something like
SELECT
Click on Run query and see if you are getting results.
can you confirm schema and data has header row?
Maybe share a sanitized sample?
Yes, it has a header row.
Example
Fruit, Vendor, Price
Apple, Simla expo, 125
Orange, Maharani Expo, 200
Mango, Summer Expo, 100
Hi Mohan,
Have you tried to run clear_table or clear_data admin procedures to ensure Compass has the latest schema information and the latest object data is cached. Ref: docs.infor.com/.../default.html
Mohan, can you advise if this helped or if you need additional assistance? thanks
The cache doesn't work. I tried it earlier too. In our case, the table was corrupted. We deleted and re-created it and it worked.
