Search found 18 matches
- Wed Oct 30, 2013 7:25 am
- Forum: Vertica Data Load
- Topic: Error about pload!!!
- Replies: 2
- Views: 7170
Re: Error about pload!!!
Maybe this link will help? http://dustycodes.wordpress.com/2012/02/09/increasing-number-of-threads-per-process/ Hi,Julie Thank for you reply.I had changed the linux parameters,for example linux parameter: [root@h02 vm]# more /proc/sys/vm/max_map_count 755127 [root@h02 kernel]# more /proc/sys/kernel...
- Wed Oct 30, 2013 5:15 am
- Forum: Vertica Database Administration
- Topic: some question about thread-count
- Replies: 3
- Views: 7534
Re: some question about thread-count
Hi , knicely87: The parameter EXECUTIONPARALLELISM about resource pool. Reducing this value increases the throughput of short queries issued in the pool, especially if the queries are executed concurrently. If you choose to set this parameter manually, set it to a value between 1 and the number of c...
- Wed Oct 30, 2013 4:28 am
- Forum: Vertica Database Administration
- Topic: some question about thread-count
- Replies: 3
- Views: 7534
Re: some question about thread-count
knicely87:
Thanks for your reply!
The second question is that how can I increase thread-count?
Thanks for your reply!
The second question is that how can I increase thread-count?
- Mon Oct 28, 2013 2:11 pm
- Forum: Vertica Data Load
- Topic: Error about pload!!!
- Replies: 2
- Views: 7170
Error about pload!!!
The file is 2GB,I use pload to copy record into vertica,without any error! smith=> copy test.tmp_gn_pdp_src_t with source PloadDelimitedSource(file='/opt/disk1/drdata/gnpdp001.txt') delimiter '|' null '' direct; Rows Loaded ------------- 6114952 (1 row) Time: First fetch (1 row): 47326.315 ms. All r...
- Mon Oct 28, 2013 7:18 am
- Forum: Vertica Data Load
- Topic: copy command execution in cluster.
- Replies: 4
- Views: 8239
Re: copy command execution in cluster.
In fact,vertica will find file on the first node,the second and the third node could not find file.you should put the files in the first node.then the count number will be 9. haimhai, Try changing: FROM '/data/files_to_load/*.gz' on v_test_node0001, '/data/files_to_load/*.gz' on v_test_node0002, '/d...
- Mon Oct 28, 2013 6:49 am
- Forum: Vertica Database Administration
- Topic: some question about thread-count
- Replies: 3
- Views: 7534
some question about thread-count
Hi,all I have some question about vertica's thread-count.How can I monitor the real thread-count per user(DB). When I used vioperf check disk IO performence,I find when the thread-count increase,"IO wait %" will increase. I think that the thread-counts are in direct proportion to the number of cpu c...
- Thu Sep 05, 2013 3:51 am
- Forum: Hadoop Connector
- Topic: "select * from mrtarget" return no data.
- Replies: 1
- Views: 14894
"select * from mrtarget" return no data.
hi,everyone: When I test the hadoop-vetica-connect by use the hadoop-vertica-example in "Programmer's Guide"! hadoop jar hadoop-vertica-example.jar com.vertica.hadoop.VerticaExample -libjars /opt/cloudera/parcels/CDH-4.3.0-1.cdh4.3.0.p0.22/lib/hadoop/lib/hadoop-vertica.jar,/opt/cloudera/parcels/CDH-...