marcothesane
Administrator
marcothesane Administrator
Reactions
-
Re: I need to update a column in a table based on value of the same column in another table.
Can you share two simplified tables with a bunch of rows each? It would make it much easier for us to show you how to do that. Also - do you need to do that once - or every time you get new data to a… (View Post)-1 -
Re: Parent child table segmentation
Do you mean this? CREATE TABLE par ( par_id INTEGER NOT NULL, par_name VARCHAR(32), CONSTRAINT pk_par PRIMARY KEY(par_id))SEGMENTED BY HASH(par_id) ALL NODES;CREATE TABLE chi ( chi_id INTEGER NOT NUL… (View Post)0 -
Re: Additional projection for primary key constraint
I suppose you created the table like I did below here, or in a similar way - that is, specifying the primary key at CREATE time: The default projection that comes out of that is sorted by and segment… (View Post)4 -
Re: Find abbreviated words / Non - English letters in text
Do you want to find: * find substrings that consist of , say, 2 to 5 capital alphabetic letters? and include accents and such, like in 'Ä' 'Ñ' ? * find these substrings, and then find out if they are… (View Post)-1 -
Re: Find abbreviated words / Non - English letters in text
They contain several consecutive uppercase alpha characters between word boundaries, @mosheg . Now, @shashank_p , if FAROUTINTHEUNCHARTEDBACKWATERSOFTHEUNFASHIONABLEENDOFTHEWESTERNSPIRALARMOFTHEGALAX… (View Post)4