Search found 527 matches

by NorbertKrupa
Mon May 23, 2016 3:02 am
Forum: Vertica Data Load
Topic: Loading 7-zip compressed files
Replies: 3
Views: 17880

Re: Loading 7-zip compressed files

You can always pipe the uncompression into a COPY...FROM STDIN.
by NorbertKrupa
Fri May 13, 2016 9:55 pm
Forum: Tableau
Topic: Log analyser with Big data
Replies: 1
Views: 13479

Re: Log analyser with Big data

I don't think you're in the right place
by NorbertKrupa
Mon Apr 11, 2016 6:56 pm
Forum: New to Vertica SQL
Topic: Sample Vertica SQL with the inputs from an application
Replies: 3
Views: 17902

Re: Sample Vertica SQL with the inputs from an application

Code: Select all

INSERT INTO your.table (column1, column2) VALUES (value1, value2);
by NorbertKrupa
Wed Apr 06, 2016 10:44 pm
Forum: New to Vertica SQL
Topic: Referencing a column alias in the same select list
Replies: 3
Views: 22268

Re: Referencing a column alias in the same select list

Code: Select all

select a.x + 1 as b
from (select x from test) as a;
by NorbertKrupa
Sun Mar 20, 2016 4:41 pm
Forum: New to Vertica Database Administration
Topic: Migrate database to another cluster running different vertica version.
Replies: 1
Views: 17542

Re: Migrate database to another cluster running different vertica version.

You could if you do a manual process; meaning you export schema, users and then import the data. You could also potentially leverage EXPORT TO VERTICA or a utility such as PyVertica. However, if you're going from on-prem to Azure, it could take a while depending on your network speed. See my blog po...

Go to advanced search