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
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
3 answers
Can't change date format SQL
I have the current date format [DD_MM_YYY] in a column on my table and would like to change it to [YYYY_MM_DD]. Can't seem to figure out the correct syntax.
0
votes
1 answer
How do I parametrize Lua script to go through table values executing queries
new with Lua but trying.
I have multiple "Create table" queries which I need to execute, what changes only is Schema and Table name.
At the moment I am explicitly defining each query.
I want to parametrize Lua script from the table below passing…
Shade
- 3
- 3
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
SQL calculate percentage between two columns
I would like to calculate the percentage between opened and delivered items by month. I have the following table:
date | delivered | opened
01/04/2021 1 1
01/04/2021 1
01/04/2021 1
08/05/2021 …
Omega
- 750
- 1
- 8
- 24
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
Hash_md5() in not working while merging in Exasol
I'm trying to merge and update target table based on Hash_val.
but i'm getting below error.
Such merge condition is not supported.
below is the code.
merge into table1 as t1
using table2 as t2
on…
Amit Kumar
- 613
- 3
- 15
0
votes
0 answers
Spark over JDBC uses an alias not allowed
Using Spark 2.4.0 and Exasol 6.2.0, I want to create a DataFrame over jdbc from a simple query SELECT * FROM table_name over JDBC.
This is the code in scala:
df = sparkSession.read
.format("jdbc")
.option("driver",…
nicolamarangoni
- 85
- 7
0
votes
1 answer
python asynchronous data pull error: __aexit__/__enter__
I am trying to write code leveraging async functionality of Python. I have a DB connection class where I have code for (dis)connecting with DB and also for fetching the data. Now I want to asynchronously fetch data using fetch data method based on…
Priya
- 285
- 4
- 14
0
votes
1 answer
Aggregate and join table with date columns falling between dates of consecutive rows of another table
I am trying to join two tables one with date column on another table with datetime column. The dates of the table say A might be equal are fall in between datetime range of consecutive rows in table B. I want to aggregate the values falling between…
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
Array aggregation in Exasol
Use case is fairly straightforward. In postgres I can aggregate values from a GROUP BY into an array:
select
customer,
array_agg(product_name) as items
from transactions
group by customer
customer …
Jivan
- 21,522
- 15
- 80
- 131
0
votes
1 answer
com.exasol.jdbc.EXAResultSet cannot be cast to com.mysql.cj.jdbc.result.ResultSetImpl java.lang.ClassCastException
I am trying to build a DatabaseTable (my custom object) object by querying using jdbc DatabaseMetadata and ResultSet.
Below code works perfectly fine if I run it against MySQL database, but it fails with exception when tried against Exasol…
Vishal Vyavahare
- 21
- 2
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
0 answers
SSH Tunnel Forwarding to connect to Exasol database through python and bash
I'll explain the situation and ask at the end.
I have a work computer, a Mac. On this Mac I have this command saved:
ssh -n -f -T -N -L {port} {server IP} {email} -i {path to secret RSA key}
(The curly braces are just to let you know what there is…
DevilHell
- 1
- 1