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

Creating Table in mariaDB - ERROR 1429 (HY000):

    Details

      Description

      Hi All,

      I successfully integrated mariaDB-10.0.13 with Cassandra-2.0.8 and 2.0.9

      I was able to created a table present in cassandra on mariaDB and was able to query successfully.

      But my problem is that other larger tables in cassandra gives error:

      ERROR 1429 (HY000): Unable to connect to foreign data source: Column family tablename not found in keyspace dbname
      

      My create statement is

      CREATE TABLE tablename (ccid int PRIMARY KEY, cid int, agentid int, type text, datetime double, logoffreason text) engine=cassandra keyspace='dbname' thrift_host='10.1.30.xxx' column_family='tablename';
      

      Verified table description and all have same compact storage defined

      compaction={'class': 'SizeTieredCompactionStrategy'}
      

      Any help will be appreciated.

      Thanks

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            elenst Elena Stepanova added a comment -

            Not sure it's still relevant, but if it is, the only thing that comes to mind right away that the keyspace on this thrift host really doesn't have the column_family. It would be nice to see it's not so before digging.

            Show
            elenst Elena Stepanova added a comment - Not sure it's still relevant, but if it is, the only thing that comes to mind right away that the keyspace on this thrift host really doesn't have the column_family. It would be nice to see it's not so before digging.

              People

              • Assignee:
                Unassigned
                Reporter:
                delu2000 Del
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated: