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");

Reply via email to