Search found 11 matches

by bhupal
Sun Mar 16, 2014 4:12 am
Forum: New to Vertica
Topic: not able to copy data from file
Replies: 5
Views: 7889

Re: not able to copy data from file

Thanks Knicely. If I try by enclosed by '"' some records are inserting into table but again I got some rejected records. Saying two many column found. Data is like 1,"Adaptor, PCI-4x, LAN, 17"" 1000Base-TX",My Test So what should I do for loading this data. If u have any solution with replacing the ...
by bhupal
Sat Mar 15, 2014 7:19 am
Forum: New to Vertica
Topic: not able to copy data from file
Replies: 5
Views: 7889

Re: not able to copy data from file

see tha column 7 from last has " and ,

becuase of this i am getting exception To Many Columns Found and the record has been rejected. what i want is, i want to load the data by removing this " and , from that columns if it is not possible to load the original data.
by bhupal
Sat Mar 15, 2014 1:08 am
Forum: New to Vertica
Topic: not able to copy data from file
Replies: 5
Views: 7889

not able to copy data from file

Hi Guys, i am using .csv file to load data. it has data like 2013Q2,201306,Asia Pacific,Asia Pacific Countri,Japan,Japan,Japan,Japan Local Sales,R700,PSG Support,Ongoing Renewals,Ongoing Renewals,O,Indirect,HPS SAP PJ1 APJ,,,,N/V,N/V,N/V,5X,5X,A8685A,"Adaptor, PCI-4x, LAN, 1000Base-TX",?,N/V,N/V,JP6...
by bhupal
Wed Jun 19, 2013 3:38 am
Forum: New to Vertica
Topic: any hints for improving update query performance
Replies: 1
Views: 4302

any hints for improving update query performance

HI all i have two tables . both are having references. i need to update one table bye joining those two common columns. first table has 4crors of data and second one 1.5 crors of data i had written a query update table_name set column_name=(select column_name from table_name2 where table_name2.match...
by bhupal
Tue Jun 11, 2013 6:36 pm
Forum: New to Vertica
Topic: use utf-8 locale not roman8 locale
Replies: 1
Views: 4882

use utf-8 locale not roman8 locale

Hi all when i am executing sql query in unix with vsql command, i am getting error like error is: use utf-8 locale not roman8 locale. why i am getting this error, what would be the solution to overcome this. !# /bin/ksh exec_vsql=/app/informatica/infa_drivers/vertica/opt/vertica/bin/vsql $exec_vsql ...
by bhupal
Tue May 07, 2013 8:11 pm
Forum: New to Vertica
Topic: how to load special charecters into vertica database
Replies: 1
Views: 3943

how to load special charecters into vertica database

hi all, i have a problem in loading data into the vertica database with informatica tool. i have some special charecters in sql server in description and subject columns. data type for these columns are nvarchar. data presents in sql server is like this "Sehr geehrte Damen un Herren, hiermit bestäti...
by bhupal
Thu Apr 25, 2013 5:41 am
Forum: New to Vertica Database Development
Topic: not null in all columns
Replies: 1
Views: 7022

not null in all columns

hi all, i need to check that, not null records in all columns. for single column we can write query like select *from table_name where not is null (id); if i have 10 columns and i need to retrive records those are not having null in all columns. please give me query for this. thanks in advance.

Go to advanced search