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
2 answers
sum last n days quantity using sql window function
I am trying to create following logic in Alteryx and data is coming from Exasol database.
Column “Sum_Qty_28_days“ should sum up the values of “Qty ” column for same article which falls under last 28 days.
My sample data looks like:
and I want…
Pardeep Naik
- 99
- 1
- 12
0
votes
1 answer
REGEXP_REPLACE not replacing a new character
I need to replace all instances where a new line is not followed by a colon. This is because colon indicates the start of a new record (a record may span multiple lines).
REGEXP_REPLACE(raw,'(\n[^:])','this is a test')
For example, with the…
Anthony Wood
- 395
- 1
- 3
- 16
0
votes
1 answer
How to handle identity/ autoincrement columns when writing to Exasol DB?
I have an Exasol table with an autoincrement primary key and want to fill it using import_from_pandas from pyexasol.
By importing to exasol table I have to leave the RKEY out since Exasol auto increments it. But leaving rkey empty or not creating…
luuuusss
- 1
- 1
0
votes
0 answers
Dynamic transpose of rows to column without pivot (Number of rows are not fixed all the time)
i have a table like
a 1
a 2
b 1
b 3
b 2
b 4
i wanted out put like this
1 2 3 4
a a
b b b b
Number of rows in output may vary.
Pivoting is not working as it is in exasol, and case cant work as it is dynamic
0
votes
1 answer
Unable to export in parallel from Exasol using pyexasol
I'm attempting to fetch data from Exasol using PyExasol, in parallel. I'm following the example here - https://github.com/badoo/pyexasol/blob/master/examples/14_parallel_export.py
My code looks like this :
import multiprocessing
import…
SpaceMonkey
- 25
- 1
- 4
0
votes
1 answer
How do I connect to Exasol from Scala?
I want to connect to ExaSol database using Scala. I'm able to connect to the database in Python using pyodbc but I'm receiving the following error on attempting to connect using JDBC driver in Scala :
scala> :require…
SpaceMonkey
- 25
- 1
- 4
0
votes
0 answers
How to configure Kafka connect sink connector for exasol databse
I am trying to setup kafka sink connector for writing to exasol database.
I have followed https://www.confluent.io/blog/simplest-useful-kafka-connect-data-pipeline-world-thereabouts-part-1/ this article.
Since I could not find any similar sink…
Vishal Vyavahare
- 21
- 2
-1
votes
1 answer
How to search for 2 single quote signs ('') in a LIKE statement?
I have a text field which I need to check if this char combination '' (not to be confused with ") appears anywhere in the column.
This SQL code
SELECT TEXTFIELD
FROM MYTABLE
WHERE TEXTFIELD LIKE '%''%'
returns text like
BARN'S
which does not…
Vega
- 2,661
- 5
- 24
- 49