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
3
votes
1 answer
How to use variables in SQL queries on DataGrip (Exasol dialect)?
Database: EXASOL
IDE: IntelliJ DataGrip
I am trying to declare variables in SQL and call them throughout the query.
This is the equivalent in Microsoft SQL Server:
DECLARE @var AS INT = 3
SELECT @var AS var
-- Use case example:
SELECT * FROM table1…
mjeshtri
- 263
- 1
- 5
- 15
2
votes
2 answers
SQL get last column in a group based on order by and value of another column
From the table below, I am trying to create another column (last_k2X) that will show the last key2 where type was set to 'X' over time (ti).
In case X was set at the same time (ts) for multiple key2, (in same key1 partition), the new column last_k2X…
Alg_D
- 2,242
- 6
- 31
- 63
2
votes
1 answer
trying to import csv file to table in sql
I have 4 csv files each having 500,000 rows. I am trying to import the csv data into my Exasol databse, but there is an error with the date column and I have a problem with the first unwanted column in the files.
Here is an example CSV…
Shahin
- 25
- 3
2
votes
1 answer
Datatype mismatch error because of NULL values in union operation
AFAIU, an SQL engine internally assigns a datatype to NULL values, for example, some engines use the datatype integer as default. I know, that this may cause an error in UNION operations when the column of the other table is not compatible (e.g.…
Mark Heckmann
- 10,943
- 4
- 56
- 88
2
votes
1 answer
Sql Limit clause based in input Parameter
I have been trying to find a solution for a limit-clause based on an input parameter from a Json-File. The current code looks somewhat like this
With myJsonTable (JsonText)
as (
Select JsonText)
Select * from Data
Where...
Limit
Case
WHEN…
R Stub
- 23
- 4
2
votes
0 answers
Informatica, [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified error when connecting to Exasol database
I am trying to connect to Exasol database from Informatica where I want to do some read and write operations but getting below error when running the session.
I have added driver details in ODBC Data Source Administrator.
Message Code:…
Mahendra Dhaker
- 43
- 8
2
votes
1 answer
pandas to_sql with Exasol
When I use to_sql to upload dataframe to exasol and specify if_exists='replace', the default string data type is 'text', which is not supported by Exasol. I think Varchar is the right type. How could I make to_sql to create table with Varchar rather…
xkeecs
- 25
- 5
2
votes
0 answers
How install and start Exasol community on DigitalOcean droplet?
one of my projects needs a fast analytical database, now I use memsql, I would like to test Exasol, but I still can’t figure out how to deploy it to DigitalOcean droplet, does anyone have any detailed instructions on how to do this?
Andrey
- 21
- 1
2
votes
2 answers
List of days between two dates in Exasol
In PostgreSQL, it's fairly easy to generate a list of all days between two dates:
>>> select generate_series('2013-01-01'::date, '2013-01-06'::date, '1 day'::interval)::date i;
i
2013-01-01
2013-01-02
2013-01-03
2013-01-04
2013-01-05
2013-01-06
Is…
Jivan
- 21,522
- 15
- 80
- 131
2
votes
0 answers
How to fetch table name using Jdbc from ResultSetMetaData
I am trying to get Preview(data) of a table by querying using jdbc DatabaseMetadata and ResultSet.
Below code works perfectly fine if I run it against MySQL database and returns table name as well as data correctly, but it gives EMPTY tableName if…
Vishal Vyavahare
- 21
- 2
2
votes
1 answer
Pandas timestamps in ISO format cause Exasol error when importing
When using pyexasol's import_from_pandas(df) for a DataFrame, df, which has a datetime column, Exasol (6.2) throws an error because it can't parse the ISO-formatted string representation of the dataframe column. Specifically, the "+00:00" final…
hamx0r
- 4,081
- 1
- 33
- 46
1
vote
1 answer
Performance difference between EXTRACT(MONTH FROM DATE_ID) vs. MONTH(DATE_ID)?
I have a table with a lot of columns and a few million rows.
One colum has column type "DATE":
DATE_ID
2022-10-01
2022-10-02
2022-10-03
...
Exasol does manage indexes itself so you can't set one.
When I need the month of the date…
Vega
- 2,661
- 5
- 24
- 49
1
vote
1 answer
SQL - escape "-" special character // json_extract with date as key
I'm running a query on exasol - trying to unpack data from a column.
Table has this format
KPI Progress_history
A {'2020-01-01': 100, '2020-02-01': 120}
my attempt referencing the documentation
select
kpi,
…
Adav
- 428
- 4
- 18
1
vote
2 answers
database query in rmarkdown/quarto document works in R chunk but fails in sql chunk
I work in an rmarkdown / quarto document querying a database (Exasol) with read-only access. This works fine if executed in an R chunk as follows.
```{r}
conn <- exasol::dbConnect( drv = "exa", exahost = "my_host_url",
uid =…
Mark Heckmann
- 10,943
- 4
- 56
- 88
1
vote
0 answers
Exasol not exporting in parallel to PostgreSQL
We have a connection in Exasol (v7.0.18) to PostgreSQL (v14) created like this
create or replace connection POSTGRES_DB to
'jdbc:postgresql://hostname:5432/my_db?useCursorFetch=true&defaultFetchSize=2147483648'
user 'abc'
identified by…
Anil Bharadia
- 2,760
- 6
- 34
- 46