Jim_Knicely
Administrator
-
Re: Query to select first row based on column with duplicates
Put the LIMIT after the WHERE Something like: select "ebin added by" || "Intake ID" || Source as PK ,cast("intake id" as varchar) as IntakeID ,p.* from ABC_PRD.abc_porta… (View Post)1 -
Re: How to specify reject rows/exception rows table while saving the dataframe to vertica.
It's the NO COMMIT on the COPY commnad that is causing Vertica to create a local external temp table vs a permanent external table. Example: With the NO COMMIT, the local external temp table doe… (View Post)1 -
Re: Updated Views
Can't you do a CREATE OR REPLACE VIEW? (View Post)1 -
Re: Where Like any combination of 4 values
There are a million ways to do this ... Here is one example: verticademos=> SELECT "service category", CASE WHEN "service category" = '' THEN 'N' ELSE DECOD… (View Post)1 -
Re: Slow inserts with indentity column
Hi, The problem isn't the IDENTITY per se, it's that you disabled the cache! When you create an IDENTITY column Vertica creates a sequence to back it. You've disabled the cache on the … (View Post)1
