DataStax Support Forums » Topic: Unable to query cfs inode column family

DataStax Support Forums » Topic: Unable to query cfs inode column family http://www.datastax.com/support-forums/topic/unable-to-query-cfs-inode-column-family Software, Support, and Training for Apache Cassandra en-US Tue, 18 Jun 2013 23:44:55 +0000 http://bbpress.org/?v=1.0.3 <![CDATA[Search]]> q http://www.datastax.com/support-forums/search.php sam on "Unable to query cfs inode column family" http://www.datastax.com/support-forums/topic/unable-to-query-cfs-inode-column-family#post-6912 Fri, 12 Oct 2012 19:03:29 +0000 sam 6912@http://www.datastax.com/support-forums/ CFS isn't really designed to be queried on the command line. One thing is that it uses DynamicCompositeType which isn't natively supported by cqlsh, and which causes the unusual rendering in OpsCenter. The examples in the blog post on CFS design really more pseudo-code to give an illustration than anything else. - Sam Sven on "Unable to query cfs inode column family" http://www.datastax.com/support-forums/topic/unable-to-query-cfs-inode-column-family#post-6877 Thu, 11 Oct 2012 18:37:16 +0000 Sven 6877@http://www.datastax.com/support-forums/ Thank you very much for the information. We are looking into it, and should have more information tomorrow. tambalavanar on "Unable to query cfs inode column family" http://www.datastax.com/support-forums/topic/unable-to-query-cfs-inode-column-family#post-6850 Wed, 10 Oct 2012 18:37:58 +0000 tambalavanar 6850@http://www.datastax.com/support-forums/ Hi Nick, I'm using DSE v2.1.1. OpsCenter, the one that comes with DSE v2.1.1. <code> ERROR [Thrift:16496] 2012-10-10 14:33:54,717 Cassandra.java (line 4082) Internal error processing execute_cql_query java.lang.IllegalArgumentException: Invalid component representation: parent_path at org.apache.cassandra.db.marshal.DynamicCompositeType$DynamicParsedComparator.<init>(DynamicCompositeType.java:218) at org.apache.cassandra.db.marshal.DynamicCompositeType.parseNextComparator(DynamicCompositeType.java:172) at org.apache.cassandra.db.marshal.AbstractCompositeType.fromString(AbstractCompositeType.java:198) at org.apache.cassandra.cql.Term.getByteBuffer(Term.java:91) at org.apache.cassandra.cql.QueryProcessor.validateSelect(QueryProcessor.java:353) at org.apache.cassandra.cql.QueryProcessor.process(QueryProcessor.java:549) at com.datastax.bdp.server.DseServer.execute_cql_query(DseServer.java:884) at org.apache.cassandra.thrift.Cassandra$Processor$execute_cql_query.process(Cassandra.java:4072) at org.apache.cassandra.thrift.Dse$Processor.process(Dse.java:1188) at com.datastax.bdp.cassandra.thrift.CustomTThreadPoolServer$WorkerProcess.run(CustomTThreadPoolServer.java:250) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) at java.lang.Thread.run(Thread.java:722) </code> When I do describe on the inode columnfamily, i get the following. <code> cqlsh> use cfs; cqlsh:cfs> describe columnfamily inode; CREATE COLUMNFAMILY inode ( KEY blob PRIMARY KEY, 'bpath' blob, 'sentinel' blob, 'b parent_path' blob ) WITH comment='Stores file meta data' AND comparator='DynamicCompositeType(t=>org.apache.cassandra.db.marshal.TimeUUIDType,b=>org.apache.cassandra.db.marshal.BytesType,s=>org.apache.cassandra.db.marshal.UTF8Type)' AND read_repair_chance=1.000000 AND gc_grace_seconds=60 AND default_validation=blob AND min_compaction_threshold=4 AND max_compaction_threshold=32 AND replicate_on_write=True; CREATE INDEX cfs_path ON inode ('bpath'); CREATE INDEX cfs_sentinel ON inode ('sentinel'); CREATE INDEX cfs_parent_path ON inode ('b parent_path'); </code> Thanks. nickmbailey on "Unable to query cfs inode column family" http://www.datastax.com/support-forums/topic/unable-to-query-cfs-inode-column-family#post-6815 Mon, 08 Oct 2012 17:26:52 +0000 nickmbailey 6815@http://www.datastax.com/support-forums/ A couple of questions: What version of DSE are you using? What version of OpsCenter are you using? The error 'Internal application error' indicates a problem in the cassandra server. When you get this error can you check the cassandra log for errors? -Nick tambalavanar on "Unable to query cfs inode column family" http://www.datastax.com/support-forums/topic/unable-to-query-cfs-inode-column-family#post-6720 Fri, 28 Sep 2012 14:44:37 +0000 tambalavanar 6720@http://www.datastax.com/support-forums/ I tried the cql query to get filename from cfs inode as shown in the link : <a href="http://www.datastax.com/dev/blog/cassandra-file-system-design" rel="nofollow">http://www.datastax.com/dev/blog/cassandra-file-system-design</a> When I run the query, i get the following error. <code> cqlsh:cfs> select filename from inode where parent_path='/AMBAL'; Internal application error </code> Also, in the OpsCenter, I see the content of inode row in a different format. The keys and values are not in character format. <code> \x80b\x00\x04data\x00 \x00\x00\x00\x04root\x00\x00\x00\x04root\x01\xff\x00\x00\x00\x00\x00\x04\x00\x00\x00 \x80b\x00\x0bparent_path\x00 /tmp/hive-root \x80b\x00\x04path\x00 /tmp/hive-root/hive_2012-09-20_18-00-29_118_7986403660953791635 \x80b\x00\x08sentinel\x00 x </code> What could be the problem? Thanks.