About skarangi

skarangi · 17-11-2021

Hi, In the nightly batch runs with multiple jobs running and perform different operations on database, when a delete process runs on a massively huge table and that reaches a 25% limit causing reorganize, I see performance impacts to current operatio...

skarangi · 15-12-2020

Hi, Does Exasol considers IDLE session as active session? If no , at what point should we worried about number of IDLE sessions? Regards,Sreekanth

skarangi · 11-12-2020

Hi, I want to generate a graph with X axis as time in a day ( at a granularity of second) and y axis as active sessions at that moment. Can you please tell me which table data I can use to do that? Regards,Sreekanth

skarangi · 20-11-2020

Hi, I was trying this section https://docs.exasol.com/connect_exasol/workflow_management/apache_airflow.htm With one change , I was running an import statement in sql file. test.sql file code:- IMPORT INTO COUNTRY FROM LOCAL CSV FILE '/home/vagrant/a...

skarangi · 10-09-2020

Hi , When we see a table size has shrunk, is there a way to identify it happend due to table reorganize that got triggered as 25 % threshold has crossed? Also in the memory object size is the 25% deleted records are taken into consideration? Thanks, ...

skarangi · 01-09-2021

If a value is changed through ALTER SYSTEM, it will only impact new connections to the database.May be due to this reason? Can you check with new connection and see if problem still persists.

skarangi · 16-12-2020

Which version of exasol are you using? I think that might be the reason. Please see the release notes of 6.2 versionHide inaccessible schemasStarting with Exasol version 6.2, a user can only access a schema or virtual schema if the user is owner or i...

skarangi · 24-11-2020

Hi ,Yes from PYTHON UDF this can be achieved. I believe LUA can also be used but never tried before.

skarangi · 20-11-2020

Hi @exa-Nico ,FTP connection worked. I did not understand the point from your previous reply. Airflow sending PREPARED statements and LOCAL option is not supported ( also suggested in documentation). How a prepared statement different from regular SQ...

skarangi · 20-11-2020

@adiazv ,Can you try something like below.From File_1.txt, create another file File_1_header.txt by running a shell script, then upload both files separately. Thanks,Sreekanth

User Statistics

User Activity

Delete process- Background Reorganize - optimization techniques

IDLE Session and Its Impact on Total Active Sessions

Where can I find data to plot a graph of Number of active sessions in a day

Airflow Import Local csv file error

When object size shrinks, how do we identify that it happened due to deletion reorganization

Re: Can't change query timeout for session

Re: Hide EXA_STATISTICS and SYS schemas

Re: Issue loading csv data

Re: Airflow Import Local csv file error

Re: Issue loading csv data

New to the Exasol Community?