Search found 527 matches

by NorbertKrupa
Fri May 27, 2016 7:34 pm
Forum: General
Topic: Curl error with Splunk Rest api, receiving data from peer?
Replies: 1
Views: 5994

Re: Curl error with Splunk Rest api, receiving data from peer?

Hi, please clarify what your question has to do with Vertica.

Otherwise, we will have to remove your post as it is off topic for these forums.
by NorbertKrupa
Thu May 26, 2016 3:01 pm
Forum: General
Topic: Index small CSV file
Replies: 2
Views: 6631

Re: Index small CSV file

Is this question about Vertica or Splunk?
by NorbertKrupa
Mon May 23, 2016 7:46 pm
Forum: Vertica Database Administration
Topic: Memory usage
Replies: 5
Views: 14964

Re: Memory usage

My question: "wide" is referring to number of rows? number of columns ? Wide refers to the number of columns. The catalog may have improved in more recent versions, but wider tables could potentially degrade performance; especially if not optimized. Run DBD if you haven't already; it could potentia...
by NorbertKrupa
Mon May 23, 2016 3:10 am
Forum: New to Vertica
Topic: Home OS: server closed the connection unexpectedly
Replies: 2
Views: 22549

Re: Home OS: server closed the connection unexpectedly

I'm not well versed with VMWare, however with VirtualBox, an adapter will assign an IP address to the box and the OS will resolve it if it's configured properly. What is the IP address of your VM from the OS (ifconfig)?
by NorbertKrupa
Mon May 23, 2016 3:08 am
Forum: Vertica Database Administration
Topic: Memory usage
Replies: 5
Views: 14964

Re: Memory usage

Hi, We have a web-app platform that uses Vertica server. Our machines are on cloud, from AWS. Vertica cluster has 3 nodes, m3.2xlarge, 8 vCPU, 30 GB memory. SIze of the db files - 25 GB. The database contains around 10 tables, maximum 15.000.000 records/table, 1000 columns/table. Vertica does not p...
by NorbertKrupa
Mon May 23, 2016 3:05 am
Forum: Vertica Data Load
Topic: Copying column which has both , and "
Replies: 6
Views: 24201

Re: Copying column which has both , and "

How About this? csv file. 55682,"Bolts, Studs Click",2,Timer 55682,"Bolts”” Studs Click",2,Timer Enclosed by ‘”’ in copy command, rejects the second row. Removing the Enclosed by ‘”’ in the copy command, rejects the first. I would honestly recommend cleaning the data in a third party tool such as T...
by NorbertKrupa
Mon May 23, 2016 3:03 am
Forum: Vertica SQL
Topic: Alter Table is column exists
Replies: 1
Views: 15928

Re: Alter Table is column exists

That syntax is not supported in Vertica's ALTER TABLE. You may want to check a system table of columns whether the column exists before running an ALTER TABLE.

Go to advanced search