SQL query - from the file vs. direct

ykropiv
ykropiv New Altair Community Member
edited November 5 in Community Q&A

Hey everybody,

 

I am using RM 7.6.003. 

I query oracle DB with a query with macros and running into following issue:

- I take my query and paste it directly to RM, it runs fine.

- I save the same query into sql file (utf-8 encoding) and use "query file" as a source. And getting an error "Database error occurred: Non supported SQL92 token at position: ...."

 

Could somebody advise pls?

Tagged:

Answers

  • MartinLiebig
    MartinLiebig
    Altair Employee

    Hi @ykropiv,

    please connect with our professional support team at support.rapidminer.com . Since you have a commercial license you can access this portal. It feels to me that this is rather a question for them.

     

    My best guess: Line ending characters from windows?

    Best,
    martin

  • Edin_Klapic
    Edin_Klapic New Altair Community Member

    Hi @ykropiv,

     

    Does your SQL query include curly {} brackets? Are you using RapidMiner Macros %{} in the query?

    It might be that those are handled differently then used in a file vs. the query editor in RapidMiner ("escaping" is the magic word).

     

    Happy Mining,

    Edin

  • SGolbert
    SGolbert New Altair Community Member

    Hi @ykropiv,

     

    you can try changing the encoding of RM to UTF-8:

     

    Unbenannt.PNG

    Just replace "SYSTEM" with "UTF-8".

     

    Regards,

    Sebastian