Search found 527 matches
- 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.
- 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
- Fri Apr 15, 2016 1:56 am
- Forum: General
- Topic: query request queue limit = 50
- Replies: 1
- Views: 5664
- 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);
- 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;
- 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...
- Thu Mar 10, 2016 8:53 pm
- Forum: General
- Topic: Vertica joins on Integer or VARCHAR fields , which one is good for performance ?
- Replies: 4
- Views: 10249
Re: Vertica joins on Integer or VARCHAR fields , which one is good for performance ?
Please read my post on the difference between merge and hash joins.