Stack Overflow
Stack Overflow

Questions tagged [exasolution]

EXASolution is an in-memory RDBMS for business intelligence solutions

EXASolution is a relational database management systems, developed by EXASol, and it aims to be a high-speed database (it runs parallelized on a cluster of standard hardware servers, data is stored compressed in a column-oriented way, it is designed to run in memory).

76 questions
1
vote
2 answers

Exasol Extrackt from Timestamp Hours AND Minutes

I have a Exasol database with Login values of datatype TIMESTAMP like: 2015-10-01 13:00:34.0 2015-11-02 13:10:10.0 2015-10-06 13:20:03.0 2016-02-01 14:15:34.0 2016-04-03 14:08:10.0 2016-07-01 11:05:07.0 2016-09-03 10:08:12.0 2016-11-15…
BlainTheMono
  • 49
  • 9
1
vote
2 answers

EXASOL Explain Analyse Query

I want to get the query plan in Exasol database to check the total execution time, memory and cpu usage. Profiling in Exasol is so complex and difficult to understand. Is there any way to get the query plan like explain analyze in PostgreSQL or any…
Arezoo
  • 452
  • 1
  • 5
  • 15
1
vote
1 answer

Why subselect makes the SQL-request slower?

I have the following code: select * from table_1 join table_2 on table_1.col1 = table_2.col1 where table_2.col2 = 1 This query works and give me the results that I expect. Now I would like to optimize this query. The idea is…
Roman
  • 124,451
  • 167
  • 349
  • 456
1
vote
2 answers

Put rows into columns

I have a table of these columns: userID, date, NumberofLogins Basically records on which date how many times the user has logged in. How can I turn this into a table with the following one using SQL query? UserID, NumberofLoginsDate1,…
user1552372
  • 111
  • 6
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
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

how to enableJsonFunctions=1 in exasol database?

I am trying to search for exasol paramter value to enable json functions JSON_EXTRACT , JSON_VALUE etc. My exasol version is 6.2 , But unable to use the functions. Can someone quide me on how to enable it from Database ? I have checked the values in…
deep sarkar
  • 3
  • 2
0
votes
2 answers

How to calculate value based on average of previous month and average of same month last year in SQL

I would like to calculate targets for opened rates and clicked rates based on actuals of the last month and the same month last year. My table is aggregated at daily level and I have grouped it by month and year to get the monthly averages. I have…
Omega
  • 750
  • 1
  • 8
  • 24
0
votes
1 answer

How can I filter for CURRENT_DATE / SYSDATE - 2 years?

I have a table t with a column "date" which has the type "DATE": date 2018-10-01 2019-02-03 2020-01-01 2021-01-01 I want to get only entries where CURRENT_DATE / SYSDATE minus 2 years is true. So the result should be (CURRENT_DATE / SYSDATE =…
Vega
  • 2,661
  • 5
  • 24
  • 49
0
votes
2 answers

How to select only ids that contain a column value of 0 in a date range?

I have a table t like: VALID_FROM | VALID_TO | id | stock 2020-10-01 | 2020-10-02 | 1 | 10 2020-10-02 | 2020-10-04 | 1 | 9 2020-10-04 | 2020-10-08 | 1 | 5 2020-11-12 | 2020-11-26 | 1 | 4 ... | ... | 1 | 2020-12-15 | 2020-12-16 |…
Vega
  • 2,661
  • 5
  • 24
  • 49
0
votes
2 answers

Upload data to Exasol from python Dataframe

I wonder if there's anyways to upload a dataframe and create a new table in Exasol? import_from_pandas assumes the table already exists. Do we need to run a SQL separately to create the table? for other databases, to_sql can just create the table if…
xkeecs
  • 25
  • 5
0
votes
1 answer

How to specify data type in PyExasol export_to_pandas

How can I pass datatype parameters in export_to_pandas API. and can I change column names to lower cases ? from pyexasol import ExaConnection con = ExaConnection(dsn=dns, user=user, password=password) con.execute('OPEN SCHEMA SCHEMATEST1') data =…
xkeecs
  • 25
  • 5
0
votes
1 answer

Correlated subquery in Exasol

I try to write a subquery using SQL in Exasol database. The problem is similar to this thread (SQL Query - join on less than or equal date) and the code works well in mysql and postgres. However, when I move the code to Exasol, it says SQL Error…
xkeecs
  • 25
  • 5
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
1 2
3
4 5 6