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
0
votes
2 answers

Loading EXASOL data in R. Unknown ODBC error

R is unable to read the EXASOL Database due to some unknown ODBC error. Has anyone come across a similar instance. The problem occurs with Mac OS. I have installed the ODBC driver for Mac OS. library(exasol) library(RODBC) con <-…
der_radler
  • 549
  • 1
  • 6
  • 17
0
votes
1 answer

Updating table from a view, error: table must be contained in source tables, but was not found

I'm trying to update a table from a view in Exaplus (which uses the Lua scripting language) but I keep getting the same error. A simple update to the schema_1 table works but when I try updating a table with a view from schema_2 I always get the…
ire
  • 491
  • 2
  • 12
  • 26
0
votes
1 answer

How to turn off pre-check of how many rows are in the resultset in logstash output

I'm trying to turn off the pre-select logstash does to determine the count of rows, but ExaSol DB does not support any limits in any aggregation, is there any way to turn it off in logstash? input { jdbc { jdbc_driver_library =>…
d0mik
  • 1
0
votes
1 answer

Rename Table not working in Exasol despite user having alter table privileges

I am unable to rename a table in Exasol despite using having Alter Table privilege. Created a user with Alter Table privilege and tried renaming a test table but it didn't worked. The error that I receive is : [42500] insufficient privileges for…
msbeast
  • 45
  • 1
  • 9
0
votes
0 answers

Hibernate createNativeQuery does replace placeholder for Exasol dialect

I have a small spring boot 2 application, where I want to import a csv into Exasol using hibernates native query. Exasol offers its own SQL flavor to import a file from a remote server, hence the native query. my repository: @Component public class…
Gregsen
  • 471
  • 1
  • 5
  • 15
0
votes
1 answer

How to delegate script execution to different nodes in exasol?

I am trying to add a couple of million rows to a table in exasol one column is supposed have increasing integer values (1 - xmio). I can't get my python script to run in parallel and distribute the load to different nodes in the cluster. Because of…
Lennart
  • 47
  • 8
0
votes
1 answer

How to import multiple csv files to Exasol with error logging

I want to import multiple csv files into Exasol db. Actually it is one huge file, and I already chunked it to massivly improve import performance. Exasol supports parallel import of multiple files: IMPORT INTO target_table FROM CSV AT…
phgie
  • 23
  • 3
0
votes
1 answer

Updating multiple tables in single update statement - Exasol

Using the below statement it gives error in Exasol however it will work in MySQL update u1, u2 set u1.name='H' ,u2.name='H' from u1 u inner join u2 us on (u.id=us.id); Is there a way to to update multiple tables in single update query in Exasol?
Ganesh Gadakar
  • 37
  • 5
0
votes
1 answer

What SQL queries are created with ExaPlus to produce the menu in the left side (schema, table & views,.. connections)?

I am considering what information should be provided under Article 15 (3) GDPR regarding the use of Exasol and ExaPlus. I don’t have SELECT ANY DICTIONARY system privilege to figure out this question by myself. What SQL queries are created with…
Peggy
  • 15
  • 6
0
votes
1 answer

Connecting to Exasol DB through SQL Alchemy error

I am trying to connect to Exasol DB through SQL Alchemy I installed SQL Alchemy using: pip install sqlalchemy-exasol Code is below: from sqlalchemy import create_engine e =…
JD2775
  • 3,658
  • 7
  • 30
  • 52
0
votes
2 answers

Executing multiple statements in Exasol as we do in SQL server procedure

When we have multiple select statements we can put them in one procedure and execute it one go. However in Exasol so we have any functionality where we can write in Script/Function where we can execute the multiple statements. For eg : Select…
Ganesh Gadakar
  • 37
  • 5
0
votes
1 answer

How to enable JDBC connection pooling on Exasol?

We use Hibernate with Exasol in a web app. When we set Hibernate's hibernate.connection.pool_size property to a value greater than 1 (or the corresponding property of any JDBC connection pool, e.g, HikariCP, c3p0, to a value greater than 1), we…
gdrt
  • 3,160
  • 4
  • 37
  • 56
0
votes
1 answer

Exasol: Tables or logs where queries executed using an application/reporting server server

I have a reporting application connected to exasol server where queries are executing on that exasol server. I need the logs or tables where i can find the queries executed while I completed the execution of report. Note: I am looking for tables/…
Ganesh Gadakar
  • 37
  • 5
0
votes
1 answer

Executing query in query function using a variable in Exasol

I am trying to execute dynamic query in Exasol using script function. Following is the code: CREATE or replace SCRIPT script_2(a) RETURNS TABLE AS quer="select * from table_name cross join table_name" for i=1, 3 do quer=quer .. " table_name" …
Ganesh Gadakar
  • 37
  • 5
0
votes
1 answer

SQL Developer connection to Exasol DB

How can I connect SQL Developer to an Exasol DB? Is this possible? I tried to download the Exasol driver but is not recognized by the SQL Developer.
Cosmin
  • 21
  • 2
1 2 3
4
5 6