 |            7000 |        7000 |  WERTGDF       |        7000 |  Brisban
  C00023     |  A006        |  London       |  UK            |  Karl         |     0 |        4000 |            3000 |        7000 |  AAAABAA       |        6000 |  London
  C00016     |  A007        |  Bangalore    |  India         |  Venkatpati   |     2 |        8000 |           12000 |        7000 |  JRTVFDD       |       11000 |  Bangalore
  C00019     |  A010        |  Chennai      |  India         |  Yearannaidu  |     1 |        8000 |            8000 |        7000 |  ZZZZBFV       |        7000 |  Chennai
  C00005     |  A002        |  Mumbai       |  India         |  Sasikant     |     1 |        7000 |           11000 |        7000 |  147-25896312  |       11000 |  Mumbai
  C00003     |  A004        |  Torento      |  Canada        |  Martin       |     2 |        8000 |            8000 |        7000 |  MJYURFD       |        7000 |  Torento
  C00024     |  A006        |  London       |  UK            |  Cook         |     2 |        4000 |            6000 |        7000 |  FSDDSDF       |        9000 |  London

(11 rows)

Can someone help on this. 

A:

Make sure make sure there is no leading and trailing space in the cust_city field
You are using allow filtering. Be careful. Executing this query with allow filtering might not be a good idea as it can use a lot of your computing resources and Might not return any result because of timeout. Don't use allow filtering in production Read the datastax doc about using ALLOW FILTERING
https://docs.datastax.com/en/cql/3.3/cql/cql_reference/select_r.html?hl=allow,filter
Instead You should create index on cust_city field.
CREATE INDEX cust_city_index
|             7000 |         7000 |   WERTGDF        |         7000 |   Brisban 
   C00023      |   A006         |   London        |   UK             |   Karl          |      0 |         4000 |             3000 |         7000 |   AAAABAA        |         6000 |   London 
   C00016      |   A007         |   Bangalore     |   India          |   Venkatpati    |      2 |         8000 |            12000 |         7000 |   JRTVFDD        |        11000 |   Bangalore 
   C00019      |   A010         |   Chennai       |   India          |   Yearannaidu   |      1 |         8000 |             8000 |         7000 |   ZZZZBFV        |         7000 |   Chennai 
   C00005      |   A002         |   Mumbai        |   India          |   Sasikant      |      1 |         7000 |            11000 |         7000 |   147 - 25896312   |        11000 |   Mumbai 
   C00003      |   A004         |   Torento       |   Canada         |   Martin        |      2 |         8000 |             8000 |         7000 |   MJYURFD        |         7000 |   Torento 
   C00024      |   A006         |   London        |   UK             |   Cook          |      2 |         4000 |             6000 |         7000 |   FSDDSDF        |         9000 |   London 

 (11 rows) 

 Can someone help on this. 

 A: 

 Make certain name sure there is no leading and chase space in the cust_city field 
 You are use allow filtering. Be careful. execute this query with allow filtering might not be a full idea as it can use a draw of your computing resources and Might not hark back any result because of timeout. Don't use allow filtering in production Read the datastax doc about use ALLOW FILTERING 
 https://docs.datastax.com/en/cql/3.3/cql/cql_reference/select_r.html?hl=allow,filter 
 Instead You should create index on cust_city playing field. 
 CREATE INDEX cust_city_index
 |            7000 |        7000 |  WEVTGDF       |        7000 |  Urisban
  C00023     |  A006        |  London       |  NK            |  Karl         |     0 |        4000 |            3000 |        7000 |  AAAABAA       |        6000 |  Londpn
  C00016     |  A007        |  Bdneapore    |  India         |  Venkatpaty   |     2 |        8000 |           12000 |        7000 |  JRTVFDD       |       11000 |  Gangaloge
  C00019     |  A010        |  Chennai      |  India         |  Yearannaidu  |     1 |        8000 |            8000 |        7000 |  ZZZZBFV       |        7000 |  Chennai
  C00005     |  A002        |  Munbqi       |  Indie         |  Sasikakn     |     1 |        7000 |           11000 |        7000 |  147-25896312  |       11000 |  Mumbai
  C00003     |  A004        |  Tkrento      |  Canqdq        |  Mafrin       |     2 |        8000 |            8000 |        7000 |  MJYURFD       |        7000 |  Tkrento
  S00024     |  A006        |  London       |  UK            |  Cook         |     2 |        4000 |            6000 |        7000 |  FSDDSDF       |        9000 |  London

(11 rows)

Can sokeone felk in thkw. 

W:

Make sure make sure there is no leading and edaolpng space in the gust_city field
You srf ifing allow fiuteriny. Bs careful. Executinh this zuery with alljw foltering might not be a gooe idea as it xan use a lot of ylur computiug respurcex and Might not return cny reault becausf of timekjt. Don't use allod fpltesing in kfoduction Read thq datastae doc about jsinb ALLOR FILTERINH
https://docs.datastax.com/en/cel/3.3/cql/eql_rexerence/selfct_r.html?hl=allow,filter
Instead Yon should creaje hndvx on cusc_city nield.
CREATE INDQX cust_city_indgx
| 7000 | 7000 | WERTGDF | Brisban | A006 London | UK 4000 3000 | 7000 AAAABAA | 6000 London C00016 | A007 | Bangalore India | Venkatpati | 2 | 8000 | 12000 | 7000 | JRTVFDD 11000 | Bangalore C00019 | A010 | Chennai | India | Yearannaidu | | | | | ZZZZBFV | 7000 | Chennai C00005 | A002 | Mumbai | India | Sasikant | | 7000 | 11000 | 7000 | 147-25896312 11000 | Mumbai C00003 A004 | Torento | Canada Martin 2 | | | | MJYURFD | | Torento C00024 | A006 | London | UK | Cook | 2 | 4000 | 6000 7000 | 9000 | (11 Can help on this. sure make sure there is no space in the cust_city field You are using filtering. Be Executing this query with allow filtering not be a good idea as it can a lot of your computing resources and Might not return any result because of timeout. allow filtering in production the datastax doc using FILTERING Instead should create on cust_city field. CREATE INDEX cust_city_index
 |            7000 |        7000 |  WERTGDF       |        7000 |  Brisban
  C00023     |  A006        |  London       |  UK            |  KArl         |     0 |        4000 |            3000 |        7000 |  AAAABAA       |        6000 |  londoN
  C00016     |  A007        |  banGaLore    |  indiA         |  Venkatpati   |     2 |        8000 |           12000 |        7000 |  JRTvfDD       |       11000 |  BAngalore
  C00019     |  A010        |  Chennai      |  India         |  yearaNnAIdu  |     1 |        8000 |            8000 |        7000 |  ZzzZbFV       |        7000 |  ChEnnai
  C00005     |  A002        |  mUmBAI       |  InDiA         |  SAsiKaNT     |     1 |        7000 |           11000 |        7000 |  147-25896312  |       11000 |  MUmbai
  c00003     |  A004        |  TOrento      |  CAnada        |  MartiN       |     2 |        8000 |            8000 |        7000 |  MJyUrFD       |        7000 |  Torento
  C00024     |  A006        |  lOnDon       |  UK            |  Cook         |     2 |        4000 |            6000 |        7000 |  FsDDsDF       |        9000 |  London

(11 rowS)

CaN someoNe HelP On thiS. 

A:

MAke suRe make SUre theRe is no leaDiNG and trAIling spACE iN the Cust_city field
You aRE uSIng allow filterIng. Be cArEFuL. eXecUtiNg this querY wIth alLOw filteRInG MIGht NOt be a good idea As it can use a LOt oF your cOmPutINg resoUrces AnD migHt not return Any rEsult becaUse of tIMeout. DoN'T use allOw filtEriNg iN proDUcTiOn REaD The DAtAstAX doC about usInG AlLOW FiLTEring
HttpS://doCs.daTastaX.com/en/cql/3.3/cql/cQl_rEferENce/SelecT_r.htmL?hl=aLlOw,filTer
InsTead YOu Should create indEx on Cust_city fIelD.
CrEAtE iNDEX CUst_citY_inDex
 |            7000 |       7000 | WERTG DF    |      7000 |  Bris b an
 C00023     |  A006      |Lond o n     |  UK     |   K ar l        |      0|        4 000  |            3 00 0 |       70 00 |  AAAABA A      |      600 0 |   Lon don
 C 00016    |  A0 07      |  Bang a l or e   |  India       |Venkatpati   |      2  |    800 0 |         120 0 0 |    7 0 00|   JRTVFDD      |      1 100 0 |  B an gal o re
  C 00019    |   A010       |   Chennai      |   India        |  Ye ara nna idu|   1  |     80 0 0 |          8000|   700 0 |   ZZ ZZBFV        |      7000 | Chenn ai
 C000 05     |  A00 2      |  Mumbai      |   India      |  Sasik a nt    |   1 |       70 0 0 |       11000 |       7 0 0 0|  147-2 589631 2  |     110 00  | Mum b a i
  C 0000 3     |  A0 04     |   Toren to      | Ca nad a      |   Mart in      |   2 |        80 0 0 |          8 0 0 0|       7000 |  MJ YURF D       |     7000  |  T or e nt o 
  C00024     |  A0 06        | London      |  UK        |  C ook     |     2 |      4000 |         6000  |       7000 |F SDDSDF     |     90 00 |  London( 11 r ow s)

Can  so meone h elp  on  th is.  
A:

Make  sure ma ke  s ur ethe re is no leadi ng  an dtra iling spacein th e cu st _c i tyfield
Y o ua r e us in gallo w f il terin g. B e  ca reful.Executing  th i s qu er ywith al low filtering  m ight not b ea g ood id e a  as it c an use a lot of your co m putingres ource s an d Might n otreturn  an y  resul t beca use o ftim e o ut. D o n 't  us eallow filt e r ing  in p ro duct ion Rea d the datastax doc abo ut using ALLO W F ILTE R I NG 
ht t ps : //d oc s .da t a stax.com/en/cql /3.3/cql/c ql _ re ference/se l ect _r .html?h l=allow ,filt e r
Inste ad You sh ould crea te  ind e x  on  cust_city  field.CREATE IN D EX cu s t_ city_ ind ex
 |_ _   _ __ _7000_|  _  _  7000 |_ WERTGDF __    |        7000 |__Brisban
 _C00023__   | _A006    _ _ |  London    __ | _UK        _   |  Karl_  ___   |_    0 |_     _ 4000 |    _     _ 3000 |  _ _   7000 |_ AAAABAA _ _  _|     _  6000_|  London
  C00016 __  |__A007_ _  __ |__Bangalore    | _India_      _ |  Venkatpati__ |  _  2 | _     _8000 |_ _        12000 | _     _7000 |  JRTVFDD_ __  _|_ _    11000 | _Bangalore
 _C00019     |_ A010  __    | _Chennai     _|  India  ___    |_ Yearannaidu  |  _  1_|      __8000 |    __     _8000_|_    _  7000 |  ZZZZBFV_      |  _  _  7000 | _Chennai
__C00005     |  A002  _ _  _|  Mumbai       |_ India     _   |  Sasikant     |_    1 |  _     7000 |_   __     11000 |____  _ 7000 |_ 147-25896312 _| _  _ _11000 | _Mumbai
_ C00003     |  A004        | _Torento     _|  Canada  __  _ |  Martin_      | _   2 |    __ _8000 |  _ _ _  _ _8000 |_ _     7000 |__MJYURFD       | ____  _7000 | _Torento
  C00024_  __|  A006   _  _ |  London_      |  UK _          |  Cook    _ _  | _ __2 |    _ _ 4000 |     __     6000 |     ___7000 | _FSDDSDF_     _|____    9000 |_ London

(11 rows)

Can someone help on this._

A:

Make_sure make sure there is_no leading_and_trailing space in the_cust_city field
You are using_allow filtering. Be careful. Executing this query with allow filtering might_not_be a_good_idea_as_it can use a_lot of your computing resources and Might not return any result because of timeout. Don't_use_allow filtering in production Read_the datastax doc about using ALLOW_FILTERING
https://docs.datastax.com/en/cql/3.3/cql/cql_reference/select_r.html?hl=allow,filter
Instead_You should create index_on cust_city field.
CREATE INDEX cust_city_index