Re: [Flink SQL] CompilerFactory cannot be cast error when executing statement

2021-02-02 Thread Sebastián Magrí
Hi Timo! I've been building my jobs instead of using the binaries to avoid this issue, hence I've not looked at this again. But I'd say it's still an issue since nothing from the set up have changed in the meantime. Thanks! On Tue, 2 Feb 2021 at 08:51, Timo Walther wrote: > Hi Sebastian, > > s

Re: [Flink SQL] CompilerFactory cannot be cast error when executing statement

2021-02-02 Thread Timo Walther
Hi Sebastian, sorry for the late reply. Could you solve the problem in the meantime? It definitely looks like a dependency conflict. Regards, Timo On 22.01.21 18:18, Sebastián Magrí wrote: Thanks a lot Matthias! In the meantime I'm trying out something with the scala quickstart. On Fri,

Re: [Flink SQL] CompilerFactory cannot be cast error when executing statement

2021-01-22 Thread Sebastián Magrí
Thanks a lot Matthias! In the meantime I'm trying out something with the scala quickstart. On Fri, 22 Jan 2021 at 17:12, Matthias Pohl wrote: > Ok, to be fair, I just did some research on the error message and didn't > realize that you're working with binaries only. > > I tried to set it up on

Re: [Flink SQL] CompilerFactory cannot be cast error when executing statement

2021-01-22 Thread Matthias Pohl
Ok, to be fair, I just did some research on the error message and didn't realize that you're working with binaries only. I tried to set it up on my machine to be able to reproduce your error. Unfortunately, I wasn't able to establish the connection between Flink and Postgres using your docker-comp

Re: [Flink SQL] CompilerFactory cannot be cast error when executing statement

2021-01-22 Thread Sebastián Magrí
Hi Matthias! I went through that thread but as I'm just using the `apache/flink` docker image for testing I honestly couldn't figure out how I would do that since I don't have a pom file to edit. If it's possible to do it through the configuration I'd be glad if you could point me out in the right

Re: [Flink SQL] CompilerFactory cannot be cast error when executing statement

2021-01-22 Thread Matthias Pohl
Hi Sebastián, have you tried changing the dependency scope to provided for flink-table-planner-blink as it is suggested in [1]? Best, Matthias [1] http://apache-flink-mailing-list-archive.1008284.n3.nabble.com/Flink-1-10-exception-Unable-to-instantiate-java-compiler-td38221.html On Fri, Jan 22,

[Flink SQL] CompilerFactory cannot be cast error when executing statement

2021-01-22 Thread Sebastián Magrí
Hi! I'm trying out Flink SQL with the attached docker-compose file. It starts up and then I create a table with the following statement: CREATE TABLE mytable_simple ( `customer_id` INT ) WITH ( 'connector' = 'jdbc', 'url' = 'jdbc:postgresql://pgusr:pgpwd@postgres/pdgb', 'table-name' = 'm