Search found 3 matches
- 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...
- Wed Apr 29, 2015 4:06 pm
- Forum: Vertica SQL Functions
- Topic: trying to get view ddl using python
- Replies: 2
- Views: 16649
Re: trying to get view ddl using python
Using the odbc driver that comes with vertica 7.0.0.0: libverticaodbc.so
- Tue Apr 28, 2015 10:05 pm
- Forum: Vertica SQL Functions
- Topic: trying to get view ddl using python
- Replies: 2
- Views: 16649
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...