Search found 302 matches
- 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...
- 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.
- 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...
- 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...
- 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
--Sharon
- 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.
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.
- 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...