Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-4000

Mapping between Cassandra blob (BytesType) and MySQL BLOB does not work

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 10.0.1
    • 10.0.3
    • None

    Description

      Specification in the KB says that there should be mapping between MySQL BLOB and Cassandra blob (https://kb.askmonty.org/en/cassandra-storage-engine/). It doesn't seem to work:

      cqlsh:manual_test> create columnfamily cf13 ( rowkey int primary key, b blob );

      [default@manual_test] describe cf13;  
          ColumnFamily: cf13
            Key Validation Class: org.apache.cassandra.db.marshal.Int32Type
            Default column value validator: org.apache.cassandra.db.marshal.UTF8Type
            Columns sorted by: org.apache.cassandra.db.marshal.UTF8Type
            GC grace seconds: 864000
            Compaction min/max thresholds: 4/32
            Read repair chance: 0.1
            DC Local Read repair chance: 0.0
            Replicate on write: true
            Caching: KEYS_ONLY
            Bloom Filter FP chance: default
            Built indexes: []
            Column Metadata:
              Column Name: b
                Validation Class: org.apache.cassandra.db.marshal.BytesType
            Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
            Compression Options:
              sstable_compression: org.apache.cassandra.io.compress.SnappyCompressor

      create table t13 (rowkey int primary key, b blob ) ENGINE=CASSANDRA `keyspace`='manual_test' `column_family`='cf13';
      ERROR 1928 (HY000): Internal error: 'Failed to map column b to datatype org.apache.cassandra.db.marshal.BytesType'

      VARBINARY works:

      create table t13 (rowkey int primary key, b varbinary(1024) ) ENGINE=CASSANDRA `keyspace`='manual_test' `column_family`='cf13';
      # Query OK, 0 rows affected (0.04 sec)

      revision-id: psergey@askmonty.org-20121224043622-xn8g8y3vhtu1lb3w
      revno: 3459
      branch: 10.0-base-cassandra

      Maybe it requires additional options in column family specification? In this case it would be good to document them.

      Attachments

        Issue Links

          Activity

            People

              psergei Sergei Petrunia
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.