SPRKHVSQL1004

Information from underlying data files can not be recovered

Category

Warning.

Description

This error message appears when DROP TABLE does not contains the purge clause., because there can be slightly differences between the functionality of this clause in Hive and Snowflake.

Input code:

DROP TABLE table1;

Output code:

--EWI: SPRKHVSQL1004 => Information from underlying data files can not be recovered. ***/
DROP TABLE table1;

Recommendation

• For more support, you can email us at [email protected]. If you have a contract for support with Snowflake, reach out to your sales engineer and they can direct your support needs.