Search found 87 matches

by rajasekhart
Sat Oct 18, 2014 10:20 am
Forum: New to Vertica
Topic: WOS and ROS
Replies: 14
Views: 45757

Re: WOS and ROS

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!!
by rajasekhart
Mon Oct 07, 2013 8:06 am
Forum: New to Vertica Database Development
Topic: Keep Temp Tables in New Sessions
Replies: 5
Views: 27482

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!!
by rajasekhart
Thu Oct 03, 2013 1:55 pm
Forum: Vertica Database Development
Topic: Unpivot functionality
Replies: 4
Views: 14674

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...
by rajasekhart
Mon Sep 23, 2013 8:14 am
Forum: New to Vertica
Topic: WOS and ROS
Replies: 14
Views: 45757

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...
by rajasekhart
Thu Aug 08, 2013 7:33 am
Forum: Vertica Database Administration
Topic: Is schema name compulsory to prefix the table??
Replies: 5
Views: 11914

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!!
by rajasekhart
Wed Aug 07, 2013 9:03 am
Forum: Vertica Database Administration
Topic: Is schema name compulsory to prefix the table??
Replies: 5
Views: 11914

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"!! :o

Thanks,
Raj!!
by rajasekhart
Wed Aug 07, 2013 6:22 am
Forum: Vertica Database Administration
Topic: Is schema name compulsory to prefix the table??
Replies: 5
Views: 11914

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

Go to advanced search