SPRKHVSQL1002

SQL statement is not supported.

Message: < Element Name > is not supported.

Category: Error.

Description

This error message appears when a statement is not supported in Snowflake.

Scenario

Input

Below is an example of an element that is not supported in Snowflake.

REFRESH p2 PARTITION (y = 0, z = 3);

Output

The SMA adds the EWI SPRKHVSQL1002 to the output code to let you know that the element is not supported in Snowflake.

----EWI: SPRKHVSQL1002 => HvRefresh is not supported
--REFRESH
------EWI: SPRKHVSQL1002 => HvRefresh.SqlName is not supported
--p2 PARTITION (y = 0, z = 3)
;

Recommended fix

Check if the source code has the correct syntax. (You can use the issues.csv file to determine where the conversion error(s) are occurring.) If the syntax is correct, report that you encountered a conversion error on a particular element using the Report an Issue option in the SMA. Include the line of code that was causing the error in the description when you file this issue.

Additional recommendations

• Even though the option or the element on the message is not supported, this does not mean that a solution cannot be found. It only means that the tool itself cannot find the solution.

• For more support, you can email us at [e-mail] or post an issue in the SMA.