SQL query - from the file vs. direct

ykropivykropiv Member Posts: 1 Contributor I
edited December 2018 in Help

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?



  • Options
    MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,517 RM Data Scientist

    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?


    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
  • Options
    Edin_KlapicEdin_Klapic Moderator, Employee, RMResearcher, Member Posts: 299 RM Data Scientist

    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,


  • Options
    SGolbertSGolbert RapidMiner Certified Analyst, Member Posts: 344 Unicorn

    Hi @ykropiv,


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



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




Sign In or Register to comment.