mosheg
Administrator
mosheg Administrator
Reactions
-
Re: ranged projections aren't superprojections when adding columns?
Projections that include all columns and rows of the anchor table can be considered superprojections in Vertica. Therefore, ranged projections, even if they include all columns, would not be counted … (View Post)1 -
Re: What will be format of nested array data in csv
Here is an example of how to load a nested array in INSERT and via bulk load using a COPY statement. CREATE TABLE array_test( f1 int, f2 ARRAY[VARCHAR(80)], f3 ARRAY[ARRAY[INT]]);INSERT INTO array_te… (View Post)2 -
Re: Is there an option to add a column alias to the table definition
Additionally, you can execute: ALTER USER YourConsumingApplicationUserName SEARCH_PATH YourViewSchemaName, public; This ensures that the user will use the same table name but refer to a view because … (View Post)1 -
Re: Pivot from columns to rows?
Hi Yarden, Please try this: create table MyTable(id varchar, step1 varchar, step2 varchar, step3 varchar);COPY MyTable FROM STDIN DELIMITER ',' ABORT ON ERROR;id1,0,29,54,id2,0,22,76,\.SELECT * FROM … (View Post)3 -
Re: How to treat text with \n and new line as same in vertica
In addition, consider the following example to reduce the count distinct elapsed time. CREATE TABLE public.my_generated_data( row_id int, f1 varchar(100), f2 varchar(100) default REGEXP_REPLACE(f1,'\… (View Post)1