Unable to query cfs inode column family

(5 posts) (4 voices)

• Started 7 months ago by tambalavanar
• Latest reply from sam
• This topic is not a support question

Tags:

No tags yet.

1. 

   tambalavanar
   Member

   I tried the cql query to get filename from cfs inode as shown in the link : http://www.datastax.com/dev/blog/cassandra-file-system-design

   When I run the query, i get the following error.
   
cqlsh:cfs> select filename from inode where parent_path='/AMBAL';
Internal application error


   Also, in the OpsCenter, I see the content of inode row in a different format. The keys and values are not in character format.
   
\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


   What could be the problem?
   Thanks.

   Posted 7 months ago #
2. 

   nickmbailey
   Key Master

   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

   Posted 7 months ago #
3. 

   tambalavanar
   Member

   Hi Nick,

   I'm using DSE v2.1.1. OpsCenter, the one that comes with DSE v2.1.1.

   
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)


   When I do describe on the inode columnfamily, i get the following.
   
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');


   Thanks.

   Posted 7 months ago #
4. 

   Sven
   Administrator

   Thank you very much for the information. We are looking into it, and should have more information tomorrow.

   Posted 7 months ago #
5. 

   sam
   Member

   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

   Posted 7 months ago #

RSS feed for this topic

Reply

You must log in to post.