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

Creating replica of one schema to another schema in Exasol

Can anyone help me with creating a replica in EXASOL i.e. I need to copy all the tables including Views,Functions and Scripts from one schema to another schema in the same server. For Eg.: I want all the data from Schema A to be copied not moved to…
msbeast
  • 45
  • 1
  • 9
0
votes
1 answer

Final member of the sequence between two columns of a table

I have a table which have primarily 3 columns I am interested in: old_item_id, new_item_id and date_of_change. I want to traverse the sequence and want to find out latest id of some item ids. Example data below: old_item_id new_item_id…
abhiieor
  • 3,132
  • 4
  • 30
  • 47
0
votes
1 answer

How to migrate data from one exasol version 5 to exasol version 6 without using files?

I wish to migrate data from exasol to exasol, but do not wish to use files as it would take a lot of time to move terabytes of data. I am totally new to exasol and have never worked on migration. Script is given on github…
K_Learner
  • 23
  • 6
0
votes
0 answers

How to return number from JSON string?

I would like to pull the 13 digit number from this JSON string: {"timeline":{"events":[]},"ongoingSLAData":null,"completeSLAData":[],"metricId":1024,"definitionChangeDate":1498910425180,......... Is it possible using SQL to pull this number out,…
user7431342
  • 43
  • 8
0
votes
1 answer

Python connection with Exasol - export to pandas

I have problem with export data to pandas from Exasol v.6.0.4. I can connect with Exasol but when I want to transport data to pandas DataFrame then I have error. I'm using library pyexasol. My code is following: from pyexasol import…
Przemysław Kaczmarek
  • 1
  • 2
0
votes
1 answer

Python connection to EXASOL which has encryption turned on

I am trying to connect to encrypted exasol database through python. It connects without issues when it is unencrypted. EXASOL.connect seems to be based on pyodbc, does anyone had success in using pyodbc with encryption turned on? I tried to pass the…
Gunay Anach
  • 1,193
  • 1
  • 13
  • 19
0
votes
0 answers

Error in inserting data into Database from CSV

I'm trying to import data from csv to database. Below is my code. The problem is while importing some files it shows below error and other gets loaded successfully. java.sql.SQLException: syntax error, unexpected STYLE_, expecting identifier_chain2…
Squeez
  • 343
  • 2
  • 3
  • 15
0
votes
0 answers

What is the correct way of incorporating schema name into Exasol connection string URL?

I'm using Hibernate to connect to Exasol Database using Exasol Hibernate Dialect. When I use the following persistence.xml, everything works fine: exasol …
gdrt
  • 3,160
  • 4
  • 37
  • 56
0
votes
1 answer

How sql loader scrip is working?

Currently I'm working with Exasol database first time and came across one script which is responsible to run sql script written in .sql file. Here is the script C:\Program Files\EXASOL\EXASolution\EXAplus\exaplusx64.exe -configDir EXASolutionConfig…
LearnJava
  • 372
  • 1
  • 4
  • 16
0
votes
1 answer

Constraint violation when merging into table

I'm having a staging table and a datawarehouse table, which keep giving me constraint violation. i can't seem to figure out why since DRIVERID and RACEID a combination of those should be unique? How come i get contraint violation - primary…
Peter Pik
  • 11,023
  • 19
  • 84
  • 142
0
votes
2 answers

Exasol SQL TIMESTAMP query

I have a Exasol datatable with a column that looks like this: 2016-10-25 08:01:36.0 2016-10-25 08:30:09.0 2016-10-25 09:00:15.0 2016-10-26 08:02:38.0 2016-10-26 10:00:44.0 2016-10-27 10:00:44.0 the datatype of that column is…
BlainTheMono
  • 49
  • 9
0
votes
1 answer

Exasol vs HBase

I'm quite new to BigData architecture so please don't be to harsh on me. I am trying to figure out the best alternative to build a BI Architecture able to deal with huge amounts of data. As I see it, the solution has to be clustered/horizontally…
aluncob
  • 87
  • 2
  • 12
0
votes
2 answers

Exasol and ESRI's ArcGIS - anyone managed to link them up?

I'm looking to utilise the speed of Exasolution with the mapping capabilities of ArcGIS. Exasolution is an extremely fast database. It has spatial support, but I'd like to be able to render spatial features inside a map. So it could be via some…
JudgeNutmeg
  • 1
0
votes
0 answers

Why one of the predicates would lead to too big intermediate results?

I am trying to left-merge two small tables given by sub-select and get an error message: One of the predicates would lead to too big intermediate results. Table date_rabges_table has more than 5000000 rows or is bigger than 5000000 KB The query…
Roman
  • 124,451
  • 167
  • 349
  • 456
-1
votes
3 answers

GROUP BY with CASE WHEN?

I have table k with: num2 | count aa1 | 10 aa2 | 5 bb | 2 bb | 4 cc | 80 And table t with: num1 | num2 a | aa1 a | aa2 " " | bb " " | bb " " | cc Now I would like to get MIN and MAX count for every num1 while replacing " " in num1…
Vega
  • 2,661
  • 5
  • 24
  • 49
1 2 3 4
5
6