Skip to main content

Execute multiple queries simultaneously on a single session

  • May 31, 2016
  • 2 replies
  • 9 views

asher_1

Hey,

i noticed that JDBC Connection can execute only one statement in parallel. the second statement is executed once the first one ended.

i assume that the JDBC connection has a single session_id in Vertica, so my quetions are:

 

1. is it possible in Vertica to execute multiple queries on a single session in parallel?

2. can there be a situation in which the SESSIONS table contains several transaction per one session?

 

thanks,

Asher

2 replies

neo_i_am_the_one
Forum|alt.badge.img

Hi Asher,

Were you able to solve this question?

Thanks.


SruthiA
Forum|alt.badge.img+1
  • Participating Frequently
  • April 15, 2022

@neo_i_am_the_one: There is possibility of having several transactions per session. However they are executed in sequential fashion. Could you please share me your use case details?