Search found 21 matches

by jagadeesh
Fri Mar 28, 2014 5:59 am
Forum: New to Vertica Database Development
Topic: Data Modeling for Vertica
Replies: 1
Views: 18938

Data Modeling for Vertica

Hi, I am new to Data modeling side and i am trained on modeling techniques. Are these techniques are specific to a traditional RDBMS? I have some knowledge on Vertica on how the data is stored... the projections, compressing and encoding techniques. is there anything that i may have to consider for ...
by jagadeesh
Fri Sep 13, 2013 10:26 am
Forum: New to Vertica Database Development
Topic: Bad Row due to Special / Foreign Characters
Replies: 3
Views: 21014

Re: Bad Row due to Special / Foreign Characters

Thanks Knicely, but i am extracting data directly from a Database.

I have my relational connection(ODBC) for source and Target(vertica) code page as UTF-8.
by jagadeesh
Thu Sep 12, 2013 11:36 am
Forum: New to Vertica Database Development
Topic: Bad Row due to Special / Foreign Characters
Replies: 3
Views: 21014

Bad Row due to Special / Foreign Characters

Hi, I am trying to load tables in Vertica through Informatica. Some of my records are rejected due to special/foreign language character data. I am using UTF-8 code page for source/target relational connection. session failed as the row rejected due to bad data. sample reject data "CONGȂEC CAPITAL L...
by jagadeesh
Thu Jul 18, 2013 1:32 pm
Forum: Vertica Database Development
Topic: Can we use 2 delimiters in COPY command?
Replies: 4
Views: 12199

Re: Can we use 2 delimiters in COPY command?

ok, but whats my scenario is

I have file with '|' as delimiter and i also have data like this

col1|col2
1|App,le
2|Oran~ge
3|What the|hell is this

3rd row 2nd column value has '|'
how to solve this?
by jagadeesh
Thu Jul 18, 2013 10:23 am
Forum: Vertica Database Development
Topic: Can we use 2 delimiters in COPY command?
Replies: 4
Views: 12199

Can we use 2 delimiters in COPY command?

Hi,

Is it possible to use 2 delimiters in COPY command?

when i use GZIP DELIMITER '~|' its throwing error "ERROR 2730: COPY delimiter must be a single character"

i have PIPELINE, COMMA, '~','^' coming from my source data so i am planning to use combination.
by jagadeesh
Fri Jun 28, 2013 6:50 pm
Forum: New to Vertica Database Development
Topic: How to insert Chinese characters in Vertica
Replies: 8
Views: 44461

Re: How to insert Chinese characters in Vertica

is there any special datatype for non-ASCII data?
by jagadeesh
Fri Jun 28, 2013 4:04 pm
Forum: New to Vertica Database Development
Topic: How to insert Chinese characters in Vertica
Replies: 8
Views: 44461

Re: How to insert Chinese characters in Vertica

I am using Informatica to load and in the session log i could see some chineese characters and i see a message bad record so i guess it should be because of these special characters

Go to advanced search