Re: Collections, query for contains?

2012-11-19 Thread Edward Capriolo
This was my first question after I git the inserts working. Hive has udfs
like array contains. It also has lateral view syntax that is similar to
transposed.

On Monday, November 19, 2012, Timmy Turner timm.t...@gmail.com wrote:
 Is there no option to query for the contents of a collection?
 Something like
   select * from cf where c_list contains('some_value')
 or
   select * from cf where c_map contains('some_key')
 or
   select * from cf where c_map['some_key'] contains('some_value')


Re: Collections, query for contains?

2012-11-19 Thread Sylvain Lebresne
It's not supported yet, no, but we have a ticket for it:
https://issues.apache.org/jira/browse/CASSANDRA-4511


On Mon, Nov 19, 2012 at 3:56 PM, Edward Capriolo edlinuxg...@gmail.comwrote:

 This was my first question after I git the inserts working. Hive has udfs
 like array contains. It also has lateral view syntax that is similar to
 transposed.


 On Monday, November 19, 2012, Timmy Turner timm.t...@gmail.com wrote:
  Is there no option to query for the contents of a collection?
  Something like
select * from cf where c_list contains('some_value')
  or
select * from cf where c_map contains('some_key')
  or
select * from cf where c_map['some_key'] contains('some_value')