Hello,
You might find this helpful.
viewtopic.php?f=7&t=558&p=6188&hilit=OBIEE#p6188
If its on Windows platform, you can us the ODBC / JDBC drivers provided by Vertica to connect.
Hope this helps.
Search found 302 matches
- Tue Jul 01, 2014 6:36 am
- Forum: New to Vertica
- Topic: OBIEE 11g connectivity with Vertica database
- Replies: 3
- Views: 8440
- Fri Jun 13, 2014 6:54 am
- Forum: New to Vertica
- Topic: Best encoding type for people's names
- Replies: 3
- Views: 8267
Re: Best encoding type for people's names
Just to add to norbert's reply.
IF you are running DBD make sure, you have enough of sampling data in the table / column for the DBD
Hope this helps
IF you are running DBD make sure, you have enough of sampling data in the table / column for the DBD
Hope this helps
- Fri May 30, 2014 5:49 am
- Forum: Announcements, Events and Activities
- Topic: Introducing Vertica Dragline ( Vertica 7.1 )
- Replies: 0
- Views: 4466
Introducing Vertica Dragline ( Vertica 7.1 )
Check this out,
New release announced by Vertica.
http://www.vertica.com/2014/05/28/intro ... -dragline/
New release announced by Vertica.
http://www.vertica.com/2014/05/28/intro ... -dragline/
- Wed May 28, 2014 7:48 am
- Forum: Vertica Database Administration
- Topic: The last data inserted in a Table
- Replies: 4
- Views: 12625
Re: The last data inserted in a Table
Hi Jim, I believe the epochs table flushes out the data on regular intervals as I cannot find much information or records on older epochs. So if the data inserted was today for a table surely, we can check what was the last data inserted in table today, but if the data was inserted 3 days back, it h...
- Tue May 13, 2014 6:03 am
- Forum: New to Vertica SQL
- Topic: How to group all values in a column into one column value
- Replies: 2
- Views: 9216
Re: How to group all values in a column into one column valu
Hello Verti,
Using Group concat functions is the easiest way to implement this.
Other then this, if you can't use this function and want pure SQL solution, there is an excellent workaround by jim here
http://www.vertica-forums.com/viewtopic.php?f=48&t=160
Hope this helps
Using Group concat functions is the easiest way to implement this.
Other then this, if you can't use this function and want pure SQL solution, there is an excellent workaround by jim here
http://www.vertica-forums.com/viewtopic.php?f=48&t=160
Hope this helps
- Tue May 13, 2014 5:57 am
- Forum: Vertica SQL
- Topic: ERROR 2559: Cannot use subquery in expressions within COPY
- Replies: 1
- Views: 4871
Re: ERROR 2559: Cannot use subquery in expressions within C
Hello, You cannot use a sybquery inside a COPY statement. COPY command is bulk loader utility in Vertica which loads the data from files or STDIN. it is not capable of loading data from another table. Please refer the documentation https://my.vertica.com/docs/7.0.x/HTML/index.htm#Authoring/Administr...
- Tue May 06, 2014 6:25 am
- Forum: Vertica Management Console
- Topic: MC internals
- Replies: 1
- Views: 13991
MC internals
Hello All, Where does vertica take all this info from ? 1. IP : 2. em1 : 3. p2p1 : 4. Name : 5. Total Mem : 6. Disk utiliztion : 7. CPU Count: 8. Hostname : Also what does em1 / p2p1 stand for.. I tried to track the simplyfast.py but could not find it in /opt/vertica/oss/python/bin/python Is this th...