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

Sylvain Lebresne commented on CASSANDRA-10996:
----------------------------------------------

bq. you suggest I should use system_schema instead of system,but I tried to use 
system_schema, just get the same exception

To clarify, it's not enough to change {{system}} to {{system_schema}}. The name 
of the tables and their content has changed to present schema that is more 
natural to how it looked on the CQL side.

bq. So now how to get the column value like 
key_aliases,column_aliases,comparator? Is there any example code ?

It's not trivial. You'll have to understand how a thrift schema translate to 
CQL and vice versa. You can start by understanding the translation between the 
2 paradigm in general reading for instance 
[this|http://www.datastax.com/dev/blog/thrift-to-cql3] and 
[that|http://www.datastax.com/dev/blog/does-cql-support-dynamic-columns-wide-rows],
 but after that I'm afraid you'll have to dig into the code. 

But really, you may not have to do that. It's probably a better idea to adapt 
hive to be more CQL aware instead of dealing with raw comparators and column 
aliases. But I can't really help you a lot more on that as I know next to 
nothing to Hive.

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

Reply via email to