[ 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)