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
0 answers
Starting Exasol docker-db without privileges in Bitbucket Pipeline
I'm trying to run an integration test using testcontainers in my Bitbucket Pipeline. For each test I need to start up a fresh Exasol image. This, however, needs to be started in priviledged mode
for permissions management, UDF support and…
user3599245
- 49
- 7
0
votes
0 answers
Docker exasol image now working on arm64 mac machine
on running exasol docker image(below command) on arm64 machine, container is starting with errors
docker run --name exasoldb1111 -p 127.0.0.1:9563:8563 --detach --privileged --stop-timeout 120 -v exa_volume:/exa exasol/docker-db
unable to connect…
arkay
- 149
- 1
- 12
0
votes
0 answers
Return first value after each 60 day period from an Exasol table
Below you will find a table with dummy data. Can anyone help me write a query which returns the touchpoint_id for the very first touchpoint and then always the first touchpoint after a 60 day period?
With the data below, the query should return…
Charlie
- 11
0
votes
1 answer
Hash MD5 ( Exasol to data bricks)
We have used Hash_MD5(col1,col2) in exasol. Now we are migrating to data bricks and we want to retain all Hash id's. Problem is data brick doesnot support multiple arguments in MD5 and concat MD5(Concat(col1,col2)) giving us different result. Any…
Shakky007
- 1
- 1
0
votes
0 answers
Exasol via ADO: Named parameter syntax in SQL-statement
I have a project: Excel frontend, MS Access DB as backend, connecting via ADO.
Now we are migrating MS Access DB to Exasol - still using ADO via {EXASolution Driver}.
One issue I don't get solved are named parameters like in SELECT ProjectName FROM…
Ike
- 9,580
- 4
- 13
- 29
0
votes
0 answers
Using DBContext with Exasol
I have a requirement to connect to Exasol from .Net app and use DBContext for data retrieval / manipulation.
From what I understand Exasol is not natively supported by Entita Framework and there is no official provider.
Any experience using 3rd…
Zenon
- 71
- 1
- 10
0
votes
0 answers
Working and feasibility of exasol "export" command
Attempted using "export" command (https://docs.exasol.com/db/latest/sql/export.htm) to migrate data from exasol sample table exasol_schema.ST_CATEGORIES to redshift table redshift_schema.ST_Categories:
SQL_EXA> Export exasol_schema.ST_CATEGORIES…
Hitesh
- 121
- 3
- 14
0
votes
0 answers
SQL last value aggregation is giving first value with ordered inner query
Hi I have below query
SELECT
CLUSTER_ID AS CLUSTER_ID,
"date"
FROM
HISTORY
GROUP BY
CLUSTER_ID,
"date"
ORDER BY
CLUSTER_ID,
"date"
with below output
1 2023-02-27
1 2023-03-01
1 2023-03-06
1 2023-03-13
1 …
arkay
- 149
- 1
- 12
0
votes
2 answers
Exasol docker image not running on M1 mac
We need to run Exasol locally on M1 machines to support the local testing. However docker image does not start on Exasol.
Docker image used - https://github.com/exasol/docker-db/
Do we have any other workaround for this?
Tried using --platform flag…
alicia
- 1
- 1
0
votes
1 answer
maven.exasol.com artifactory link not working
Fail to use exasol repository, the link https://maven.exasol.com/artifactory/exasol-releases redirects to the exasol.com new homepage.
This fails to get the dependencies I need:
exasol-maven-repo
Exasol…
Flip
- 1
0
votes
1 answer
How to pivot a table without PIVOT function?
I have a table like:
YEAR_WEEK
CHANNEL_A
CHANNEL_B
CHANNEL_C
...
2022-11
40
10
5
...
2022-12
50
20
6
...
2022-13
60
30
7
...
I need to pivot the data, so that the table is shown…
Vega
- 2,661
- 5
- 24
- 49
0
votes
2 answers
Exasol_Error: I keep getting Exasol connection error timed out
I am trying to connect to my Exasol SaaS database, I tried via these tools(TALEND, DBVISUALIZER, POWERBI) and via python but I cannot connect and I keep getting the same error.
I saw another post on Exasol community…
Josh2187
- 13
- 2
0
votes
2 answers
Is there a way to restart an Exasol database instance automatically
For reasons outlined here: https://community.exasol.com/t5/discussion-forum/performance-on-premise-dropping/td-p/9029 we need to restart a database regularly (at least until al issues are resolved, and this can take some time). So the question…
Ronald
- 1
- 1
0
votes
0 answers
Transform/project geometry data to or from CRS not listed in EXA_SPATIAL_REF_SYS in exasol
Is it possible to transform geometry data from a custom CRS, i.e. not listed in EXA_SPATIAL_REF_SYS table, e.g. via ST_TRANSFORM(g,srid) or set the CRS of a geometry to a custom CRS e.g. via ST_SETSRID(g,srid)?
In postgis it is for example possible…
NielsFlohr
- 183
- 7
0
votes
1 answer
Description formatting in Jira Python API
I am trying to create a issue in Jira with description containing a dataframe ,i am trying to display the dataframe data in table style but it looks like below when issue is created,display of header is not matching with values
enter image…
mallik
- 1