[jira] [Commented] (CASSANDRA-2477) CQL support for describing keyspaces / column familes
[ https://issues.apache.org/jira/browse/CASSANDRA-2477?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13489522#comment-13489522 ] Matthew Higgins commented on CASSANDRA-2477: How would I get all tables for a keyspace using CQL? cqlsh implements this with thrift api calls, so I have no examples. Selecting from schema_columnfamilies only returns a list of keyspaces. I am working on a Ruby gem that is 100% CQL except for a few calls (ie. https://github.com/data-axle/cassandra_object/blob/master/lib/cassandra_object/schema/tasks.rb). I would like to remove the cqlsh dependency. CQL support for describing keyspaces / column familes - Key: CASSANDRA-2477 URL: https://issues.apache.org/jira/browse/CASSANDRA-2477 Project: Cassandra Issue Type: New Feature Components: API, Core Reporter: Eric Evans Priority: Minor Labels: cql Fix For: 1.1.0 Attachments: 2477-virtual-cfs-false-start.txt -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-2477) CQL support for describing keyspaces / column familes
[ https://issues.apache.org/jira/browse/CASSANDRA-2477?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13489530#comment-13489530 ] Jonathan Ellis commented on CASSANDRA-2477: --- {{SELECT columnfamily_name FROM schema_columnfamilies WHERE keyspace_name='?'}} Suggest looking at definitions in CFMetaData.java. CQL support for describing keyspaces / column familes - Key: CASSANDRA-2477 URL: https://issues.apache.org/jira/browse/CASSANDRA-2477 Project: Cassandra Issue Type: New Feature Components: API, Core Reporter: Eric Evans Priority: Minor Labels: cql Fix For: 1.1.0 Attachments: 2477-virtual-cfs-false-start.txt -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-2477) CQL support for describing keyspaces / column familes
[ https://issues.apache.org/jira/browse/CASSANDRA-2477?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13489531#comment-13489531 ] Jonathan Ellis commented on CASSANDRA-2477: --- Also note that some column names changed from 1.1 - 1.2. CQL support for describing keyspaces / column familes - Key: CASSANDRA-2477 URL: https://issues.apache.org/jira/browse/CASSANDRA-2477 Project: Cassandra Issue Type: New Feature Components: API, Core Reporter: Eric Evans Priority: Minor Labels: cql Fix For: 1.1.0 Attachments: 2477-virtual-cfs-false-start.txt -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-2477) CQL support for describing keyspaces / column familes
[ https://issues.apache.org/jira/browse/CASSANDRA-2477?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13489538#comment-13489538 ] Matthew Higgins commented on CASSANDRA-2477: Is columnfamily_name new in 1.2? For v1.1.5, the only column with values in the schema_columnfamilies table is keyspace. CQL support for describing keyspaces / column familes - Key: CASSANDRA-2477 URL: https://issues.apache.org/jira/browse/CASSANDRA-2477 Project: Cassandra Issue Type: New Feature Components: API, Core Reporter: Eric Evans Priority: Minor Labels: cql Fix For: 1.1.0 Attachments: 2477-virtual-cfs-false-start.txt -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-2477) CQL support for describing keyspaces / column familes
[ https://issues.apache.org/jira/browse/CASSANDRA-2477?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13489186#comment-13489186 ] Matthew Higgins commented on CASSANDRA-2477: I still don't understand how to get the column families from the system tables. In other words, I need to use cqlsh and DESCRIBE COLUMNFAMILIES to list an array of strings containing each column family for a keyspace. CQL support for describing keyspaces / column familes - Key: CASSANDRA-2477 URL: https://issues.apache.org/jira/browse/CASSANDRA-2477 Project: Cassandra Issue Type: New Feature Components: API, Core Reporter: Eric Evans Priority: Minor Labels: cql Fix For: 1.1.0 Attachments: 2477-virtual-cfs-false-start.txt -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-2477) CQL support for describing keyspaces / column familes
[ https://issues.apache.org/jira/browse/CASSANDRA-2477?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13489209#comment-13489209 ] Jonathan Ellis commented on CASSANDRA-2477: --- cqlsh does the work for you. but if you wanted to do it programatically then you would need to piece the data together via SELECT. CQL support for describing keyspaces / column familes - Key: CASSANDRA-2477 URL: https://issues.apache.org/jira/browse/CASSANDRA-2477 Project: Cassandra Issue Type: New Feature Components: API, Core Reporter: Eric Evans Priority: Minor Labels: cql Fix For: 1.1.0 Attachments: 2477-virtual-cfs-false-start.txt -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-2477) CQL support for describing keyspaces / column familes
[ https://issues.apache.org/jira/browse/CASSANDRA-2477?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13183561#comment-13183561 ] Jonathan Ellis commented on CASSANDRA-2477: --- CASSANDRA-1391 *should* give us this for free. Leaving this open while we see if that works as planned. CQL support for describing keyspaces / column familes - Key: CASSANDRA-2477 URL: https://issues.apache.org/jira/browse/CASSANDRA-2477 Project: Cassandra Issue Type: New Feature Components: API, Core Reporter: Eric Evans Priority: Minor Labels: cql Fix For: 1.2 Attachments: 2477-virtual-cfs-false-start.txt -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-2477) CQL support for describing keyspaces / column familes
[ https://issues.apache.org/jira/browse/CASSANDRA-2477?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13160384#comment-13160384 ] Paul Querna commented on CASSANDRA-2477: +1, Would be very helpful to expose describe_{ring,partitioner,snitch,keyspace,version,cluster_name,schema_versions} to CQL. CQL support for describing keyspaces / column familes - Key: CASSANDRA-2477 URL: https://issues.apache.org/jira/browse/CASSANDRA-2477 Project: Cassandra Issue Type: New Feature Components: API, Core Reporter: Eric Evans Priority: Minor Labels: cql Attachments: 2477-virtual-cfs-false-start.txt -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-2477) CQL support for describing keyspaces / column familes
[ https://issues.apache.org/jira/browse/CASSANDRA-2477?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13127098#comment-13127098 ] Patricio Echague commented on CASSANDRA-2477: - would describe_ring call fall into this ticket too ? CQL support for describing keyspaces / column familes - Key: CASSANDRA-2477 URL: https://issues.apache.org/jira/browse/CASSANDRA-2477 Project: Cassandra Issue Type: New Feature Components: API, Core Reporter: Eric Evans Priority: Minor Labels: cql Attachments: 2477-virtual-cfs-false-start.txt -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-2477) CQL support for describing keyspaces / column familes
[ https://issues.apache.org/jira/browse/CASSANDRA-2477?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13127240#comment-13127240 ] Jonathan Ellis commented on CASSANDRA-2477: --- I suppose. CQL support for describing keyspaces / column familes - Key: CASSANDRA-2477 URL: https://issues.apache.org/jira/browse/CASSANDRA-2477 Project: Cassandra Issue Type: New Feature Components: API, Core Reporter: Eric Evans Priority: Minor Labels: cql Attachments: 2477-virtual-cfs-false-start.txt -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-2477) CQL support for describing keyspaces / column familes
[ https://issues.apache.org/jira/browse/CASSANDRA-2477?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13051209#comment-13051209 ] Rick Shaw commented on CASSANDRA-2477: -- So from the client side you will need to know the name of the Keyspace and the names of the CFs where this data will be stored and updated by the server. And the server side will need to fully document the current schema description of the CF(s) to do the SELECT on. And keep the CFs updated with any additions and updates to the internal KS and CF metadata. But with that info in hand the client could just issue a SELECT of the involved CF to get the metadata that is currently held in the internal server metadata structures represented by the associated KS/CFs. Is that the plan? CQL support for describing keyspaces / column familes - Key: CASSANDRA-2477 URL: https://issues.apache.org/jira/browse/CASSANDRA-2477 Project: Cassandra Issue Type: Sub-task Components: API, Core Reporter: Eric Evans Labels: cql Fix For: 0.8.2 Attachments: 2477-virtual-cfs-false-start.txt -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-2477) CQL support for describing keyspaces / column familes
[ https://issues.apache.org/jira/browse/CASSANDRA-2477?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13050567#comment-13050567 ] Jonathan Ellis commented on CASSANDRA-2477: --- {quote} What I want to avoid is a special query type (i.e. anything not SELECT) because it makes the language less orthogonal because of implementation details that are subject to change (in an ideal world, we'd move away from avro and store schema information in real columns, with indexes so you could easily say give me all the columns for CF X at schema version Y.) You'd also be limited to basically an RPC style call – no specifying which columns to select, or which rows you're interested in. Not without reinventing that wheel on a LOT of code (because SELECT right now relies on CFS to perform the actual queries). {quote} CQL support for describing keyspaces / column familes - Key: CASSANDRA-2477 URL: https://issues.apache.org/jira/browse/CASSANDRA-2477 Project: Cassandra Issue Type: Sub-task Components: API, Core Reporter: Eric Evans Labels: cql Fix For: 0.8.2 Attachments: 2477-virtual-cfs-false-start.txt -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-2477) CQL support for describing keyspaces / column familes
[ https://issues.apache.org/jira/browse/CASSANDRA-2477?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13049945#comment-13049945 ] Vivek Mishra commented on CASSANDRA-2477: - Absolutly.. make more sense. CQL support for describing keyspaces / column familes - Key: CASSANDRA-2477 URL: https://issues.apache.org/jira/browse/CASSANDRA-2477 Project: Cassandra Issue Type: Sub-task Components: API, Core Reporter: Eric Evans Labels: cql Fix For: 0.8.1 Attachments: 2477-virtual-cfs-false-start.txt -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-2477) CQL support for describing keyspaces / column familes
[ https://issues.apache.org/jira/browse/CASSANDRA-2477?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13049961#comment-13049961 ] Vivek Mishra commented on CASSANDRA-2477: - From KsMetadata, something which i can see to get CFMetadata, strategy_class and strategy options... Count on number of ColumnFamilies, fetch specific CfMetadata(via cfName) Similarly from CFMetadata, we could fetch CfName, Default validator, compare type, subcolumn comparator, Keyspace name and many more.. Is this what we are planning for Describe Ks or Describe cf? CQL support for describing keyspaces / column familes - Key: CASSANDRA-2477 URL: https://issues.apache.org/jira/browse/CASSANDRA-2477 Project: Cassandra Issue Type: Sub-task Components: API, Core Reporter: Eric Evans Labels: cql Fix For: 0.8.1 Attachments: 2477-virtual-cfs-false-start.txt -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-2477) CQL support for describing keyspaces / column familes
[ https://issues.apache.org/jira/browse/CASSANDRA-2477?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=1304#comment-1304 ] Rick Shaw commented on CASSANDRA-2477: -- How about a custom CF for each (KS/CF); that fully defines the schema entries for each piece of information to be returned about each KS and each CF. Then DESCRIBE returns a CQLResult containing normal row content. The syntax of the DESCRIBE drives a flat set of rows returned to the caller. The CQL QueryProcessor returns the contents of the CQLRow items for information it already has access to in the internal metadata tables. CQL support for describing keyspaces / column familes - Key: CASSANDRA-2477 URL: https://issues.apache.org/jira/browse/CASSANDRA-2477 Project: Cassandra Issue Type: Sub-task Components: API, Core Reporter: Eric Evans Labels: cql Fix For: 0.8.1 Attachments: 2477-virtual-cfs-false-start.txt -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-2477) CQL support for describing keyspaces / column familes
[ https://issues.apache.org/jira/browse/CASSANDRA-2477?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13038043#comment-13038043 ] Vivek Mishra commented on CASSANDRA-2477: - Hi, Just took a reference from oracle data dictionary: dba_all_tables * dba_indexes * dba_ind_partitions * dba_ind_subpartitions * dba_object_tables * dba_part_col_statistics * dba_subpart_col_statistics * dba_tables * dba_tab_cols * dba_tab_columns * dba_tab_col_statistics * dba_tab_partitions * dba_tab_subpartitions out of these, which looks to be required for Cassandra? dba_all_tables, dba_object_tables, dba_tab_columns ? CQL support for describing keyspaces / column familes - Key: CASSANDRA-2477 URL: https://issues.apache.org/jira/browse/CASSANDRA-2477 Project: Cassandra Issue Type: Sub-task Components: API, Core Reporter: Eric Evans Labels: cql Fix For: 0.8.1 Attachments: 2477-virtual-cfs-false-start.txt -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-2477) CQL support for describing keyspaces / column familes
[ https://issues.apache.org/jira/browse/CASSANDRA-2477?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13038155#comment-13038155 ] Jonathan Ellis commented on CASSANDRA-2477: --- Probably. IMO the right way to think about this is how can we expose the data we have in KSMetaData and CFMetaData not how can we make this look like Oracle. CQL support for describing keyspaces / column familes - Key: CASSANDRA-2477 URL: https://issues.apache.org/jira/browse/CASSANDRA-2477 Project: Cassandra Issue Type: Sub-task Components: API, Core Reporter: Eric Evans Labels: cql Fix For: 0.8.1 Attachments: 2477-virtual-cfs-false-start.txt -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-2477) CQL support for describing keyspaces / column familes
[ https://issues.apache.org/jira/browse/CASSANDRA-2477?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13036935#comment-13036935 ] Vivek Mishra commented on CASSANDRA-2477: - Hi, Rather than introducing a list of new commands. Will it be a good option to introduce something similar sysobjects in Oracle and information_schema in mysql. Referring RDBMS only for such concepts! CQL support for describing keyspaces / column familes - Key: CASSANDRA-2477 URL: https://issues.apache.org/jira/browse/CASSANDRA-2477 Project: Cassandra Issue Type: Sub-task Components: API, Core Reporter: Eric Evans Labels: cql Fix For: 0.8.1 Attachments: 2477-virtual-cfs-false-start.txt -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-2477) CQL support for describing keyspaces / column familes
[ https://issues.apache.org/jira/browse/CASSANDRA-2477?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13037024#comment-13037024 ] Jonathan Ellis commented on CASSANDRA-2477: --- I addressed exactly this in the comment immediately before yours. CQL support for describing keyspaces / column familes - Key: CASSANDRA-2477 URL: https://issues.apache.org/jira/browse/CASSANDRA-2477 Project: Cassandra Issue Type: Sub-task Components: API, Core Reporter: Eric Evans Labels: cql Fix For: 0.8.1 Attachments: 2477-virtual-cfs-false-start.txt -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-2477) CQL support for describing keyspaces / column familes
[ https://issues.apache.org/jira/browse/CASSANDRA-2477?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13034348#comment-13034348 ] Rick Shaw commented on CASSANDRA-2477: -- Tooling will want to be able to ask the API to describe: - List all the Keyspace names. - List all the attributes of the Keyspace - List all the column families within a Keyspace - List all of the column names and types of those columns that have been declared - list all of the indexed names and alias names I think this will need to be returned by the API at the code level not a shell. How about just a special set of CFs in the System Keyspace that can be treated as RO data that describes Keyspaces and CFs? CQL support for describing keyspaces / column familes - Key: CASSANDRA-2477 URL: https://issues.apache.org/jira/browse/CASSANDRA-2477 Project: Cassandra Issue Type: Sub-task Components: API, Core Reporter: Eric Evans Assignee: Jonathan Ellis Labels: cql Fix For: 0.8.1 -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-2477) CQL support for describing keyspaces / column familes
[ https://issues.apache.org/jira/browse/CASSANDRA-2477?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13034356#comment-13034356 ] Jonathan Ellis commented on CASSANDRA-2477: --- bq. I think this will need to be returned by the API at the code level not a shell. You misunderstood; I'm not saying that the shell will be the only client able to access that, but that the shell can have shortcuts (\d users vs select * from pg_class where relname = 'users'). CQL support for describing keyspaces / column familes - Key: CASSANDRA-2477 URL: https://issues.apache.org/jira/browse/CASSANDRA-2477 Project: Cassandra Issue Type: Sub-task Components: API, Core Reporter: Eric Evans Assignee: Jonathan Ellis Labels: cql Fix For: 0.8.1 -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-2477) CQL support for describing keyspaces / column familes
[ https://issues.apache.org/jira/browse/CASSANDRA-2477?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13034366#comment-13034366 ] Jonathan Ellis commented on CASSANDRA-2477: --- Yes, we want cqlsh or a similar tool to be a full replacement for the existing cli. CQL support for describing keyspaces / column familes - Key: CASSANDRA-2477 URL: https://issues.apache.org/jira/browse/CASSANDRA-2477 Project: Cassandra Issue Type: Sub-task Components: API, Core Reporter: Eric Evans Assignee: Jonathan Ellis Labels: cql Fix For: 0.8.1 -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-2477) CQL support for describing keyspaces / column familes
[ https://issues.apache.org/jira/browse/CASSANDRA-2477?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13034374#comment-13034374 ] Eric Evans commented on CASSANDRA-2477: --- bq. Rather than adding new CQL keywords, one alternative would be to take the pgsql approach of building this logic into the shell, by querying system CFs. How will you actually grok the schema without Avro? CQL support for describing keyspaces / column familes - Key: CASSANDRA-2477 URL: https://issues.apache.org/jira/browse/CASSANDRA-2477 Project: Cassandra Issue Type: Sub-task Components: API, Core Reporter: Eric Evans Assignee: Jonathan Ellis Labels: cql Fix For: 0.8.1 -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-2477) CQL support for describing keyspaces / column familes
[ https://issues.apache.org/jira/browse/CASSANDRA-2477?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13026889#comment-13026889 ] Vivek Mishra commented on CASSANDRA-2477: - This is to do with CQL jdbc support? CQL support for describing keyspaces / column familes - Key: CASSANDRA-2477 URL: https://issues.apache.org/jira/browse/CASSANDRA-2477 Project: Cassandra Issue Type: Sub-task Components: API, Core Reporter: Eric Evans Fix For: 1.0 -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira