About exa-Nico

exa-Nico · 08-04-2021

Table of Contents Table of ContentsScopeDiagnosisExplanationRecommendationAdditional References Scope When executing a query, you might receive an internal server error. This article will show you what information you need to investigate it. Diagnosi...

exa-Nico · 18-03-2021

Table of Contents Table of ContentsScopeDiagnosisExplanationRecommendationAdditional References Scope This article describes how to fix some syntax errors with Scripts when using DbVisualizer. Diagnosis When trying to create a script using DbVisualiz...

exa-Nico · 25-02-2021

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 · 24-02-2021

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 · 10-02-2021

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 · 08-04-2021

I agree with @mwellbro - there won't be a way to make a direct connection in your UDF to access something like "C://Users/abc/Documents...". You could create an SFTP server on your local machine which is mapped to one of your folders on your machine ...

exa-Nico · 25-03-2021

@drumcircle I don't follow exactly. So you want to migrate your local Exasol Database users and passwords to your AD, and then configure the database to authenticate against AD using the newly-transferred passwords? (so from the user perspective, the...

exa-Nico · 11-03-2021

Maybe not a feature, but you can determine the timestamp that a session was opened by using the following query: SELECT FROM_POSIX_TIME(/1024/1024/1000); Really helps to determine what day logs might be needed

exa-Nico · 06-02-2021

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 · 04-02-2021

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

User Statistics

User Activity

Internal Server Errors

DbVisualizer: Syntax Errors with Scripts

IMPORT FROM EXA: Connection Errors

Machine Learning Example in R and Python

Python: Module Not Found

Re: Accessing host file system

Re: LDAP password sync?

Re: What’s the best query trick you are using?

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

Re: EXAplus and openJDK

New to the Exasol Community?