"Server has closed the connection" while creating reflection for PostgreSQL table

21

Salam,

But when i want to display a pérode of dates from date(1) to date(n) :

date1

date2

date3

…

daten.

how I can do it .is there other clause SQL except recursive in which the Dremio support it.

thanks in advance.

22

Please is there an equivalent clause of with recursive

In Dremio.

THANKS.

23

Hi,

Thank you for your habitual reply.

Cordially,

ALI.

24

@alilos Let us keep this post for the issue on Postgres, is that resolved? Let us discuss the SQL in a separate post, are you able to create one?

25

I can’t work on Postgres because in our company we work only on MySQL and I think that not resolved using Postgres?.

In any case I’ll see with my team.

26

@alilos I am confused, then why is the title of this post on Postgres?

27

Maybe I was wrong only.

28

Hi

I’am always in waiting of your reply.

Cordially.

ALI.

DATA ANALYSTE ALGERIA.

29

@alilos OK, Just making sure I understand the problem

  • You are using MySQL
  • When scanning large number of rows you get the below error, right?
(java.sql.SQLNonTransientConnectionException) (conn=786851120) Server has closed the connection. If result set contain huge amount of data, Server expects client to read off the result set relatively fast. In this case, please consider increasing net_wait_timeout session variable / processing your result set faster (check Streaming result sets documentation for more information)

Please confirm?

30

Hi,

how i can connect into data source of dremio using Python pandas knowing that i have a windows 10 64 bits and python version 310

THANKS.

31

@alilos This is new topic, can we please open a new post with the right title?