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

      Attachments

        Activity

          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.

          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.

          Please comment to re-open if you have new information on the issue.

          elenst Elena Stepanova added a comment - Please comment to re-open if you have new information on the issue.

          People

            Unassigned Unassigned
            delu2000 Del
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.