The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
Get meta data from database with Macro-values in SQL-request
Contributor II
Hello,
I want to thank you first for this great software, it's really intuitive to use
I use it for my project for several weeks now. The problem is that I have to use macro-values in the WHERE-clause of some SQL-requests in my process. The big disadvantage is that RapidMiner is not able to get the meta data in this case, so in all following operators I have to type everything manually (in fact I can not use the advantages of the meta data in nearly the whole process).
Now I'm not sure how the meta data gathering method is implemented internally at the moment, but I guess it should be possible if just the SELECT and FROM-clause is used to load a line from the database and get the meta information, because all additional clauses should not be needed for this process. So there should be no problem anymore if a macro is used in the WHERE clause.
Do you think it would be possible to implement it like that in future?
At least for me it would be big advantage
Best regards,
Chris
I want to thank you first for this great software, it's really intuitive to use
I use it for my project for several weeks now. The problem is that I have to use macro-values in the WHERE-clause of some SQL-requests in my process. The big disadvantage is that RapidMiner is not able to get the meta data in this case, so in all following operators I have to type everything manually (in fact I can not use the advantages of the meta data in nearly the whole process).
Now I'm not sure how the meta data gathering method is implemented internally at the moment, but I guess it should be possible if just the SELECT and FROM-clause is used to load a line from the database and get the meta information, because all additional clauses should not be needed for this process. So there should be no problem anymore if a macro is used in the WHERE clause.
Do you think it would be possible to implement it like that in future?
At least for me it would be big advantage
Best regards,
Chris
0
