Search found 302 matches

by scutter
Fri Aug 17, 2012 3:27 pm
Forum: New to Vertica
Topic: The show_current_vertica_options function
Replies: 6
Views: 10640

Re: The show_current_vertica_options function

My point was more along the lines of not poking around in the other options that are listed by the show_all function. The options themselves are not documented - the only options that you should turn on or off are the ones mentioned in the docs (in this case one) or if Support suggests that you turn...
by scutter
Fri Aug 17, 2012 4:31 am
Forum: New to Vertica
Topic: vertica for non-analytics
Replies: 4
Views: 7912

Re: vertica for non-analytics

Can you use COPY instead of 1000 individual INSERT statements? COPY is fast.
by scutter
Fri Aug 17, 2012 4:30 am
Forum: Vertica SQL
Topic: Monitoring the inserts and updates
Replies: 6
Views: 15833

Re: Monitoring the inserts and updates

If you are feeling adventurous you can look in the execution_engine_profiles table using the INSERT transaction's transaction id, where counter_name='rows produced'. It will give you a general idea of how many rows have been processed, though once the the data is being sorted by the DataTarget opera...
by scutter
Fri Aug 17, 2012 1:49 am
Forum: New to Vertica
Topic: Issue with altering a column data type
Replies: 3
Views: 11602

Re: Issue with altering a column data type

The error you got is: Cannot alter type of column "col1" since it is referenced in the segmentation expression of projection "temp_b1" You can change the data type if it's not in the segmentation expression (SEGMENTED BY HASH(col1)…). In your simple test case, the default projection created is segme...
by scutter
Fri Aug 17, 2012 1:42 am
Forum: New to Vertica
Topic: The show_current_vertica_options function
Replies: 6
Views: 10640

Re: The show_current_vertica_options function

You're poking around in undocumented territory. The show_current_vertica_options() shows the currently set options, so you don't have any set. The function show_all_vertica_options() shows the complete list of options. But don't go playing around in there unless instructed by Support.

--Sharon
by scutter
Fri Aug 17, 2012 1:38 am
Forum: Vertica SQL
Topic: Loading delimted file to Vertica table
Replies: 1
Views: 4398

Re: Loading delimted file to Vertica table

The doc says:

You can use any ASCII value in the range E'\001' to E'\177'

Can you use E'\001' instead? It's not on the keyboard.
by scutter
Thu Aug 16, 2012 9:50 pm
Forum: Vertica SQL
Topic: De-Duplication in Vertica
Replies: 16
Views: 35122

Re: De-Duplication in Vertica

The epoch column is the epoch when the data was committed. It will be null for uncommitted data. scutter=> create table scutter.t1(c integer); CREATE TABLE scutter=> insert into scutter.t1 values(1); OUTPUT -------- 1 (1 row) scutter=> select c,epoch from scutter.t1; c | epoch ---+------- 1 | (1 row...

Go to advanced search