-
"can PostgreSQL use rapidminer ?? if possible, how to operate it?"
-
RM studio / server and huge PostgreSQL tables: best practice?
Hi everyone, What can be suggested as a good parctical approach while working with VERY big PostgreSQL tables within Studio+Server ecosystem? Is there any way to efficiently handle 5M rows tables making aggregations and joins and not use Radoop? For example, while preparing the data I need to calculate some metrics which…
-
Postgresql Password Authentication error
Hi, I have a Postgresql server that I'd like to connect to, on an AWS server. When I connect from Studio, it works fine. When I connect from the machine that I have installed RapidMiner Server on using psql, it works fine. But when I try to connect from RapidMiner server, I get 'FATAL: password authentication failed for…
-
Writing a Postgresql boolean column
Hi, I am using the Write Database operator to write a Postgres database: <?xml version="1.0" encoding="UTF-8"?><process version="7.4.000"> <operator activated="true" class="jdbc_connectors:write_database" compatibility="7.4.000" expanded="true" height="68" name="write to my table" width="90" x="1452" y="238"> <parameter…
-
Restoring the PostgreSQL driver
Hi, I was messing around with the PostgreSQL drivers on my machine for another program, and I think I broke the RM Postgres driver. PostgreSQLWhen I try to make a new PostgreSQL connection, I get "No suitable driver found for jdbc:postgresql://localhost:5432. And for existing processes, RapidMiner is not even trying to…
-
RM Server putting all tables in the Postgres public schema
I got RM talking to Postgres, but instead of putting its tables in the schema I indicated, they are all in the public schema. Is there a way around this? <?xml version="1.0" encoding="UTF-8" standalone="no"?> <!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd"> <properties> <entry…
-
"RapidMinerServer and Postgresql in AWS"
Hi, I have a weird problem with RapidMiner server and Postgresql hosted in AWS. Basically , sometimes processes fail to fetch/read data from a postgresql database giving the error: SEVERE: Process failed: com.rapidminer.operator.UserError: Cannot retrieve repository data from entry '//DB/advancedanalytics/Example…
-
Stream Database Error with Postgres 9
Hello, I am facing an issue when trying to stream a very large table in Rapid Miner Studio 7 from Postgres 9. It appears that Rapid Miner is creating the secondary index mapping table, but it always errors out with the following text. Process failed: Database error occurred: ERROR: syntax error at or near "IDENTITY"…
-
"Stram Database operator with Postgresql"
Hi together, until recently i worked with RM on my Postgres DB with the read DB operator. It works perfect. Because of fast growth I have to change the operator to the Stream DB operator. In my DB i have already a PK named id. But when iI try to use this one i became an error: SEVERE: Database error occurred: FEHLER:…
-
"RM Frezees trying to connect to PostgreSQL"
Hi Guys, Thanks for the space. I'm trying to connect to my PostgreSQL DB 9.2 Data Warehouse and every time I try the RM seems to freeze. I've tried using the PostgreSQL driver which comes with RM CE and I've also tried with one that I had downloaded from the PostgreSQL (9.2) . I've tried connecting with a MySQL DB and…
-
"Timestamps from PostgreSQL: Different results in RapidMiner and RapidAnalytics"
Hi everyone, I am facing a strange behavior of timestamps (or big numbers) in RapidMiner and RapidAnalytics when reading them from a PostgreSQL Database. I set up a very simple process, which only reads from the DB, sorts the resulting example set and stores it in the RA repository. <?xml version="1.0" encoding="UTF-8"…
-
"PostgresSLQ DB write error: column type 'name'"
Hi, I would like to report an 'old' bug :( . It seems to have been reported quite some time ago in the following 2 threads: http://rapid-i.com/rapidforum/index.php/topic,2008.0.html http://rapid-i.com/rapidforum/index.php/topic,3826.0.html Currently I am crawling a site and recording the HTML pages in a DB. The problem is…
-
"Unable to write binary data into Postgres"
Hi Folks, I'm new to RapidMiner, so hope you'll forgive me if I missed something fundamental here. I have done a search for this problem having been logged before, but nothing came up that was relevant to this issue. I have written a basic job that: 1. Reads URLs from a database table in Postgres [Read Database] 2. Gets…
-
"help with installation on WinXP - postgresql"
HI Im trying install RA on Winxp using Postgresql. I can get to step 3 Initial Web-based Conguration following the Installation Instructions pdf. However, at this step I cannot progress as Postgres is not listed. I have manually setup the tables, and I can see that during the running of run.bat that further tables…