Re: 1) select collection_type whith keywork 'in' . 2)how to using UDFin update?

[lowping]

HI, Brooke Jensen,Thanks for reply.


sorry about the terrible description for error last time. 




this is my table schema
create table test(
  id text,
  scope text,
  name text,
  value SETtext,
  PRIMARY KEY (id,scope)
)WITH CLUSTERING ORDER BY (scope ASC);


I execute this cql and get a error
cqlsh:realtime select value from test where id='abc' and scope in 
('china','USA’);


InvalidRequest: code=2200 [Invalid query] message="Cannot restrict clustering 
columns by IN relations when a collection is selected by the query"


and I also want use UDF in update cql, and get a error again
UDF definition
CREATE OR REPLACE FUNCTION my_fun(status text)
CALLED ON NULL INPUT
RETURNS text
LANGUAGE java AS 'return status+" hello world";’;




cqlsh:realtimeupdate test set name=my_fun(name) where id='abc' and scope in 
('china','USA’);


SyntaxException: ErrorMessage code=2000 [Syntax error in CQL query] 
message="line 1:32 no viable alternative at input ')' (update test set 
name=my_fun([name])...)”


原始邮件
发件人:Brooke jensenbro...@instaclustr.com
收件人:useru...@cassandra.apache.org
发送时间:2016年6月27日(周一) 11:36
主题:Re: 1) select collection_type whith keywork 'in' . 2)how to using UDFin 
update?


Hi.


Can you please show me the specific error message you are receiving, as well as 
the schema for this table (you can use the cql command "describe table").






Brooke Jensen
VP Technical Operations  Customer Services
www.instaclustr.com|support.instaclustr.com


This email has been sent on behalf of Instaclustr Limited (Australia) and 
Instaclustr Inc (USA).This email and any attachments may contain confidential 
and legally privileged information. If you are not the intended recipient, do 
not copy or disclose its content, but please reply to this email immediately 
and highlight the error to the sender and then immediately delete the message.


On 26 June 2016 at 17:25, lowping lowp...@163.com wrote:

Hi All:


question 1:
I got a error about this cql， does it fixed already ？？？
select collection_type where id in (‘a’,’b’)


question 2:


I want use UDF in update, but this cql can’t execute. have some advise？？？


update table_name set field=my_function(field) where…




tnk u so much