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
1
vote
2 answers
Azure Data Factory - Self-Hosted Integration Runtime - ODBC driver mystery
We are using a Self-Hosted Integration Runtime for Azure Data Factory.
On that machine there was installed an Exasol ODBC driver of version 6. We wanted to upgrade the driver, deleted an old one and installed a new driver of version 7.
Weird thing…
GriGrim
- 2,891
- 1
- 19
- 33
1
vote
1 answer
Get SRID of geometry column in exasol (ST_SRID equivalent)
It seems that there is no ST_SRID function in exasol like in other DBMS: SELECT ST_SRID(geom) FROM sampletable
Is there an efficient workaround to determine the SRID of a geometry column? So far I only had success in parsing the COLUMN_TYPE string…
NielsFlohr
- 183
- 7
1
vote
1 answer
Exasol SQL Fuzzy Matching function
Good day, all you SQL geniuses out there. I'm running into a bit of an issue. The firm I work at uses EXASOL SQL and I'm trying to get find a function that I can use in order to fuzzy match two strings.
For example, Let's say we have these two…
A_Pirates_Favorite_Letter
- 141
- 1
- 12
1
vote
2 answers
How do I update a column named Date in SQL?
I have a table that has a column named Date. This causes problems because Date is a data type name. I tried the following statements to escape it:
Update Tables.Subtable SET `Date` = "2022-03-14 07:20:32" WHERE ID=960646;
Update Tables.Subtable SET…
algebruh
- 153
- 1
- 11
1
vote
1 answer
how to sum timestamps by 5 minutes
I need help with taking sum of timestamps in sql by 5 mins or since I'm doing analysis so maybe i change it to 6, 7 or 10 mins , particularly in Exasol as it doesn't have all functions like datediff and dateadd.
the result should look like this…
user12063090
- 39
- 7
1
vote
1 answer
Exasol UPSERT without using a second table?
I could not find anything online about this problem. It seems ORACLE has a similar issue, which is handled using DUAL, as suggested in this StackOverflow answer.
But how do we do the same in Exasol? According to their documentation, you need to…
John Magistr
- 872
- 3
- 9
- 22
1
vote
1 answer
Sending API JSON data to Exasol DB table
I am working with fake JSON data from a dummy JSON site that looks like this:
[
{
"postId": 1,
"id": 1,
"name": "id labore ex et quam laborum",
"email": "Eliseo@gardner.biz",
"body": "laudantium enim quasi est quidem magnam…
JD2775
- 3,658
- 7
- 30
- 52
1
vote
2 answers
How to find the EXASOL server version with SQL
I'm looking for a SQL query to provide me with the Exasol server version, similar to this in Oracle:
-- Oracle
select * from v$version;
-- PostgreSQL:
select version();
How can I do it?
Lukas Eder
- 211,314
- 129
- 689
- 1,509
1
vote
4 answers
Fill rows in column A with value of column B if condition in column A is met
I have a table like:
colA | colB
" " | 1
"K 111" | 1
"K222" | 2
" " | 3
Some columns have only a space (" "), some have "K {number}", some have "K{number}".
If colA has only a space I want that value replaced with the one from colB.
So…
Vega
- 2,661
- 5
- 24
- 49
1
vote
1 answer
Why exasol transform old timestamp wrong?
Exasol is transforming old dates incorrectly:
SELECT ADD_SECONDS('1970-01-01 00:00:00',-30610224000.000)
-- 0999-12-27 00:00:00
SELECT ADD_SECONDS('1970-01-01 00:00:00',-30609792000.000)
-- 1000-01-01 00:00:00
While in java:
…
Rafael
- 307
- 1
- 3
- 16
1
vote
1 answer
Exasol Update Table using subselect
I got this statement, which works in Oracle:
update table a set
a.attribute =
(select
round(sum(r.attribute1),4)
from table2 p, table3 r
where 1 = 1
and some joins
)
where 1 = 1
and a.attribute3 >…
Aaron R.
- 93
- 2
- 9
1
vote
0 answers
Trigger in Exasol DB
How to simulate the functionality of triggers in exasolDB?
Like:
CREATE TRIGGER [schema_name.]trigger_name
ON table_name
AFTER {[INSERT],[UPDATE],[DELETE]}
[NOT FOR REPLICATION]
AS
{sql_statements}
swapna p
- 83
- 7
1
vote
1 answer
How to remove quotes from dictionary value string dynamically
I have a dictionary like: d = {'table': 'db_schema.foo', 'column': 'bar'}. I want to pass this dictionary after removing quotes from all values. So I want to get {'table': db_schema.foo, 'column': bar} dynamically.
Details:
I am trying to pass run…
Priya
- 285
- 4
- 14
1
vote
1 answer
Regular expression - capture number between underscores within a sequence between commas
I have a field in a database table in the format:
111_2222_33333,222_444_3,aaa_bbb_ccc
This is format is uniform to the entire field. Three underscore separated numeric values, a comma, three more underscore separated numeric values, another comma…
hungryhobo
- 13
- 2
1
vote
2 answers
Add multiple columns using alter command in Exasol DB
Is it possible to add multiple columns to a table in a single query execution, using alter table in exasol?
example:
Alter table Employee add column phone_number varchar(256), add column address varchar(256)
swapna p
- 83
- 7