Search found 10 matches
- Fri Mar 10, 2017 10:48 pm
- Forum: Vertica Backup & Recovery
- Topic: Passwordless SSH from PROD to DEV Clusters
- Replies: 1
- Views: 15602
Passwordless SSH from PROD to DEV Clusters
Hi - I want to be able to use the vbr -t replicate task to be able to replicate objects from prod to a new DEV/QA cluster. Potentially - eventually - the opposite direction as well. However - I need to configure SSH from the source to the target cluster. Each cluster is already configured to passwor...
- Fri Jul 24, 2015 8:45 pm
- Forum: Vertica Performance Tuning
- Topic: Projections With Expressions
- Replies: 3
- Views: 25507
Re: Projections With Expressions
http://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/AdministratorsGuide/Projections/ProjectionsWithExpressions.htm http://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/AdministratorsGuide/Projections/RequirementsForExpressionsInProjections.htm EXPLAIN select p.*, c.CNAME from MYSCHEMA.MY...
- Fri Jul 24, 2015 4:34 pm
- Forum: Vertica Performance Tuning
- Topic: Projections With Expressions
- Replies: 3
- Views: 25507
Projections With Expressions
Is it possible to have projections with expressions and those projections have full statistics? From what I can tell these only have ROWCOUNT statistics. I have a handful of these projections where I'm converting numeric source data into DATE and TIMESTAMP data types on load. However, I'm not gettin...
- Thu Jul 24, 2014 8:19 pm
- Forum: Vertica Migration
- Topic: How to export data from SQL Server to Vertica
- Replies: 9
- Views: 36900
Re: How to export data from SQL Server to Vertica
I ended up writing a VB program to look for 'NULL|', '|NULL' or '|NULL|' and replace with | or || depending. sqlcmd -S MYSERVER -d mydb -u -s"|" -I -h-1 -k2 -W -i "C:\path\input.sql" |null-program.exe | vsql -h verticadev-d dbase-U dbadmin-w password-c "COPY DEV.myTable FROM LOCAL STDIN DELIMITER '|...
- Thu Jul 24, 2014 5:55 pm
- Forum: Vertica Migration
- Topic: How to export data from SQL Server to Vertica
- Replies: 9
- Views: 36900
Re: How to export data from SQL Server to Vertica
Thanks - solving the issue of the NULL being populated for null marks in the sqlcmd output is my problem. I confirmed that using Doug's suggestion of writing the rejected data and exceptions to a local file. I didn't realize the copy local stdin didn't automatically write those to the catalog direct...
- Thu Jul 24, 2014 3:38 pm
- Forum: Vertica Migration
- Topic: How to export data from SQL Server to Vertica
- Replies: 9
- Views: 36900
Re: How to export data from SQL Server to Vertica
I'm wondering if the results from sqlcmd actually have the string NULL when there are null marks in the table as opposed to consecutive delimiters.
That would cause some loading issues - but modifying the sqlcmd output doesn't seem straightforward.
That would cause some loading issues - but modifying the sqlcmd output doesn't seem straightforward.
- Wed Jul 23, 2014 11:29 pm
- Forum: Vertica Migration
- Topic: How to export data from SQL Server to Vertica
- Replies: 9
- Views: 36900
Re: How to export data from SQL Server to Vertica
Doug - I came across your blog solution also trying to troubleshoot SSIS data type mismatch errors that I couldn't resolve. I followed your instructions and I learned quite a bit as a newbie from your blog. However - in my case - the result from the sqlcmd/vsql procedure yielded 0 Rows being loaded....