[jira] [Commented] (CASSANDRA-10996) The system table system.schema_columnfamilies does not exist

["sangshenghong (JIRA)" <ji...@apache.org>]

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

sangshenghong commented on CASSANDRA-10996:
-------------------------------------------

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)