In the editor (is it still called MOE?) I have this statement:
alter table schema.table_name truncate partition (partition_name) drop storage;
The word ‘partition’ is underlined in red wiggles, and an exclamation mark appears in the gutter. The message is “ERROR … found ‘partition’: expecting PARTITION PARTITIONS SUBPARTITION or SUBPARTITIONS”.
It’s not a letter case problem as it complains if I uppercase the word ‘partition’ too.