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

Cassandra SE storage engine unable to map timestamp columns

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • 10.0.10
    • None
    • None
    • Centos 6.5 64bit, DataStax Enterprise v4 (Cassandra v2.0)

    Description

      I am unable to map a timestamp column to a MariaDB Cassandra SE table.

      I can get all other data types mapped except timestamp.

      This is the error message I get:

      SQL Error (1815): Internal error: Failed to map column some_datetime to datatype org.apache.cassandra.db.marshal.TimestampType

      This is create statement in Cassandra:

      create table test_key_space.test_timestamp
      (
      	id int PRIMARY KEY,
      	some_datetime timestamp	
      ) WITH COMPACT STORAGE;

      This is the create statement in MariaDB:

      create table test.test_timestamp
      (
      	id int PRIMARY KEY,
      	some_datetime timestamp
      ) engine=cassandra
        thrift_host= '10.0.95.68'
        keyspace= 'test_key_space'
        column_family='test_timestamp';

      I understand this engine is not under active development, but I would very much appreciate if you could at least let me know if this is even supposed to work as suggested in the documentation on data type mapping:
      https://mariadb.com/kb/en/cassandra-storage-engine/

      Thank you very much in advance,

      Dmytro

      Attachments

        Activity

          People

            psergei Sergei Petrunia
            Dmytro Dmytro Andriychenko
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.