Search found 36 matches
- Thu Oct 16, 2014 3:51 pm
- Forum: Vertica SQL
- Topic: Find out the Position of Alphabets in a string.
- Replies: 6
- Views: 12218
Re: Find out the Position of Alphabets in a string.
Check out Vertica's REGEXP functions. http://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/SQLReferenceManual/Functions/RegularExpressions/RegularExpressionFunctions.htm%3FTocPath%3DSQL%20Reference%20Manual%7CSQL%20Functions%7CRegular%20Expression%20Functions%7C_____0 REGEXP_INSTR finds the sta...
- Sun Sep 14, 2014 2:27 am
- Forum: New to Vertica Database Development
- Topic: The Lesser Known Normal Forms of Database Design
- Replies: 0
- Views: 16216
The Lesser Known Normal Forms of Database Design
Great post on other normal forms to consider when designing your database.
http://www.johnmyleswhite.com/notebook/ ... mal-forms/
*** kidding ***
http://www.johnmyleswhite.com/notebook/ ... mal-forms/
*** kidding ***
- Mon Sep 08, 2014 3:21 pm
- Forum: Vertica Backup & Recovery
- Topic: SAS with vertica
- Replies: 1
- Views: 14781
Re: SAS with vertica
Yes. I would recommend reading the SAS/Access Interface to Vertica for more information.
http://support.sas.com/documentation/cd ... 8iozn6.htm
http://support.sas.com/documentation/cd ... 8iozn6.htm
- Mon Sep 08, 2014 3:08 pm
- Forum: Microsoft SQL Server Analysis Services (SSAS)
- Topic: SSAS ROLAP cubes with Vertica
- Replies: 4
- Views: 68574
Re: SSAS ROLAP cubes with Vertica
When I looked at this a year ago I found that SSAS 2008 R2 doesn't play well with Vertica v6 in ROLAP mode. Here's the use case you will want to test, assuming you're using a more recent version of SSAS and Vertica. Create a Vertica table called CustomerTransaction with three columns (CustomerID, Tr...
- Fri Jul 25, 2014 1:33 am
- Forum: Vertica Migration
- Topic: How to export data from SQL Server to Vertica
- Replies: 9
- Views: 36693
Re: How to export data from SQL Server to Vertica
There are a number of levers you can pull to speed up the load as well. Assuming that the network is the gating factor, you could stream the data through a gzip utility to convert it to gzip. The copy statement can read gzip data as long as you change the input from STDIN to STDIN GZIP. However, tha...
- Fri Jul 25, 2014 1:24 am
- Forum: Vertica Migration
- Topic: How to export data from SQL Server to Vertica
- Replies: 9
- Views: 36693
Re: How to export data from SQL Server to Vertica
There's also the NULL as 'NULL' option for the copy command. [dbadmin@vertica tmp]$ cat test_file.txt 1|NULL|6 2|abcd|4 72|a|NULL NULL|hi|8 [dbadmin@vertica tmp]$ vsql Welcome to vsql, the Vertica Analytic Database interactive terminal. Type: \h or \? for help with vsql commands \g or terminate with...
- Thu Jul 24, 2014 2:29 pm
- Forum: Vertica Migration
- Topic: How to export data from SQL Server to Vertica
- Replies: 9
- Views: 36693
Re: How to export data from SQL Server to Vertica
As for why it didn't show up in load_streams...did it finish in < 1 second? From the Vertica Docs: "The LOAD_STREAMS system table includes stream names for every COPY statement that takes more than 1-second to run. The 1-second duration includes the time to plan and execute the statement." The next ...