cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "sangshenghong (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (CASSANDRA-10996) The system table system.schema_columnfamilies does not exist
Date Mon, 11 Jan 2016 13:28:39 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-10996?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15091885#comment-15091885
] 

sangshenghong edited comment on CASSANDRA-10996 at 1/11/16 1:27 PM:
--------------------------------------------------------------------

I am working on Hive 1.2 plus Hadoop 2.6 to support Cassandra 3.1, in previous, we want to
get the following field value with this sql statament "

   String query = "select key_aliases,"
                + "column_aliases, "
                + "key_validator, "
                + "comparator "
                + "from system.schema_columnfamilies "
                + "where keyspace_name='%s' and columnfamily_name='%s'";

So now how to get the column value like key_aliases,column_aliases,comparator? Is there any
example code ? or we can get these value from system_schema.* ?thanks for caring this issue!


was (Author: sangshenghong):
I am working on Hive 1.1plus Hadoop 2.6 to support Cassandra 3.1, in previous, we want to
get the following field value with this sql statament "

   String query = "select key_aliases,"
                + "column_aliases, "
                + "key_validator, "
                + "comparator "
                + "from system.schema_columnfamilies "
                + "where keyspace_name='%s' and columnfamily_name='%s'";

So now how to get the column value like key_aliases,column_aliases,comparator? Is there any
example code ? or we can get these value from system_schema.* ?thanks for caring this issue!

> The system table  system.schema_columnfamilies does not exist
> -------------------------------------------------------------
>
>                 Key: CASSANDRA-10996
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-10996
>             Project: Cassandra
>          Issue Type: Bug
>          Components: CQL
>            Reporter: sangshenghong
>            Priority: Critical
>             Fix For: 3.1.1
>
>         Attachments: error.png
>
>
> In the 2.1.6 version,there is one system table named "system.schema_columnfamilies",
but in the latest version 3.1.1, when I execute select * from system.schema_columnfamilies,
it throw "unconfigured table schema_columnfamilies" in cqlsh.
> But in the system.log file, it show 
> ColumnFamilyStore.java:381 - Initializing system.schema_columnfamilies
> I checked the doc and found some tables and schemas have been change, so I want to know
if there any change for this?



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message