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.
Search found 527 matches
- Fri May 27, 2016 7:34 pm
- Forum: General
- Topic: Curl error with Splunk Rest api, receiving data from peer?
- Replies: 1
- Views: 5999
- Thu May 26, 2016 3:01 pm
- Forum: General
- Topic: Index small CSV file
- Replies: 2
- Views: 6633
Re: Index small CSV file
Is this question about Vertica or Splunk?
- Mon May 23, 2016 7:46 pm
- Forum: Vertica Database Administration
- Topic: Memory usage
- Replies: 5
- Views: 15011
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...
- Mon May 23, 2016 3:10 am
- Forum: New to Vertica
- Topic: Home OS: server closed the connection unexpectedly
- Replies: 2
- Views: 22588
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)?
- Mon May 23, 2016 3:08 am
- Forum: Vertica Database Administration
- Topic: Memory usage
- Replies: 5
- Views: 15011
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...
- Mon May 23, 2016 3:05 am
- Forum: Vertica Data Load
- Topic: Copying column which has both , and "
- Replies: 6
- Views: 24267
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...
- Mon May 23, 2016 3:03 am
- Forum: Vertica SQL
- Topic: Alter Table is column exists
- Replies: 1
- Views: 15981
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.