Search found 21 matches
- Fri Mar 28, 2014 5:59 am
- Forum: New to Vertica Database Development
- Topic: Data Modeling for Vertica
- Replies: 1
- Views: 19158
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 ...
- Fri Sep 13, 2013 10:26 am
- Forum: New to Vertica Database Development
- Topic: Bad Row due to Special / Foreign Characters
- Replies: 3
- Views: 21274
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.
I have my relational connection(ODBC) for source and Target(vertica) code page as UTF-8.
- Thu Sep 12, 2013 11:36 am
- Forum: New to Vertica Database Development
- Topic: Bad Row due to Special / Foreign Characters
- Replies: 3
- Views: 21274
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...
- Thu Jul 18, 2013 1:32 pm
- Forum: Vertica Database Development
- Topic: Can we use 2 delimiters in COPY command?
- Replies: 4
- Views: 12277
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?
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?
- Thu Jul 18, 2013 10:23 am
- Forum: Vertica Database Development
- Topic: Can we use 2 delimiters in COPY command?
- Replies: 4
- Views: 12277
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.
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.
- Fri Jun 28, 2013 6:50 pm
- Forum: New to Vertica Database Development
- Topic: How to insert Chinese characters in Vertica
- Replies: 8
- Views: 44896
Re: How to insert Chinese characters in Vertica
is there any special datatype for non-ASCII data?
- Fri Jun 28, 2013 4:04 pm
- Forum: New to Vertica Database Development
- Topic: How to insert Chinese characters in Vertica
- Replies: 8
- Views: 44896
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