cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Eric Stevens <migh...@gmail.com>
Subject Re: error while bulk loading using copy command
Date Thu, 29 Jan 2015 15:31:39 GMT
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:
http://www.datastax.com/documentation/cql/3.0/cql/cql_using/use_counter_t.html

Also, just for clarification (because I had to Google it), lac
<http://en.wikipedia.org/wiki/Lakh> isn't a common unit where I'm from, by
18 lacs I assume you mean 1.8 million (1,800,000)?

On Wed, Jan 28, 2015 at 10:28 PM, Rahul Bhardwaj <
rahul.bhardwaj@indiamart.com> wrote:

> 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 this data we want to use
> functionality of counter data type.
>
> Kindly help is there any way to do this.
>
>
> Regards:
> Rahul Bhardwaj
>
>
> Follow IndiaMART.com <http://www.indiamart.com> for latest updates on
> this and more: <https://plus.google.com/+indiamart>
> <https://www.facebook.com/IndiaMART> <https://twitter.com/IndiaMART>
> Mobile Channel:
> <https://itunes.apple.com/WebObjects/MZStore.woa/wa/viewSoftware?id=668561641&mt=8>
> <https://play.google.com/store/apps/details?id=com.indiamart.m>
> <http://m.indiamart.com/>
>
> <https://www.youtube.com/watch?v=DzORNbeSXN8&list=PL2o4J51MqpL0mbue6kzDa6eymLVUXtlR1&index=2>
> Watch how Irrfan Khan gets his work done in no time on IndiaMART, kyunki Kaam
> Yahin Banta Hai <https://www.youtube.com/watch?v=hmS4Afl2bNU>!!!

Mime
View raw message