Search found 3 matches

by sldahlin
Tue May 19, 2015 7:24 pm
Forum: Vertica Database Administration
Topic: number of sessions greater than max
Replies: 0
Views: 4042

number of sessions greater than max

We are getting some issues with exceeding the max available vertica sessions. I can close individual sessions to fix but trying to understand how it can show more than the max number of sessions available which is 50 (plus 5 admin sessions). At some points it is over 100. This seems confusing and ha...
by sldahlin
Wed Apr 29, 2015 4:06 pm
Forum: Vertica SQL Functions
Topic: trying to get view ddl using python
Replies: 2
Views: 16441

Re: trying to get view ddl using python

Using the odbc driver that comes with vertica 7.0.0.0: libverticaodbc.so
by sldahlin
Tue Apr 28, 2015 10:05 pm
Forum: Vertica SQL Functions
Topic: trying to get view ddl using python
Replies: 2
Views: 16441

trying to get view ddl using python

We have a need to get the ddl for a view using python. However it comes back empty using select export_objects() since the view is apparently too large for the buffer. Thought about chunking thru the ddl using substr sections but cannot use substr on the meta function export_objects. Then thought pe...

Go to advanced search