Long data type is not supported

[swatidhoke]

Hi Micheal ,

I am trying to use Perl module -Perlcassa

My Use Case is :
Fetch a query from Cassandra using perl through get and get_slice where rowkey is defined as longtype.

Issue :
Row_key value described in table is long type whereas cassandra.pm module is sending it as a string.

Error on running script:
$VAR1 = bless( {
'why' => 'Expected 8 or 0 byte long (11)'
}, 'Cassandra::InvalidRequestException' );

Column family description of Cassandra:

create column family Users
with column_type = 'Standard'
and comparator = 'UTF8Type'
and default_validation_class = 'BytesType'
and key_validation_class = 'LongType'
and read_repair_chance = 0.1
and dclocal_read_repair_chance = 0.0
and gc_grace = 864000
and min_compaction_threshold = 4
and max_compaction_threshold = 32
and replicate_on_write = true
and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
and caching = 'KEYS_ONLY'
and column_metadata = [
{column_name : 'st',
validation_class : BytesType},
{column_name : 'pwrCalUsr',
validation_class : BooleanType},
{column_name : 'photoURL',
validation_class : UTF8Type},
{column_name : 'uNm',
validation_class : UTF8Type},
{column_name : 'netIDs',
validation_class : UTF8Type},
{column_name : 'pronoun',
validation_class : UTF8Type},
{column_name : 'wrkRmNo',
validation_class : UTF8Type},
{column_name : 'handle',
validation_class : UTF8Type},
{column_name : 'mNm',
validation_class : UTF8Type},
{column_name : 'clntPw',
validation_class : UTF8Type},
{column_name : 'lNm',
validation_class : UTF8Type},
{column_name : 'availId',
validation_class : IntegerType},
{column_name : 'atMobile',
validation_class : BooleanType},
{column_name : 'tmZn',
validation_class : UTF8Type},
{column_name : 'hmAddr',
validation_class : UTF8Type},
{column_name : 'inMeeting',
validation_class : BooleanType},
{column_name : 'wrkAddr',
validation_class : UTF8Type},
{column_name : 'fNm',
validation_class : UTF8Type},
{column_name : 'onThePhone',
validation_class : BooleanType},
{column_name : 'dept',
validation_class : UTF8Type},
{column_name : 'lstModTm',
validation_class : DateType},
{column_name : 'presence',
validation_class : UTF8Type},
{column_name : 'uId',
validation_class : LongType},
{column_name : 'title',
validation_class : UTF8Type},
{column_name : 'supervisorPersonID',
validation_class : IntegerType},
{column_name : 'co',
validation_class : UTF8Type},
{column_name : 'available',
validation_class : BooleanType},
{column_name : 'offline',
validation_class : BooleanType},
{column_name : 'crTm',
validation_class : DateType},
{column_name : 'availty',
validation_class : IntegerType},
{column_name : 'presenceId',
validation_class : IntegerType},
{column_name : 'winTmZn',
validation_class : UTF8Type},
{column_name : 'empId',
validation_class : UTF8Type},
{column_name : 'photoID',
validation_class : IntegerType}]
and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

Thanks,
Swati

[dmcnelis]

As a short term fix, if you can use CQL for your inserts, it bypasses the problem.

[swatidhoke]

but i m trying to get data where row key is defined as long type ..will this still be useful

[dmcnelis]

I have the same thing going on. Can't use $obj->insert at the moment with the key as a LongType, but it works just fine through CQL.

Though I am inserting, not trying to pull with perlcassa...I'd not read your use case carefully enough.

[mkjellman]

LongType works for us, could you post a sample schema for a CF to test against?

[swatidhoke]

I have posted the column family used in the issue ..i m just trying to use get and get_slice to fetch data , which gives me below error:
Error on running script:
$VAR1 = bless( {
'why' => 'Expected 8 or 0 byte long (11)'
}, 'Cassandra::InvalidRequestException' );