Search found 22 matches

by Mrao
Wed Feb 12, 2014 9:28 pm
Forum: Vertica Data Load
Topic: why ROS_COUNT is 2
Replies: 1
Views: 1309

why ROS_COUNT is 2

Hi, I inserted data into a table from another table using the below statement. The table structure and rowcount of both the structures is the same, but ros_count on projection_storage is different. The source table ros_count is 1 and the target tbale ros_count is 2. Any idea why it is different? ins...
by Mrao
Wed Feb 12, 2014 3:28 pm
Forum: New to Vertica SQL
Topic: Pre-Join Projection with left-outer-join behaviour
Replies: 5
Views: 2875

Re: Pre-Join Projection with left-outer-join behaviour

4 hrs looks really long time to me. I will first try to fix the fact tables and then will go to the next. I will consider sKwa ideas. I may be able to suggest a solution if I have the following info. 1. Fact tables volumes 2. High level logic from source to Fact 3. Any partitions on the fact tables ...
by Mrao
Wed Feb 12, 2014 3:11 am
Forum: Vertica SQL Functions
Topic: How to pull up an object definition
Replies: 6
Views: 3431

Re: How to pull up an object definition

Thanks for the response. I read documentation before posting it. I am from Teradata background and there are some nice features and commands. I posted the questions to see if there are any simple ways of doing it. For example, in Teradata, if I want to see an objection definition, I use "SHOW TABLE ...
by Mrao
Wed Feb 12, 2014 3:05 am
Forum: New to Vertica SQL
Topic: Pre-Join Projection with left-outer-join behaviour
Replies: 5
Views: 2875

Re: Pre-Join Projection with left-outer-join behaviour

why do you want to go for a prejoin? Did you look at these options? 1. Consolidate both the facts, if you do not need to maintain them separately. 2. Create a view with left outer join. This is a dynamic approach and saves desk space. 3. Create a new table to hold left outer join output. This gives ...
by Mrao
Tue Feb 11, 2014 9:24 pm
Forum: Vertica SQL Functions
Topic: How to pull up an object definition
Replies: 6
Views: 3431

Re: How to pull up an objection definition

Thanks you.

Which system table holds the objects definitions?
by Mrao
Tue Feb 11, 2014 2:31 pm
Forum: Vertica SQL Functions
Topic: How to pull up an object definition
Replies: 6
Views: 3431

How to pull up an object definition

How can i pull up an object definition? For example, a table definition. I know export_objects can be used, but I think it exports to a file. I want to export it to my query tool/linux command prompt.
by Mrao
Sun Feb 09, 2014 9:39 pm
Forum: New to Vertica
Topic: WOS and ROS
Replies: 14
Views: 15734

Re: WOS and ROS

Good discussion.

What is the benefit of having WOS? Why do not we load it directly into ROS? I understand that WOS is for trickle feed and ROS is for bulk load. Why can not Vertica have just ROS?

Go to advanced search