Re: error while bulk loading using copy command

2015-01-29 Thread Rahul Bhardwaj
Thanks Eric.. yes 18 lacs implies 1.8 million. On Thu, Jan 29, 2015 at 9:01 PM, Eric Stevens wrote: > As the error implies, you cannot insert into counters tables, you can only > update them as increments or decrements (updating a counter that doesn't > exist will create it with the initial del

Re: error while bulk loading using copy command

2015-01-29 Thread Eric Stevens
As the error implies, you cannot insert into counters tables, you can only update them as increments or decrements (updating a counter that doesn't exist will create it with the initial delta as if it had started at zero). I would recommend this documentation which describes how to update counters

error while bulk loading using copy command

2015-01-28 Thread Rahul Bhardwaj
Hi All, We need to upload 18 lacs rows into a table which consist columns with data type "counter". on uploading using copy command , we are getting below error: *Bad Request: INSERT statement are not allowed on counter tables, use UPDATE instead* we need counter data type because after loading