incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "PARASHAR, BHASKARJYA JAY" <bp1...@att.com>
Subject Failed to decode value
Date Mon, 17 Feb 2014 16:45:15 GMT





Hi

When I do a CQL3 select * on TABLE1 (describe below), I see rows displayed but get this error
at the end

"Failed to decode value '9131146' (for column 'accountId') as bigint: unpack requires a string
argument of length 8"

Cassandra version 1.2.5.  accountId is of type "text". Why would it be looking for a bigint?

Thanks
Jay

CREATE TABLE "TABLE1" (
  key text PRIMARY KEY,
  "accountId" text,
  "balanceImpactCode" text,
  "billSequenceNumber" text,
  "creditCreationDate" text,
  "creditLevelCode" text,
  "creditNetAmount" double,
  "creditReason" text,
  "eventId" text,
  "productId" text,
  "productType" text,
  "reversalReason" text,
  "reversalTransId" text,
  "totalTaxAmount" double,
  "transactionId" text,
  "updateDate" text
) WITH COMPACT STORAGE AND
  bloom_filter_fp_chance=0.010000 AND
  caching='KEYS_ONLY' AND
  comment='' AND
  dclocal_read_repair_chance=0.000000 AND
  gc_grace_seconds=864000 AND
  read_repair_chance=0.100000 AND
  replicate_on_write='true' AND
  populate_io_cache_on_flush='false' AND
  compaction={'class': 'SizeTieredCompactionStrategy'} AND
  compression={'sstable_compression': 'SnappyCompressor'};

CREATE INDEX indx_accountId ON "EnablerAccountCreditChargeInfo" ("accountId");


Mime
View raw message