About exa-Peggy

exa-Peggy · 25-01-2022

You might face the exception Can not handle type: 126 in LUA scripts. This article will show you how to resolve this issue. Table of Contents Table of ContentsDiagnosisExplanationRecommendationAdditional References Diagnosis While reading from a Hash...

exa-Peggy · 28-10-2021

Table of Contents Table of ContentsScopeDiagnosisExplanationRecommendationAdditional References Scope You might face the exception String data right truncation. String length exceeds limit of 255 characters in AWS_ATHENA. This article will show you h...

exa-Peggy · 26-10-2021

This article describes a solution for exception “data exception - invalid character value for cast“ Table of Contents Table of ContentsScopeDiagnosisExamples:ExplanationRecommendationAdditional References Scope You might face the exception “data exce...

exa-Peggy · 05-10-2021

Table of Contents Table of ContentsScopeDiagnosisExplanationRecommendationAdditional References Scope Users may report that they are not able to install Exasol ODBC drivers on Windows. They get an error while trying to create an ODBC data source that...

exa-Peggy · 21-09-2021

Table of Contents Table of ContentsScopeDiagnosisExplanationRecommendationAdditional References Scope Intern merged sessions is due to a performance optimization where some transactions may get merged internally into some kind of super transaction in...

exa-Peggy · 22-04-2022

Attention:CREATE FORCE VIEW "$EXA_DB_SIZE_HOURLY"..CAST( AVG(DEVICE_SIZE/1024/1024/1024) AS DECIMAL(10,1) ) STORAGE_SIZE_AVG...FROM"$EXA_STATS_DB_SIZE"describe full "$EXA_DB_SIZE_HOURLY" ; STORAGE_SIZE_AVG => Average size of the persistent volume in ...

exa-Peggy · 28-01-2022

Example: CREATE OR REPLACE TABLE test.A(ID INT,COUNTRY INT); INSERT INTO test.A VALUES(1,1),(2,2); How many distinct values do we have? SELECT COUNT(DISTINCT ID), COUNT(ID) FROM TABLE A --HAVING COUNT(ID) > 1 ; Result: Count(DISTINCT ID) Count(ID) --...

exa-Peggy · 28-01-2022

Example 1: CREATE OR REPLACE TABLE A ( ID INT); INSERT INTO A VALUES (1),(2),(2),(4),(4),(4); 1.) Which distinct values do we have? SELECT GROUP_CONCAT(DISTINCT ID), '=>', COUNT(DISTINCT ID) FROM A; Result: GROUP_CONCAT(A.ID) '=>' Count(DISTINCT A.ID...

exa-Peggy · 27-10-2021

Hi Thomas, Hint: "Execute Scripts" should only be used for orchestrating statements. It only runs in one thread under one node." a scripting program is a sequential program and only runs on a single cluster node (except the contained SQL statement). ...

exa-Peggy · 26-10-2021

HI Thomas;Seems that Exasol supports only single dimensional array https://docs.exasol.com/database_concepts/scripting/db_interaction.htm#ScriptingParametersWould a split help as a workaround? --https://stackoverflow.com/questions/1426954/split-strin...

User Statistics

User Activity

How to resolve error 42000:Can not handle type: 126 in LUA Scripts

String length exceeds limit of 255 characters in AWS-ATHENA

Error message "Invalid character value for cast"

What to do, when the ExaSolution ODBC Driver could not be started during Setup

What to do, when you get the message "Intern Merged Sessions"

Re: Exasol Storage Reporting

Re: Applying query from "Verification of the Uniqueness (UNIQUE)" - Selecting duplicated

Re: Applying query from "Verification of the Uniqueness (UNIQUE)" - Selecting duplicated

Re: how to pass a multidimensional array when executin a lua script

Re: how to pass a multidimensional array when executin a lua script

New to the Exasol Community?