Search found 10 matches

by darinbob
Fri Mar 10, 2017 10:48 pm
Forum: Vertica Backup & Recovery
Topic: Passwordless SSH from PROD to DEV Clusters
Replies: 1
Views: 428

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...
by darinbob
Fri Jul 24, 2015 8:45 pm
Forum: Vertica Performance Tuning
Topic: Projections With Expressions
Replies: 3
Views: 1310

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...
by darinbob
Fri Jul 24, 2015 4:34 pm
Forum: Vertica Performance Tuning
Topic: Projections With Expressions
Replies: 3
Views: 1310

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...
by darinbob
Thu Jul 24, 2014 8:19 pm
Forum: Vertica Migration
Topic: How to export data from SQL Server to Vertica
Replies: 9
Views: 4011

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 '|...
by darinbob
Thu Jul 24, 2014 5:55 pm
Forum: Vertica Migration
Topic: How to export data from SQL Server to Vertica
Replies: 9
Views: 4011

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...
by darinbob
Thu Jul 24, 2014 3:38 pm
Forum: Vertica Migration
Topic: How to export data from SQL Server to Vertica
Replies: 9
Views: 4011

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.
by darinbob
Wed Jul 23, 2014 11:29 pm
Forum: Vertica Migration
Topic: How to export data from SQL Server to Vertica
Replies: 9
Views: 4011

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....

Go to advanced search