Search found 22 matches
- Wed Feb 12, 2014 9:28 pm
- Forum: Vertica Data Load
- Topic: why ROS_COUNT is 2
- Replies: 1
- Views: 6917
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...
- Wed Feb 12, 2014 3:28 pm
- Forum: New to Vertica SQL
- Topic: Pre-Join Projection with left-outer-join behaviour
- Replies: 5
- Views: 11441
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 ...
- Wed Feb 12, 2014 3:11 am
- Forum: Vertica SQL Functions
- Topic: How to pull up an object definition
- Replies: 6
- Views: 26108
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 ...
- Wed Feb 12, 2014 3:05 am
- Forum: New to Vertica SQL
- Topic: Pre-Join Projection with left-outer-join behaviour
- Replies: 5
- Views: 11441
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 ...
- Tue Feb 11, 2014 9:24 pm
- Forum: Vertica SQL Functions
- Topic: How to pull up an object definition
- Replies: 6
- Views: 26108
Re: How to pull up an objection definition
Thanks you.
Which system table holds the objects definitions?
Which system table holds the objects definitions?
- Tue Feb 11, 2014 2:31 pm
- Forum: Vertica SQL Functions
- Topic: How to pull up an object definition
- Replies: 6
- Views: 26108
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.
- Sun Feb 09, 2014 9:39 pm
- Forum: New to Vertica
- Topic: WOS and ROS
- Replies: 14
- Views: 46637
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?
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?