About Gallus

Gallus · 09-07-2021

Hello everybodyI am using an export statement to store the records of a table into multiple files. I noticed that the size of the files and also the number of records per file is not equal and varias quit a bit. In the EXASOL documentation I found th...

Gallus · 15-06-2021

Hello togetherWe have in our company a team, which needs to access the EXASOL database using Oracle Data Integrator (ODI). They only need to perform simple "Select" Statements from views. We were able to somehow setup the ODI Topoligy (using the last...

Gallus · 08-06-2021

We are migrating from another database to EXASOL. The default behavior for order by statements of that database corresponds to the option order by xxx desc nulls last in EXASOL.The question came now up whether we could in EXASOL define the "nulls las...

Gallus · 11-09-2020

We are using Wherescape as our ELT Tool and are currently on Teradata. The key point about Wherescape is, that it generates platform specific code. We write our logic on the Metadata and then Wherescape translates it to almost any target platform, us...

Gallus · 03-06-2020

Hello everybodyMy name is Gallus. I introduced EXASOL in my previous company in 2012 and worked happely with it for almost 4 years. In my current position as Datawarehouse architect at Helsana Health-Insurance I re-evaluated EXASOL, did a POC and we ...

Gallus · 20-07-2021

Good Morning everybodyMany thanks for all your help. This helps definitely. As we have 17 nodes I am going to check with the recipient whether it would also be possible to deliver 17 files or whether they can deal with different file sizes. I assume ...

Gallus · 09-07-2021

Hello @mwellbro Many thanks for your answer. I have just tried it with an order by statement, but that did not change anything.Kind RegardsGallus

Gallus · 15-06-2021

Hello togetherMany thanks for your feedback. We decided not use the SQL Preprocessor at this point in time. Some of the arguments against it:Performance: At this point in time we don't have the time to do detailed performance testingLack of clear spe...

Gallus · 08-06-2021

Hello UweMany thanks for the answer. I hesitate a bit to apply this in the preprocessor as this would then be applied to each and every query. I will first check with our internal community to better understand the benefit vs. the cost. We would then...

Gallus · 03-05-2021

I somewhat agree, but I am not sure whether this approach would fit all needs.I would say for historical, structured data I would like to be able to access them using EXASOL, whether the data actually resides in Exasol or in a hadoop cluster. If it r...

User Statistics

User Activity

Export to multiple files, controle the number of records per file

Using Oracle Data Integrator with Exasol. Problems with decimal (14,4)

Defining order by null last at database level

Wherescape and EXASOL

Hello Community

Re: Export to multiple files, controle the number of records per file

Re: Export to multiple files, controle the number of records per file

Re: Defining order by null last at database level

Re: Defining order by null last at database level

Re: Data Lake or Data Warehouse -> Data Lakehouse?

New to the Exasol Community?