Hi, I'm hoping this is a very simple solution, I'm trying to find the type of queries being run on the database over a 10 minutes period, what is wrong with these 2 bits of SQL, both fail with syntax errors:- select timestampadd(mi,-10,getdate()), request_type, count(*) from QUERY_REQUESTS where sta...

Any idea why it would have node0006 to 0010 listed, but repeating the same ip address as node0001 to 0005?

Hi sKwa, The warning is from $TZ not being set. This is the admintools.conf, that explains the node name going to 11. Any idea why there would be duplicate entries? more admintools.conf [Configuration] install_opts = ['-A', 'brllxmvert06-icc', '-r', '/home/dbadmin/SWare/vertica-6.1.2-0.x86_64.RHEL5....

Hi, A couple of questions after adding a 6th node to a cluster using the following command:- /opt/vertica/sbin/update_vertica -A brllxmvert06-icc -r /home/dbadmin/SWare/vertica-6.1.2-0.x86_64.RHEL5.rpm What should $TZ be set to? The following is an extract from the install log:- Consistency Test (ok...

Thanks, but this will only work if the projections is aware of the 6th node. I tried this with a table that had projections segmented across nodes 1-5, after the refresh it still only had nodes1-5. Apart from creating new projections across all the nodes and then dropping the original projections th...

Hi, Just added a 6th node to the cluster and ran START_REBALANCE_CLUSTER to rebalance the cluster. After it had been running for about 9hours I stopped it using CANCEL_REBALANCE_CLUSTER. I then tried to run SELECT REBALANCE_CLUSTER(); But got the following error:- SELECT REBALANCE_CLUSTER(); ERROR 4...

Hi, What is the best way of identify currently active queries? The following appears to give the correct information, is there a different/better way? SELECT query_start, node_name, query FROM QUERY_PROFILES WHERE IS_EXECUTING and query not like '%autocommit%'; The following should work, but the cur...