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 · 05-11-2021

Hi, if I remember correctly, the best way to go is using ROLAP instead of MOLAP: https://realizeddesign.blogspot.com/2016/08/rolap-now-viable-option.html See also: https://docs.exasol.com/connect_exasol/bi_tools/ms_sql_server_analysis.htm Best regard...

exa-Franz · 11-10-2021

Hi Mark, thanks for sharing! As you pointed out, it can indeed be painful to generate JSON from a relational structure. In this community discussion, @exa-Lennart briefly discussed how an Exasol UDF could be implemented to do the job:https://communit...

exa-Franz · 27-09-2021

An extended version for the following question I was asked recently: From something like this: Column1 Column2 A,B,C Hello Into this: Column1 Column2 A Hello B Hello C Hello Following changes to my original post: We are dealing with strings here, to ...

exa-Franz · 27-09-2021

Hi @drumcircle, what a coincidence 😉 I read the same article end of last week, and used it as a template for a Hello World Example for the airflow-exasol-provider. But I ran it onto a Airflow 2.1.4 instance that I installed from the scratch, which w...

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...

User Statistics

User Activity

How to use UDFs without actually writing one

DBeaver sets user defined driver properties by default

Re: How to provision Exasol data via mdx

Re: DataRobot UDF integration

Re: How to use UDFs without actually writing one

Re: Airflow @ AWS 2.02

Re: How to use UDFs without actually writing one

New to the Exasol Community?