Custom SQL Import Job Error

Follow

Joshua Barnett

• November 21, 2018 16:43

I am seeing the following error when I enter my custom SQL "The SQL contains an illegal action or keyword: 'delete'". How do I use the word delete in my SQL filter. Do I need to wrap the text in something for datameer to recognize it as text?

0

• 

  Alan Mark

  • November 21, 2018 17:31

  Hi Joshua,

  The custom SQL interface only supports selecting data, not updating or deleting data.  You'll note that the text explanation next to the custom SQL box mentions to enter your select statement.

  You won't be able to escape 'delete' if you're trying to use it as a column name or asname - it's an ANSI SQL reserved word and should not be used in select queries.

  0

  Comment actions Permalink

Please sign in to leave a comment.