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

Adding output converter to pyodbc connection in SQLAlchemy

using: Python 2.7.3 SQLAlchemy 0.7.8 PyODBC 3.0.3 I have implemented my own Dialect for the EXASolution DB using PyODBC as the underlying db driver. I need to make use of PyODBC's output_converter function to translate DECIMAL(x, 0) columns to…
jank
  • 41
  • 2
3
votes
2 answers

Spring Data JPA, Hibernate and EXASOL database

I'm currently facing the problem to migrate an existing application using Spring Data JPA and Hibernate from an Oracle Database to EXASOL. This should in general not be a big problem but it seems like that it is not possible use Hibernate in…
Aldjinn
  • 705
  • 7
  • 15
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
2 answers

parameterized query with long string

I have a parametrized SQL query that I want to execute from (local) R on Exasol database as described here: https://db.rstudio.com/best-practices/run-queries-safely/#parameterized-queries. with tab as (select t.*, position(value in…
tomaz
  • 493
  • 4
  • 13
2
votes
1 answer

Tracking time of last modification in Exasol databases

In an Exasol database, we want to know for each row when it was last changed. Other DMBS offer things like hooks/triggers that run arbitrary functions, or even ON UPDATE statements. Searching for these terms, I couldn't find anything specific for…
Raphael
  • 9,779
  • 5
  • 63
  • 94
2
votes
1 answer

Exasol feature for writing query like plsql

I have multiple select statements and I have to execute a particular select statement based on parameter we passed to script in Exasol. This is pretty known to me in SQL server where we can achieve this functionality using inline function or stored…
Ganesh Gadakar
  • 37
  • 5
2
votes
2 answers

Rolling up multiple rows into a single row in exasol

I've ran the following query to find out the access rights assigned to each user : SELECT DISTINCT A.GRANTEE AS DB_ACCOUNT, B.PRIVILEGE AS ACCESS_RIGHTS FROM SYS.EXA_DBA_ROLE_PRIVS A INNER JOIN SYS.EXA_DBA_SYS_PRIVS B ON…
msbeast
  • 45
  • 1
  • 9
2
votes
0 answers

Import data from csv into a database table

I'm using Exasol database and want to insert data from a .csv file into a database table. Here is the script ALTER SESSION SET NLS_DATE_FORMAT= 'DD-MM-YYYY'; ALTER SESSION SET NLS_TIMESTAMP_FORMAT = 'DD-MM-YYYY HH24:MI:SS.FF3'; ALTER SESSION SET…
Squeez
  • 343
  • 2
  • 3
  • 15
2
votes
0 answers

The Exasol ADO.Net driver doesn't work with .NET Core

I can't connect to an Exasol Database using .NETCore, but I can using the full framework. To Reproduce: Install the EXASOL 6.0.2 ADO.NET Driver from here: https://www.exasol.com/portal/display/DOWNLOAD/6.0 In Visual Studio 2017, Create a new…
Jeff Gilbert
  • 31
  • 1
2
votes
2 answers

EXASol set a custom session variable

In SQL Server (2016) we have the SESSION_CONTEXT() and sp_set_session_context to retrieve/store custom variables in a key-value store. These values are available only in the session and their lifetime ends when the session is terminated. (Or in…
Pred
  • 8,789
  • 3
  • 26
  • 46
2
votes
1 answer

Custom Connection pool for Exasol Ado.Net provider

We are using a In memory database Exasol, which does provide a Ado.Net provider, but it seems to be missing some important functionality like ConnectionPooling, thus every connection is created and destroyed per request, which is impacting our…
Mrinal Kamboj
  • 11,300
  • 5
  • 40
  • 74
2
votes
1 answer

SQL data over week_no into columns

I would like to transpose the following SQL result: Asum  week_no a 1      22           a 2      24           into table like…
Janna Sherazi
  • 167
  • 1
  • 1
  • 15
2
votes
1 answer

DBI + ruby-odbc fails with Bundler involved

I'm connecting to Exasol using the dbi and ruby-odbc gems with unixodbc and it works fine, loaded like this: require 'dbi' require 'odbc_utf8' When I add Bundler to the mix, ruby-odbc doesn't seem to be able to find the odbc configuration: Could…
rausch
  • 3,148
  • 2
  • 18
  • 27
1
vote
1 answer

Get SRID of geometry column in exasol (ST_SRID equivalent)

It seems that there is no ST_SRID function in exasol like in other DBMS: SELECT ST_SRID(geom) FROM sampletable Is there an efficient workaround to determine the SRID of a geometry column? So far I only had success in parsing the COLUMN_TYPE string…
NielsFlohr
  • 183
  • 7
1
2 3 4 5 6