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
1 answer

How to filter date range from "date" - 2 weeks and "date" + 2 weeks

I have a table t like: VALID_FROM | VALID_TO | stock 2020-10-01 | 2020-10-02 | 10 2020-10-02 | 2020-10-04 | 9 2020-10-04 | 2020-10-08 | 5 ... | ... | 2020-12-15 | 2020-12-16 | 0 I need to set a date range for a specific date…
Vega
  • 2,661
  • 5
  • 24
  • 49
1
vote
1 answer

Exasol Update Table using subselect

I got this statement, which works in Oracle: update table a set a.attribute = (select round(sum(r.attribute1),4) from table2 p, table3 r where 1 = 1 and some joins ) where 1 = 1 and a.attribute3 >…
Aaron R.
  • 93
  • 2
  • 9
1
vote
0 answers

Trigger in Exasol DB

How to simulate the functionality of triggers in exasolDB? Like: CREATE TRIGGER [schema_name.]trigger_name ON table_name AFTER {[INSERT],[UPDATE],[DELETE]} [NOT FOR REPLICATION] AS {sql_statements}
swapna p
  • 83
  • 7
1
vote
2 answers

Add multiple columns using alter command in Exasol DB

Is it possible to add multiple columns to a table in a single query execution, using alter table in exasol? example: Alter table Employee add column phone_number varchar(256), add column address varchar(256)
swapna p
  • 83
  • 7
1
vote
1 answer

Getting Error non-negative integer value expected in LIMIT clause

I want to fetch data from exasol but only facing this issue when I use limit clause in query. If i hardcode the limit values in query and don't use prepared statement for then it works fine. But when I try to set int for limit clause in prepared…
Faizan
  • 289
  • 4
  • 15
1
vote
1 answer

EXASOL: Convert table data generated from query to json data (For creating graphs)

I am trying to convert data from sql query to json format where different data would be considered for categories, Data values, Series directly in a graph. In SQL server we have a function called FOR JSON AUTO ; is there something similar in Exasol…
1
vote
3 answers

Variable declaration in Exasol

I am new with Exasol and haven't found out how one can declare a variable as in SQL. In SQL I would write: DECLARE @variable_name datatype [ = initial_value ] And in Exasol? Many thanks in advance for the help.
Emanuela Liaci
  • 165
  • 1
  • 12
1
vote
0 answers

Connecting in R with dbConnect and odbc fails, but connecting with RODBC works fine. Why?

I am trying to connect to an EXASol database through odbc using R. After setting up the DSN, I can connect to the database using the RODBC package. odbc_channel <- odbcConnect("exa", uid = "username", pwd = "password") This…
Kevin Lu
  • 31
  • 2
1
vote
2 answers

How to Delete Using Join EXASol

I want to delete some records from a table using Join in EXAsol. I am trying - Delete tran FROM Transactions tran INNER JOIN Employees e ON tran.ID = e.Transaction_ID WHERE e.Name = 'Abhisar'; The error I am getting is - syntax error,…
1
vote
1 answer

SQL - Window function to get values from previous row where value is not null

I am using Exasol, in other DBMS it was possible to use analytical functions such LAST_VALUE() and specify some condition for the ORDER BY clause withing the OVER() function, like: select ... LAST_VALUE(customer) OVER (PARTITION BY ID ORDER BY…
Alg_D
  • 2,242
  • 6
  • 31
  • 63
1
vote
1 answer

EXASOL export to csv with quotes

I want to export a database-tab to csv-file with quotes arround any string (column separator is ";"). This is what I want as csv file (without header): "abc";"blabla" When I export just with "Select * from...", no quotes surround the…
flobrr
  • 197
  • 1
  • 2
  • 13
1
vote
0 answers

Import all tables from a specific schema in an Exasol DB to Hive using sqoop

I´m trying to import all tables from a specific schema of an Exasol DB to Hive like this: sqoop import-all-tables \ --connect 'jdbc:exa:;schema=' \ --driver com.exasol.jdbc.EXADriver --username user --password pw -m 1…
moli
  • 11
  • 3
1
vote
1 answer

Searching for the datasource of tables in a schema

I've been tasked with trying to find the datasources in one of our system schemas. Is there an SQL statement that can do this? I've tried googling and checking the Exasol User Manual but can't find anything.
1
vote
0 answers

Connecting to EXASOL from AWS/Lambda/.NETCore/C#/ADO.Net/Visual Studio 2017

I am writing an AWS Lambda function in Visual Studio 2017 and C# that needs to execute an Exasol script. I think my problem is figuring out which Assemblies and NuGet packages to reference. I’ve installed: EXASolution_ADO.NET-5.0.17.msi and I’m…
1
vote
0 answers

Tableau on Spark Sql performance benchmarks

Are there benchmarks for SparkSql being used as the primary reporting warehouse for Tableau? Size of the reporting warehouse is in a few TBs. How does SparkSql's performance compare against Redshift, Exasaol and Presto for use with Tableau? What…