Linux x64, Apache Cassandra 1.2.4

Please provide both Cassandra column family structure and MariaDB CREATE TABLE.
Thanks.

Cassandra-CLI
CREATE COLUMN FAMILY te_ACLEntry WITH comparator=UTF8Type AND column_metadata = [

];

MariaDB:
CREATE TABLE te_ACLEntry (te_ACLEntryId bigint primary key, te_ACLID bigint, te_ACLRight bigint, te_CreationTime bigint, te_EndTime bigint, te_MaxUsage bigint, te_PrincipalID bigint, te_StartTime bigint, te_SystemID bigint, te_UserRight bigint, te_signature varchar(100) ) engine=cassandra keyspace='eruces_keys' column_family='te_ACLEntry';

Note - tried several different ways to create a link.

[default@eruces_keys] show schema;

WARNING: CQL3 tables are intentionally omitted from 'show schema' output.
See https://issues.apache.org/jira/browse/CASSANDRA-4377 for details.

create keyspace eruces_keys
with placement_strategy = 'SimpleStrategy'
and strategy_options =

and durable_writes = true;

use eruces_keys;

create column family te_ACLEntry
with column_type = 'Standard'
and comparator = 'UTF8Type'
and default_validation_class = 'BytesType'
and key_validation_class = 'BytesType'
and read_repair_chance = 0.1
and dclocal_read_repair_chance = 0.0
and populate_io_cache_on_flush = false
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 = [

,

,

,

,

,

,

,

,

,

,

]
and compression_options =

;

I think I zapped part of the structure when I tried to solve this error. by running this command:
update column family te_ACLEntry with column_metadata = [

];

If I recreate the column family, with multiple KEYS, I get an error about Primary Key must be neame rowkey. I cannot find information on creating an Alias for a column_name.

CREATE TABLE te_ACLEntry (te_ACLEntryId bigint primary key, te_ACLID bigint, te_ACLRight bigint, te_CreationTime bigint, te_EndTime bigint, te_MaxUsage bigint, te_PrincipalID bigint, te_StartTime bigint, te_SystemID bigint, te_UserRight bigint, te_signature varchar(100) ) engine=cassandra keyspace='eruces_keys' column_family='te_ACLEntry';
ERROR 1928 (HY000): Internal error: 'target column family has no key_alias defined, PRIMARY KEY column must be named 'rowkey''

Figured out the problem.... Must create tables with CQL instead of cassandra-CLI

cqlsh:eruces_keys> create columnfamily te_ACLEntry (te_ACLEntryId bigint primary key, te_ACLID bigint, te_ACLRight bigint, te_CreationTime bigint, te_EndTime bigint, te_MaxUsage bigint, te_PrincipalID bigint, te_StartTime bigint, te_SystemID bigint, te_UserRight bigint, te_signature varchar);

MariaDB [cass_keys]> CREATE TABLE te_ACLEntry (te_ACLEntryId bigint primary key, te_ACLID bigint, te_ACLRight bigint, te_CreationTime bigint, te_EndTime bigint, te_MaxUsage bigint, te_PrincipalID bigint, te_StartTime bigint, te_SystemID bigint, te_UserRight bigint, te_signature varchar(100) ) engine=cassandra keyspace='eruces_keys' column_family='te_ACLEntry';
Query OK, 0 rows affected (0.02 sec)

Works fine now...will move onto Primary Key + Secondary Keys and test...

Multiple_keys has a problem....See https://mariadb.atlassian.net/browse/MDEV-4543
This one can be closed.

I have tried with Cassandra 1.1.4:

1. 1. 1. Create column family exactly as was specified:

CREATE COLUMN FAMILY te_ACLEntry WITH comparator=UTF8Type AND column_metadata = [

];
d8ae07a4-2d6a-30ea-992e-dda0389a9669
Waiting for schema agreement...
... schemas agree across the cluster

1. 1. 1. Try the original CREATE TABLE :
         MariaDB [test]> CREATE TABLE te_ACLEntry (te_ACLEntryId bigint primary key, te_ACLID bigint, te_ACLRight bigint, te_CreationTime bigint, te_EndTime bigint, te_MaxUsage bigint, te_PrincipalID bigint, te_StartTime bigint, te_SystemID bigint, te_UserRight bigint, te_signature varchar(100) ) engine=cassandra keyspace='mariadbtest2' column_family='te_ACLEntry';
         ERROR 1928 (HY000): Internal error: 'target column family has no key_alias defined, PRIMARY KEY column must be named 'rowkey''

1. 1. Change the primary key column to be named 'rowkey':
      MariaDB [test]> CREATE TABLE te_ACLEntry (rowkey bigint primary key, te_ACLID bigint, te_ACLRight bigint, te_CreationTime bigint, te_EndTime bigint, te_MaxUsage bigint, te_PrincipalID bigint, te_StartTime bigint, te_SystemID bigint, te_UserRight bigint, te_signature varchar(100) ) engine=cassandra keyspace='mariadbtest2' column_family='te_ACLEntry';
      ERROR 1928 (HY000): Internal error: 'Failed to map PRIMARY KEY to datatype org.apache.cassandra.db.marshal.BytesType'

1. 1. 1. Change the datatype of rowkey to match Cassandra's "BytesType":
         MariaDB [test]> CREATE TABLE te_ACLEntry (rowkey binary(32) primary key, te_ACLID bigint, te_ACLRight bigint, te_CreationTime bigint, te_EndTime bigint, te_MaxUsage bigint, te_PrincipalID bigint, te_StartTime bigint, te_SystemID bigint, te_UserRight bigint, te_signature varchar(100) ) engine=cassandra keyspace='mariadbtest2' column_family='te_ACLEntry';
         Query OK, 0 rows affected (0.04 sec)

It worked.

The commands posted in the previous work with Cassandra 1.2.4, too.

Closing this issue, as requested. MDEV-4543 will be processed separately.