About LordBertson

LordBertson

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...

LordBertson · 13-10-2020

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...

LordBertson · 27-05-2020

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...

LordBertson · 27-05-2020

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...

LordBertson

Sorry for late response, it's just what I did and then it worked like a charm.

LordBertson

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

LordBertson

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

LordBertson · 19-10-2020

Thank you.

LordBertson · 27-05-2020

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 ...

User Statistics

User Activity

Facing a 'syntax error' upon trying to write a data into the table using Spark

Query caching issue

Issues with empty VARCHAR ("") and NOT NULL conditions

A word of introduction from LordBertson aka Peter Výboch

Re: Facing a 'syntax error' upon trying to write a data into the table using Spark

Re: Facing a 'syntax error' upon trying to write a data into the table using Spark

Re: Facing a 'syntax error' upon trying to write a data into the table using Spark

Re: Query caching issue

Re: Setting column DEFAULT value as a concatenation of other columns within CREATE TABLE statement

New to the Exasol Community?