Hi Deepak,
I guess, the move out will happen at the given moveout interval only after the MoveOutSizePct reaches the given threshold limit.
Can you give a try after making the below setting.
SELECT SET_CONFIG_PARAMETER('MoveOutSizePct', 0);
Thank you,
Raj!!
Search found 87 matches
- Sat Oct 18, 2014 10:20 am
- Forum: New to Vertica
- Topic: WOS and ROS
- Replies: 14
- Views: 45954
- Mon Oct 07, 2013 8:06 am
- Forum: New to Vertica Database Development
- Topic: Keep Temp Tables in New Sessions
- Replies: 5
- Views: 27691
Re: Keep Temp Tables in New Sessions
Hi Janice,
How you are using Temp Tables in your Project.
In which scenario , it is useful to you??
As we dont have stored procedures, how can we use them?
PS: Are you using them with External Stored Procedures??
Regards,
Raj!!
How you are using Temp Tables in your Project.
In which scenario , it is useful to you??
As we dont have stored procedures, how can we use them?
PS: Are you using them with External Stored Procedures??
Regards,
Raj!!
- Thu Oct 03, 2013 1:55 pm
- Forum: Vertica Database Development
- Topic: Unpivot functionality
- Replies: 4
- Views: 14763
Unpivot functionality
Hi, I want to turn the columns into rows. So that i can reduce number of rows that are loaded.. (where some columns are unnecessarily redundant) Do we have that feasibility.?? Eg: I'm having the following structure . Create table Unpivot(ID, Month, Year, Count1, Count2, Count3,...........Count32); I...
- Mon Sep 23, 2013 8:14 am
- Forum: New to Vertica
- Topic: WOS and ROS
- Replies: 14
- Views: 45954
Re: WOS and ROS
hi guys, Once you made a bulk load, vertica initially stores it in WOS, where the data gets stored in unoptimised way. But after some time , it performs MOVEOUT operation automatically. And then , the data retrieval becomes faster. (Correct me if i am wrong). Now , my question is after how much time...
- Thu Aug 08, 2013 7:33 am
- Forum: Vertica Database Administration
- Topic: Is schema name compulsory to prefix the table??
- Replies: 5
- Views: 12015
Re: Is schema name compulsory to prefix the table??
Hi Jim and nani,
Yes.. im using vertica version 6.0.1.
So, it is not allowing me to do that task.
Thanks a lot ..
Regards,
Raj!!
Yes.. im using vertica version 6.0.1.
So, it is not allowing me to do that task.
Thanks a lot ..
Regards,
Raj!!
- Wed Aug 07, 2013 9:03 am
- Forum: Vertica Database Administration
- Topic: Is schema name compulsory to prefix the table??
- Replies: 5
- Views: 12015
Re: Is schema name compulsory to prefix the table??
Hi nani,
Thanks for your quick reply..
But when i was tried to fire the Alter user Command , it is throwing an error,
"Alter user command is not supported"!!
Thanks,
Raj!!
Thanks for your quick reply..
But when i was tried to fire the Alter user Command , it is throwing an error,
"Alter user command is not supported"!!
Thanks,
Raj!!
- Wed Aug 07, 2013 6:22 am
- Forum: Vertica Database Administration
- Topic: Is schema name compulsory to prefix the table??
- Replies: 5
- Views: 12015
Is schema name compulsory to prefix the table??
Connected as dbadmin While querying a table , if schema name is not prefixed the table, then by default it considers the schema as Public and retrieves the data from Public schema. Connected as a user X Lets assume User X has permission on YYYY schema and public schema too. While querying a table ,...