neo4j - Issue combining two cypher queries with UNION -

-

When combining two cyber questions on the query I ran into the following problem: MATCH (P1: Crew) - [R_PPQ] - & gt; (FQ: Crew) WHERE fq.name IN ["NEO", "Morphius"] Returns as a separate (P1) person, count as friend (R_PPQ) friend_core, submit (fq.name) friends form In DESC LIMIT 10

by Friends_core works fine, like 

  MATCH (f: crew) and lt; Weighing weight as a separate (F), count (R_FQ) with WHERE fq.name IN ["Neo", "Morphius"] - weight by weight ORDER DESC limited 10 matches - [R_FQF] - [R_FQF] lt; - (P: Crew) Returns as a separate (P) person, as the amount (weight) Friends_core, Friend (FNN) friend as friend_score DESC LIMIT 10   
 Now when I use the  Union  command, i.e.  
  match (P1: Crew) - [R_PPQ] - & gt; (FQ: Crew) query results [Neo "," Morphius "] by using WHERE fq.name as a separate (P1) person, counting (R_PFQ) as friend_core, collected (fq.name) friend's The friend OR_SECOR E DECSC limit 10 union match (F: Crew) <- [R-FQF] - (FQ: Crew) WHERE fq.name IN ["Neo", "Morphius" Weight in the form of count (R_FKF) by ORDER Weight DESC Ltd in FIFA 10 Lights; - (P: Crew) Returns different ( P) AS person, as the MSI (Association), Amount (Weight), Collect (FNNA) as a friend by MDIScore DESC Sirius Order 10   
 I get an error  
  Error: org.neo4j.graphdb.NotFoundException: unknown identifier `weight`.   
 Can someone provide me an explanation Why these query results can not be collected and how to do this properly? Both questions run separately But why is the identifier identifiable in a unions-joint query?   
 
 
 edit  < P> The following simple query is basically equivalent, except that the second query in  UNION  is  not  ORDER BY  weight  that's because we first Since the order derived by  friend_score , it seemed redundant, as well as in order of the variables to be included in the order by clause It should be in the return clause - but the first query in the union does not contain the  weight  variable, which violates the requirements for a valid union statement.  
 In addition, the second query has a segment with each other, because you have an order by clause (like  friend_score )  before  return section!  
  match (p1: crew) - [rppqad] -> (fq: crew) WHERE fq.name IN ["node", "morphius"] return difference (p1) In the form, Friends_core as the count (R_PPQ), Submit (fq.name) Friends_Score DESC Limited 10 Union Match (P: Crew) as Friend - & gt; (F: The crew) - [RFFF] - (FQ: Crew) where the F.C.N [INN ["Neo", "Morphius"] with F, Count (R_FQ) AS Weight, F with P, Yoga (Load) In the form of Friends_core, P Return Distinct (P), the person, friend_our, collect (DISTINCT (f) .name) as Friends DESC LIMIT 10    / html>

Comments

Post a Comment

Popular posts from this blog

c# - Show a huge number of data in DevExpress GridView -

-
With 3000 lines I have a DevExpress grid view and each row has 10 as extensions (this means that when I have 30000 loads in grid load items to load) All data loads It takes a long time to do so, then there is a way to show example 100 lines, and when I use the automatic filter, do I show the lines I want? Example I tried to leave and take (using LINQ), but what I actually see for it Also want to use the automatic filter of the grid. Public Static Binding List & lt; Patient & gt; GetObjectUsingLinq (string sql = "", int skipCount = 0, int lekton = 0) {var gsData = GetDataContext (); Var query = (to choose q.nom q with GS dataApotate order); Return new compulsory list & lt; Patient & gt; (LinqHelper.DoSortPaginate (Query, "" Leave, Techcount) .Oolist ()); } and to call it on the grid listPatient = patients.getObjectUsingLinq (); myGrid.DataSource = listPatient; If you need to display large amounts of records in the grid control, ...
Read more

Pygame memory leak with transform.flip -

-
Today I came across an interesting issue which, by writing a small side scroller, instead of a sprite sheet, I was planning to use because I lacked a good "packer" for making phantom sheets (and honestly with patience and passion as it is only a test project). Anyway, I showed the animation running on the right of 8 PNG (with transparency). I considered it a good idea to prepare the flipped images to run on the left in the consultant, and the frame is not framed when the game is running (Flip actually consumes a lot of CPU like I Was measured). > To get access to the loop, I get the memory leak self.move_l = [# 8 PNG images with transparency to the right] For the self in IMG. Move_l: self.move_r.append (pygame.transform.flip (img, true, false) error traceback: traceback (most recent Call final): The file "D: \ Python 34 \ _Projects \ efg \ efg.py", in line 196, in the & lt; module & gt; main = master program ((1024, 680)) "D: \ Python ...
Read more

python - Writing Greek in matplotlib labels, titles -

-
Image
I'm trying to write some text for labels, shape titles etc. with my plots, but no benefit till now Has not happened . I do not want to print specific characters (I know how to use special characters), I want to write the entire text in Greek (maybe Unicode and text ' ?). , suggesting that I would like to mention that for some reason I can not get matplotlib to cooperate with Tex (using IPython notebook from Anaconda in Ubuntu 14.10) so that there really is an option Will not be the first. I tried loading the Arial font and it loads successfully but again I get square blocks instead of characters. I import matplotlib.font_manager FM PROP = FM Font Properties (fname = '/ usr / share / fonts / truetype / msttcorefonts / Arial.ttf') And then to display the string I u'Î? ? I ?? Î¿Ï ?? ÎμÎ »second ?? μΠ± i ?? I ± i ?? I ?? Used ο किया? ? Î¿Î¼Î¿Î¯Ï ?? I ?? I · I ?? ' . Ariel is considered to be fully presented to Greek and I have used it many times ...
Read more