and clause in cql cassandra -

-

i have created table schema

create table iplocation (     "idiplocation" uuid,     "fromip" bigint,     "toip" bigint,     "idcity" uuid,     "idcountry" uuid,     "idprovince" uuid,     "isactive" boolean,     primary key ("idiplocation", "fromip", "toip") )

and inserted records in it! want fetch record this

select * iplocation "toip" <= 3065377522 , "fromip" >= 3065377522 allow filtering;

but giving me error of

a column of clustering key can restricted if preceding 1 restricted equal relation. need restrict fromip before restrict toip.

but if want just

select * iplocation "toip" <= 3065377522 allow filtering;

it still says

 column of clustering key can restricted if preceding    1 restricted equal relation. need restrict    fromip before restrict toip.

i cant figureout whats problem?

your misusing partition key concept. in case partition key idiplocation cassandra use key know in partition data write or read. in select statement have provide partition key. can filter data within specified partition provide fromip, toip.

you have 4 solutions : 1) chose better partition key : can example use followinf partition key clause : primary key ("toip"). in case guess solution won't work because want query data idiplocation too.

2) denormalize : add new table same data structure différent partition key : create table backup_advertyze.iplocation ( "idiplocation" uuid, "fromip" bigint, "toip" bigint, "idcity" uuid, "idcountry" uuid, "idprovince" uuid, "isactive" boolean, primary key ("idiplocation", "fromip", "toip") ); create table backup_advertyze.iplocationbytoip ( "idiplocation" uuid, "fromip" bigint, "toip" bigint, "idcity" uuid, "idcountry" uuid, "idprovince" uuid, "isactive" boolean, primary key ("toip", "fromip") );

with structure can run query select * iplocationbytoip "toip" <= 3065377522 , "fromip" >= 3065377522. solution have maintain doubles in 2 tables

3) use materialized view : same concept 2) have maintain data in 1 table instead of 2 : `create table backup_advertyze.iplocation ( "idiplocation" uuid, "fromip" bigint, "toip" bigint, "idcity" uuid, "idcountry" uuid, "idprovince" uuid, "isactive" boolean, primary key ("idiplocation", "fromip", "toip") );

create materialized view backup_advertyze.iplocationbytoip select * backup_advertyze.iplocation idiplocation not null , fromip not null , toip not null primary key (toip, fromip, idiplocation);`

4) simple solution don't recommend due query performences issues use secondary indexes :

create index iplocationfromindex on backup_advertyze.iplocation(fromip);

you can run query select * iplocation "toip" <= 3065377522 , "fromip" >= 3065377522 allow filtering;.

hope can you.


Comments

Post a Comment

Popular posts from this blog

Spring Boot + JPA + Hibernate: Unable to locate persister -

-
i trying work entity inside request method of spring boot application. entity in project , pom.xml has dependencies it. why error message?: org.hibernate.unknownentitytypeexception: unable locate persister: com.ric.bill.model.bs.par package com.ric.web; import java.util.concurrent.atomic.atomiclong; import javax.persistence.entitymanager; import javax.persistence.persistencecontext; import net.sf.ehcache.cachemanager; import net.sf.ehcache.management.cache; import net.sf.ehcache.management.cachestatistics; import org.hibernate.stat.statistics; import org.springframework.beans.factory.annotation.autowired; import org.springframework.boot.autoconfigure.domain.entityscan; import org.springframework.cache.annotation.enablecaching; import org.springframework.transaction.annotation.enabletransactionmanagement; import org.springframework.transaction.annotation.propagation; import org.springframework.transaction.annotation.transactional; import org.springframework.web.bind.annotati
Read more

go - Golang: panic: runtime error: invalid memory address or nil pointer dereference using bufio.Scanner -

-
i implementing go program uses bufio.scanner , bufio.writer have packaged code follows package main import ( "fmt" "player/command" "strings" ) func main() { //enter code here. read input stdin. print output stdout commands.scanner.scan() { //scan new line , send comand variable check command exist or not input := strings.split(strings.trim(commands.scanner.text(), " "), " ") command := input[0] if command == "" { fmt.printf("$ %s:", commands.pwd) continue } if !commands.commands[command] { commands.throwerror("cannot recognize input.") } else { commands.execute(command, input[1:], nil) } fmt.printf("$ %s:", commands.pwd) } } i using init.go file in main package follows package main import ( "flag" "player/sourc
Read more

c - double free or corruption (fasttop) -

-
this code reads null terminated string file (file containing null terminated strings & should provide index wanted string). error: *** error in `./main': double free or corruption (fasttop): 0x090a4a80 *** aborted code: char *tmp_realloc=null; char *sstring=null; int i=1; /*set file pointer point string*/ fseek(fh,index,seek_set); sstring=(char*)malloc(sizeof(char)); if(sstring == null) return null; tmp_realloc=sstring; while( (*(sstring+i-1)=(char)fgetc((file*)fh)) != 0x0 ) { /*reallocate more memory*/ tmp_realloc=(char*)realloc((char*)sstring,++i); /*if not same address copy old new & set old point new*/ if(tmp_realloc != sstring){ strcpy((char*)tmp_realloc,(char*)sstring); free(sstring); sstring=tmp_realloc; } } could tell me pointer causing issue (& reason) ? remove part /*if not same address copy old new & set old point new*/ if(tmp_realloc != sstring){ strc
Read more