Search found 18 matches

by muaythai_duan
Wed Oct 30, 2013 7:25 am
Forum: Vertica Data Load
Topic: Error about pload!!!
Replies: 2
Views: 7092

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...
by muaythai_duan
Wed Oct 30, 2013 5:15 am
Forum: Vertica Database Administration
Topic: some question about thread-count
Replies: 3
Views: 7421

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...
by muaythai_duan
Wed Oct 30, 2013 4:28 am
Forum: Vertica Database Administration
Topic: some question about thread-count
Replies: 3
Views: 7421

Re: some question about thread-count

knicely87:
Thanks for your reply!
The second question is that how can I increase thread-count?
by muaythai_duan
Mon Oct 28, 2013 2:11 pm
Forum: Vertica Data Load
Topic: Error about pload!!!
Replies: 2
Views: 7092

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...
by muaythai_duan
Mon Oct 28, 2013 7:18 am
Forum: Vertica Data Load
Topic: copy command execution in cluster.
Replies: 4
Views: 8135

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...
by muaythai_duan
Mon Oct 28, 2013 6:49 am
Forum: Vertica Database Administration
Topic: some question about thread-count
Replies: 3
Views: 7421

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...
by muaythai_duan
Thu Sep 05, 2013 3:51 am
Forum: Hadoop Connector
Topic: "select * from mrtarget" return no data.
Replies: 1
Views: 14074

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

Go to advanced search