Hi all, I am facing this issue attempting to write a DataFrame to a
table using Exasol JDBC.Upon the following
statement,test_table.write.format('jdbc').options(
url='jdbc:exa:'+exasol_adress, driver='com.exasol.jdbc.EXADriver',
dbtable='TEST.CSV_TAB...
Hi, I think I have encountered an issue with query caching.Query in
question is as follows:SELECT DISTINCT ( "PARTNER"."PARTNERNUMMER" ,
"PARTNER"."PARTNERNUMMER" , "PARTNER"."ANREDE" ,
"PARTNER"."AKADEMISCHER_TITEL" , "PARTNER"."AKADEMISCHER_TITEL_2...
I am attempting to migrate a MariaDB database to Exasol and I have
encountered an issue with the way Exasol handles empty VARCHAR ("").
When I try to insert entries that do have empty strings in the column
that has been defined as NOT NULL, these ent...
Greetings, dear reader,my name is Peter Výboch. I am knees deep in
data-processing by both, occupation and a hobby. I've been working in a
field professionally for something short of a year, mostly acquainting
myself with Spark and a number of databa...
Okay, it's weirder than that, it attempts to execute a following query
to CREATE TABLE TESTS.CSV_TABLE ("ID" TEXT , "NAME" TEXT , "LASTNAME"
TEXT )Where Exasol does not know the type TEXT
Hi @exa-Chris thanks. I am doing some tinkering of my own and I am
starting to suspect it's caused by some unescaped quotes that eat up a
comma somewhere.If I arrive at some results I'll post it here.Best
RegardsPeter
Hi Christian,coming back to this question, asked by the past me in the
previous version of the Exasol community, I now understand it's possible
to construct this kind of functionality using a pre-processor scripts,
granted, painstaking to write, yet ...