Exasol is an analytics database management software company. Its product is called Exasol, an in-memory, column-oriented, relational database management system.
Questions tagged [exasol]
83 questions
0
votes
1 answer
Delimiter after a quoted field, how to escape quote
I have that kind of file
info1;info2;info3";info4;info5
And after parsing I have that error
Error: [42636] ETL-2106: Error while parsing row=0 (starting from 0) [CSV Parser found at byte 5 (starting with 0 at the beginning of the row) of 5 a field…
CyclikP
- 1
- 2
0
votes
1 answer
How to get the last day of the month without LAST_DAY() or EOMONTH()?
I have a table t…
Vega
- 2,661
- 5
- 24
- 49
0
votes
2 answers
Count all rows while not counting any row after a negative value
I have a table t…
Vega
- 2,661
- 5
- 24
- 49
0
votes
1 answer
Changing Entire Column to Date Type in SQL
I am trying to convert the datatype of a column Confirmation_Dateto date type but unable to to do so, the Column is of varchar type and SER_MUHAMMAD_MALLICK.user is the tablel. Iam using the following code snippet.
SELECT CONVERT (datetime,…
Biryanii
- 81
- 7
0
votes
1 answer
H2 Database issue with SQL INTERVAL with precision
I am using Exasol DB and to perform date operation, I am using SQL INTERVAL keyword with precision.
For example this query:
SELECT email_staging.ID, email_staging.CREATED_AT from EMAIL email_staging
WHERE email_staging.CREATED_AT > (CURRENT_DATE -…
saurabh.in
- 389
- 3
- 13
0
votes
1 answer
How to join strings when they are not 100% equal?
I have 2 tables (From 2 tools agents use) and I need to join them a different levels: country, etc...
One of levels I need to join them is a code that indicate your role in the company.
Problem is that this code is entered in 2 different ways in in…
Robbie
- 121
- 11
0
votes
1 answer
Moving a table from one schema to another in Exasol
I am trying to move a table which resides in a certain schema to a different schema with the same table name. I have tried the following but they do not work:
rename . TO .;
The error that…
Mohamed Gamal
- 11
- 4
0
votes
2 answers
How to find UTF-8 codes via LIKE '%\xC2\xA0%'?
I have a column that contains NO-BREAK SPACE (\xC2\xA0) instead of SPACE and I need to find that rows.
Copy-pasting works:
SELECT PRODUCT_NAME
FROM TABLE t
WHERE PRODUCT_NAME LIKE '% %'
but using the code points does not:
SELECT PRODUCT_NAME
FROM…
Vega
- 2,661
- 5
- 24
- 49
0
votes
1 answer
0
votes
1 answer
stored procedure SQL exasol
I've a table with huge data and it needs to be break down into chunks and passed to the insert query.
I need to write a stored procedure for this
Logic for the stored procedure is drafted out like this (can be improved too):
VARIABLE= SELECT COUNT…
user12063090
- 39
- 7
0
votes
2 answers
way to turn column into rows exasol sql
I have two columns that have list of rules and dates like below:
a b c
--------------- -----------------------------
init, rule#062,rule#066 …
user12063090
- 39
- 7
0
votes
1 answer
Comparison between a DATE and a VARCHAR: How does it work?
I have the following condition:
WHERE ORDER_DATE >= TO_DATE (CURRENT_DATE, 'YYYY-MM-DD')
The left part (ORDER_DATE) is stored as a VARCHAR and the right part is a DATE.
When I run the code I have no error; meaning that the comparison between a…
savag
- 3
- 2
0
votes
1 answer
Use GROUP BY with SELECT CASE WHEN statement
I have a table like:
ORDER_DATE | ORDER_ID | ORDER_AMOUNT
2020-11-07 | 1 | 40
2020-11-07 | 1 | 60
2021-04-01 | 2 | 100
From 2020-07-01 to 2020-12-31 the sales tax was reduced from 19% to 16% due to Covid.
Now I need to know the…
Vega
- 2,661
- 5
- 24
- 49
0
votes
1 answer
GROUP BY one column, then GROUP BY another column
I have a database table t with a sales table:
ID
TYPE
AGE
1
B
20
1
BP
20
1
BP
20
1
P
20
2
B
30
2
BP
30
2
BP
30
3
P
40
If a person buys a bundle it appears the bundle sale (TYPE B) and the different bundle products (TYPE…
Vega
- 2,661
- 5
- 24
- 49
0
votes
1 answer
Why select IN doesnt work properly when there are nulls
Why this is returning a record in EXASOL DBMS
SELECT a, b FROM (SELECT NULL AS a, 'b' AS b) t
WHERE (a, b) NOT IN (SELECT NULL, 'b')
?
Thanks, Rafael.
Rafael
- 307
- 1
- 3
- 16