Search found 302 matches

by nnani
Tue Jul 01, 2014 6:36 am
Forum: New to Vertica
Topic: OBIEE 11g connectivity with Vertica database
Replies: 3
Views: 8441

Re: OBIEE 11g connectivity with Vertica database

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.
by nnani
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
by nnani
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...
by nnani
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
by nnani
Tue May 13, 2014 5:57 am
Forum: Vertica SQL
Topic: ERROR 2559: Cannot use subquery in expressions within COPY
Replies: 1
Views: 4872

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...
by nnani
Tue May 06, 2014 6:25 am
Forum: Vertica Management Console
Topic: MC internals
Replies: 1
Views: 14011

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...

Go to advanced search