About exa-Nico

exa-Nico

Table of Contents Table of ContentsScopeDiagnosisExplanationRecommendationAdditional References Scope While loading data from one Exasol database into another database, you may get connection issues. This article will describe how you can resolve the...

exa-Nico

Background Exasol's UDF scripts make it possible to run machine-learning algorithms directly in the database. The training of a random-forest model and using this model to make predictions on a dataset in the Exasol database can be done in three step...

exa-Nico

Table of Contents Table of ContentsScopeDiagnosisExplanationRecommendationAdditional References Scope When creating Python UDF's, you may depend on external libraries to accomplish some tasks. When these libraries are not installed by default, the UD...

exa-Nico · 27-01-2021

Hi Community! We are happy to announce that we've just published a new course in Exacademy called Exasol Virtual Schemas! The course goes through all the necessary steps to work with Virtual Schemas, including: Adding BucketFS services and buckets Up...

exa-Nico · 25-01-2021

Happy Monday everyone! I woke up this morning to DBVisualizer telling me to update to version 12.0, and it has a really useful feature. Now in 12.0, DBVisualizer is able to understand scripts without having to put --/ in front of them anymore. Before...

exa-Nico

I think you are right, the driver needs additional permissions. Go into Exaoperation -> Software -> JDBC Drivers. Click on your postgres driver and check the box to disable the security manager. See if that solves the problem.

exa-Nico

Hi @mwellbro - sorry I forgot to respond! This link might help you with the registry values as well

exa-Nico · 26-01-2021

Fixed it, good catch 😉

exa-Nico · 25-01-2021

I would expect that behavior with TRUNCATE, but if you run a create or replace, I would expect the identity value to be dropped.... You can also re-set the identity using an ALTER TABLE command: ALTER TABLE t ALTER COLUMN id SET IDENTITY 1; https://d...

exa-Nico · 22-01-2021

@ChristianGfK make sure you are logged in 😉

User Statistics

User Activity

IMPORT FROM EXA: Connection Errors

Machine Learning Example in R and Python

Python: Module Not Found

New Exacademy Course: Exasol Virtual Schemas!

DBVisualizer 12.0

Re: SSL error: access denied when connection to PostgreSQL 13 from Exasol 7.0.4 on Gougle Cloud

Re: EXAplus and openJDK

Re: Access RowNr from original file in IMPORT ?

Re: Access RowNr from original file in IMPORT ?

Re: Exasol 7.0.6 released

New to the Exasol Community?