About exa-Franz

exa-Franz · 27-08-2021

This is about hijacking the JSON functions in Exasol 😉 Assume you have a comma-separated list of values and want to unnest them. What do you think of this, let me know. with tmp as (values('1,2,3'),('4,5,6') as t(x)) SELECT JSON_EXTRACT( '['||x||']'...

exa-Franz · 27-07-2021

Hi everybody, I stumbled upon this yesterday. Does anybody know why DBeaver is defining user defined driver properties when setting up a new Exasol DB connection? We were wondering why queries got aborted after 10 minutes and found this, see screensh...

exa-Franz · 30-08-2021

I also recommend a different name 😉 @exa-MathiasHo once created that post https://community.exasol.com/t5/discussion-forum/what-s-the-best-query-trick-you-are-using/m-p/3541 Maybe you could call a potential series "neat little tricks" or something l...

exa-Franz · 27-07-2021

Thanks @Charlie for the quick answer! In our case it was a long running IMPORT statement 😉

exa-Franz · 05-03-2021

Hehe, @mwellbro opening the box of pandora right in the first reply, I like the vibe 😁You are right, it is so powerful, every advanced Exasol user should know about it. I am not sure if it is a good idea to do so with every other database technology...

exa-Franz · 08-02-2021

Hi bakka, just for your information:you can explicitely select one of the two postgresql drivers if you want to use - using the "driver option":https://docs.exasol.com/sql/import.htm"Some JDBC drivers are already delivered as default (visible in EXAo...

exa-Franz · 08-01-2021

Hi,did you try the right node ip for the cloud plugin:https://docs.exasol.com/administration/aws/plugin/cloud_ui_plugin.htmIt should be the one of the management node.Also make sure the port is accessible.

User Statistics

User Activity

How to use UDFs without actually writing one

DBeaver sets user defined driver properties by default

Re: How to use UDFs without actually writing one

Re: DBeaver sets user defined driver properties by default

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: Exasol AWS Cloud UI tool not working with Exa Operation Url at port 8835

New to the Exasol Community?