SQL query - from the file vs. direct
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?
Answers
-
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,
martin1 -
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
1 -
Hi @ykropiv,
you can try changing the encoding of RM to UTF-8:
Just replace "SYSTEM" with "UTF-8".
Regards,
Sebastian
1