API tools faq
paste
Advertisement
hguerrero

Untitled

hguerrero
Aug 5th, 2014
249
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 67.24 KB | None | 0 0
raw download clone embed print report
  1. 10:41:37,672 INFO [org.teiid.PLANNER] (Worker45_QueryProcessorQueue2498)
  2. ============================================================================
  3. USER COMMAND:
  4. SELECT p.id, p.nombre, p.apellido1, p.apellido2, p.direccion, p.sexo, p.correo, f.id, f.nombre, f.movil, f.telefono, f.id_ref FROM SolrView.poblacion AS p, Postgresql1View.telefonos AS f WHERE p.nombre = f.nombre LIMIT 1000
  5.  
  6. ----------------------------------------------------------------------------
  7. OPTIMIZE:
  8. SELECT p.id, p.nombre, p.apellido1, p.apellido2, p.direccion, p.sexo, p.correo, f.id, f.nombre, f.movil, f.telefono, f.id_ref FROM SolrView.poblacion AS p, Postgresql1View.telefonos AS f WHERE p.nombre = f.nombre LIMIT 1000
  9.  
  10. ----------------------------------------------------------------------------
  11. GENERATE CANONICAL:
  12. SELECT p.id, p.nombre, p.apellido1, p.apellido2, p.direccion, p.sexo, p.correo, f.id, f.nombre, f.movil, f.telefono, f.id_ref FROM SolrView.poblacion AS p, Postgresql1View.telefonos AS f WHERE p.nombre = f.nombre LIMIT 1000
  13.  
  14. CANONICAL PLAN:
  15. TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1000})
  16. Project(groups=[Postgresql1View.telefonos AS f, SolrView.poblacion AS p], props={PROJECT_COLS=[p.id, p.nombre, p.apellido1, p.apellido2, p.direccion, p.sexo, p.correo, f.id, f.nombre, f.movil, f.telefono, f.id_ref]})
  17. Select(groups=[Postgresql1View.telefonos AS f, SolrView.poblacion AS p], props={SELECT_CRITERIA=p.nombre = f.nombre})
  18. Join(groups=[SolrView.poblacion AS p, Postgresql1View.telefonos AS f], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[]})
  19. Source(groups=[SolrView.poblacion AS p], props={NESTED_COMMAND=SELECT SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo FROM SolrSourceModel.poblacion, SYMBOL_MAP={p.id=SolrSourceModel.poblacion.id, p.nombre=SolrSourceModel.poblacion.nombre, p.apellido1=SolrSourceModel.poblacion.apellido1, p.apellido2=SolrSourceModel.poblacion.apellido2, p.direccion=SolrSourceModel.poblacion.direccion, p.sexo=SolrSourceModel.poblacion.sexo, p.correo=SolrSourceModel.poblacion.correo}})
  20. Project(groups=[SolrSourceModel.poblacion], props={PROJECT_COLS=[SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo]})
  21. Source(groups=[SolrSourceModel.poblacion])
  22. Source(groups=[Postgresql1View.telefonos AS f], props={NESTED_COMMAND=SELECT Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref FROM Postgresql1SourceModel.hadoop_telefonos, SYMBOL_MAP={f.id=Postgresql1SourceModel.hadoop_telefonos.id, f.nombre=Postgresql1SourceModel.hadoop_telefonos.nombre, f.movil=Postgresql1SourceModel.hadoop_telefonos.movil, f.telefono=Postgresql1SourceModel.hadoop_telefonos.telefono, f.id_ref=Postgresql1SourceModel.hadoop_telefonos.id_ref}})
  23. Project(groups=[Postgresql1SourceModel.hadoop_telefonos], props={PROJECT_COLS=[Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref]})
  24. Source(groups=[Postgresql1SourceModel.hadoop_telefonos])
  25.  
  26.  
  27. ============================================================================
  28. EXECUTING PlaceAccess
  29.  
  30. AFTER:
  31. TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1000})
  32. Project(groups=[Postgresql1View.telefonos AS f, SolrView.poblacion AS p], props={PROJECT_COLS=[p.id, p.nombre, p.apellido1, p.apellido2, p.direccion, p.sexo, p.correo, f.id, f.nombre, f.movil, f.telefono, f.id_ref]})
  33. Select(groups=[Postgresql1View.telefonos AS f, SolrView.poblacion AS p], props={SELECT_CRITERIA=p.nombre = f.nombre})
  34. Join(groups=[SolrView.poblacion AS p, Postgresql1View.telefonos AS f], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[]})
  35. Source(groups=[SolrView.poblacion AS p], props={NESTED_COMMAND=SELECT SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo FROM SolrSourceModel.poblacion, SYMBOL_MAP={p.id=SolrSourceModel.poblacion.id, p.nombre=SolrSourceModel.poblacion.nombre, p.apellido1=SolrSourceModel.poblacion.apellido1, p.apellido2=SolrSourceModel.poblacion.apellido2, p.direccion=SolrSourceModel.poblacion.direccion, p.sexo=SolrSourceModel.poblacion.sexo, p.correo=SolrSourceModel.poblacion.correo}})
  36. Project(groups=[SolrSourceModel.poblacion], props={PROJECT_COLS=[SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo]})
  37. Access(groups=[SolrSourceModel.poblacion], props={SOURCE_HINT=null, MODEL_ID=Schema name=SolrSourceModel, nameInSource=null, uuid=mmuuid:d7971658-a7a9-4e17-824f-ce1424921c5b})
  38. Source(groups=[SolrSourceModel.poblacion])
  39. Source(groups=[Postgresql1View.telefonos AS f], props={NESTED_COMMAND=SELECT Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref FROM Postgresql1SourceModel.hadoop_telefonos, SYMBOL_MAP={f.id=Postgresql1SourceModel.hadoop_telefonos.id, f.nombre=Postgresql1SourceModel.hadoop_telefonos.nombre, f.movil=Postgresql1SourceModel.hadoop_telefonos.movil, f.telefono=Postgresql1SourceModel.hadoop_telefonos.telefono, f.id_ref=Postgresql1SourceModel.hadoop_telefonos.id_ref}})
  40. Project(groups=[Postgresql1SourceModel.hadoop_telefonos], props={PROJECT_COLS=[Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref]})
  41. Access(groups=[Postgresql1SourceModel.hadoop_telefonos], props={SOURCE_HINT=null, MODEL_ID=Schema name=Postgresql1SourceModel, nameInSource=null, uuid=mmuuid:97bc9352-c469-4e16-bd9c-636493334081})
  42. Source(groups=[Postgresql1SourceModel.hadoop_telefonos])
  43.  
  44.  
  45. ============================================================================
  46. EXECUTING AssignOutputElements
  47.  
  48. AFTER:
  49. TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1000, OUTPUT_COLS=[p.id, p.nombre, p.apellido1, p.apellido2, p.direccion, p.sexo, p.correo, f.id, f.nombre, f.movil, f.telefono, f.id_ref]})
  50. Project(groups=[Postgresql1View.telefonos AS f, SolrView.poblacion AS p], props={PROJECT_COLS=[p.id, p.nombre, p.apellido1, p.apellido2, p.direccion, p.sexo, p.correo, f.id, f.nombre, f.movil, f.telefono, f.id_ref], OUTPUT_COLS=[p.id, p.nombre, p.apellido1, p.apellido2, p.direccion, p.sexo, p.correo, f.id, f.nombre, f.movil, f.telefono, f.id_ref]})
  51. Select(groups=[Postgresql1View.telefonos AS f, SolrView.poblacion AS p], props={SELECT_CRITERIA=p.nombre = f.nombre, OUTPUT_COLS=[p.id, p.nombre, p.apellido1, p.apellido2, p.direccion, p.sexo, p.correo, f.id, f.nombre, f.movil, f.telefono, f.id_ref]})
  52. Join(groups=[SolrView.poblacion AS p, Postgresql1View.telefonos AS f], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=[p.nombre, f.nombre, p.id, p.apellido1, p.apellido2, p.direccion, p.sexo, p.correo, f.id, f.movil, f.telefono, f.id_ref]})
  53. Source(groups=[SolrView.poblacion AS p], props={NESTED_COMMAND=SELECT SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo FROM SolrSourceModel.poblacion, SYMBOL_MAP={p.nombre=SolrSourceModel.poblacion.nombre, p.id=SolrSourceModel.poblacion.id, p.apellido1=SolrSourceModel.poblacion.apellido1, p.apellido2=SolrSourceModel.poblacion.apellido2, p.direccion=SolrSourceModel.poblacion.direccion, p.sexo=SolrSourceModel.poblacion.sexo, p.correo=SolrSourceModel.poblacion.correo}, OUTPUT_COLS=[p.nombre, p.id, p.apellido1, p.apellido2, p.direccion, p.sexo, p.correo]})
  54. Project(groups=[SolrSourceModel.poblacion], props={PROJECT_COLS=[SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo], OUTPUT_COLS=[SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo]})
  55. Access(groups=[SolrSourceModel.poblacion], props={SOURCE_HINT=null, MODEL_ID=Schema name=SolrSourceModel, nameInSource=null, uuid=mmuuid:d7971658-a7a9-4e17-824f-ce1424921c5b, OUTPUT_COLS=[SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo]})
  56. Source(groups=[SolrSourceModel.poblacion], props={OUTPUT_COLS=[SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo]})
  57. Source(groups=[Postgresql1View.telefonos AS f], props={NESTED_COMMAND=SELECT Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref FROM Postgresql1SourceModel.hadoop_telefonos, SYMBOL_MAP={f.nombre=Postgresql1SourceModel.hadoop_telefonos.nombre, f.id=Postgresql1SourceModel.hadoop_telefonos.id, f.movil=Postgresql1SourceModel.hadoop_telefonos.movil, f.telefono=Postgresql1SourceModel.hadoop_telefonos.telefono, f.id_ref=Postgresql1SourceModel.hadoop_telefonos.id_ref}, OUTPUT_COLS=[f.nombre, f.id, f.movil, f.telefono, f.id_ref]})
  58. Project(groups=[Postgresql1SourceModel.hadoop_telefonos], props={PROJECT_COLS=[Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref], OUTPUT_COLS=[Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref]})
  59. Access(groups=[Postgresql1SourceModel.hadoop_telefonos], props={SOURCE_HINT=null, MODEL_ID=Schema name=Postgresql1SourceModel, nameInSource=null, uuid=mmuuid:97bc9352-c469-4e16-bd9c-636493334081, OUTPUT_COLS=[Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref]})
  60. Source(groups=[Postgresql1SourceModel.hadoop_telefonos], props={OUTPUT_COLS=[Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref]})
  61.  
  62.  
  63. ============================================================================
  64. EXECUTING PushSelectCriteria
  65.  
  66. AFTER:
  67. TupleLimit(groups=[])
  68. Project(groups=[Postgresql1View.telefonos AS f, SolrView.poblacion AS p], props={PROJECT_COLS=[p.id, p.nombre, p.apellido1, p.apellido2, p.direccion, p.sexo, p.correo, f.id, f.nombre, f.movil, f.telefono, f.id_ref], OUTPUT_COLS=[p.id, p.nombre, p.apellido1, p.apellido2, p.direccion, p.sexo, p.correo, f.id, f.nombre, f.movil, f.telefono, f.id_ref]})
  69. Join(groups=[SolrView.poblacion AS p, Postgresql1View.telefonos AS f], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[p.nombre = f.nombre], OUTPUT_COLS=[p.nombre, f.nombre, p.id, p.apellido1, p.apellido2, p.direccion, p.sexo, p.correo, f.id, f.movil, f.telefono, f.id_ref]})
  70. Source(groups=[SolrView.poblacion AS p])
  71. Project(groups=[SolrSourceModel.poblacion])
  72. Access(groups=[SolrSourceModel.poblacion])
  73. Source(groups=[SolrSourceModel.poblacion])
  74. Source(groups=[Postgresql1View.telefonos AS f])
  75. Project(groups=[Postgresql1SourceModel.hadoop_telefonos])
  76. Access(groups=[Postgresql1SourceModel.hadoop_telefonos])
  77. Source(groups=[Postgresql1SourceModel.hadoop_telefonos])
  78.  
  79.  
  80. ============================================================================
  81. EXECUTING MergeVirtual
  82.  
  83. AFTER:
  84. TupleLimit(groups=[])
  85. Project(groups=[SolrSourceModel.poblacion, Postgresql1SourceModel.hadoop_telefonos], props={PROJECT_COLS=[SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref], OUTPUT_COLS=[p.id, p.nombre, p.apellido1, p.apellido2, p.direccion, p.sexo, p.correo, f.id, f.nombre, f.movil, f.telefono, f.id_ref]})
  86. Join(groups=[SolrSourceModel.poblacion, Postgresql1SourceModel.hadoop_telefonos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SolrSourceModel.poblacion.nombre = Postgresql1SourceModel.hadoop_telefonos.nombre], OUTPUT_COLS=[p.nombre, f.nombre, p.id, p.apellido1, p.apellido2, p.direccion, p.sexo, p.correo, f.id, f.movil, f.telefono, f.id_ref]})
  87. Access(groups=[SolrSourceModel.poblacion], props={SOURCE_HINT=null, MODEL_ID=Schema name=SolrSourceModel, nameInSource=null, uuid=mmuuid:d7971658-a7a9-4e17-824f-ce1424921c5b, OUTPUT_COLS=[SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo]})
  88. Source(groups=[SolrSourceModel.poblacion])
  89. Access(groups=[Postgresql1SourceModel.hadoop_telefonos], props={SOURCE_HINT=null, MODEL_ID=Schema name=Postgresql1SourceModel, nameInSource=null, uuid=mmuuid:97bc9352-c469-4e16-bd9c-636493334081, OUTPUT_COLS=[Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref]})
  90. Source(groups=[Postgresql1SourceModel.hadoop_telefonos])
  91.  
  92.  
  93. ============================================================================
  94. EXECUTING PushNonJoinCriteria
  95.  
  96. AFTER:
  97. TupleLimit(groups=[])
  98. Project(groups=[SolrSourceModel.poblacion, Postgresql1SourceModel.hadoop_telefonos])
  99. Join(groups=[SolrSourceModel.poblacion, Postgresql1SourceModel.hadoop_telefonos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SolrSourceModel.poblacion.nombre = Postgresql1SourceModel.hadoop_telefonos.nombre], OUTPUT_COLS=[p.nombre, f.nombre, p.id, p.apellido1, p.apellido2, p.direccion, p.sexo, p.correo, f.id, f.movil, f.telefono, f.id_ref]})
  100. Access(groups=[SolrSourceModel.poblacion])
  101. Source(groups=[SolrSourceModel.poblacion])
  102. Access(groups=[Postgresql1SourceModel.hadoop_telefonos])
  103. Source(groups=[Postgresql1SourceModel.hadoop_telefonos])
  104.  
  105.  
  106. ============================================================================
  107. EXECUTING CleanCriteria
  108.  
  109. AFTER:
  110. TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1000, OUTPUT_COLS=null})
  111. Project(groups=[SolrSourceModel.poblacion, Postgresql1SourceModel.hadoop_telefonos], props={PROJECT_COLS=[SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref], OUTPUT_COLS=null})
  112. Join(groups=[SolrSourceModel.poblacion, Postgresql1SourceModel.hadoop_telefonos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SolrSourceModel.poblacion.nombre = Postgresql1SourceModel.hadoop_telefonos.nombre], OUTPUT_COLS=null})
  113. Access(groups=[SolrSourceModel.poblacion], props={SOURCE_HINT=null, MODEL_ID=Schema name=SolrSourceModel, nameInSource=null, uuid=mmuuid:d7971658-a7a9-4e17-824f-ce1424921c5b, OUTPUT_COLS=null})
  114. Source(groups=[SolrSourceModel.poblacion], props={OUTPUT_COLS=null})
  115. Access(groups=[Postgresql1SourceModel.hadoop_telefonos], props={SOURCE_HINT=null, MODEL_ID=Schema name=Postgresql1SourceModel, nameInSource=null, uuid=mmuuid:97bc9352-c469-4e16-bd9c-636493334081, OUTPUT_COLS=null})
  116. Source(groups=[Postgresql1SourceModel.hadoop_telefonos], props={OUTPUT_COLS=null})
  117.  
  118.  
  119. ============================================================================
  120. EXECUTING RaiseAccess
  121.  
  122. AFTER:
  123. TupleLimit(groups=[])
  124. Project(groups=[SolrSourceModel.poblacion, Postgresql1SourceModel.hadoop_telefonos])
  125. Join(groups=[SolrSourceModel.poblacion, Postgresql1SourceModel.hadoop_telefonos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SolrSourceModel.poblacion.nombre = Postgresql1SourceModel.hadoop_telefonos.nombre], OUTPUT_COLS=null})
  126. Access(groups=[SolrSourceModel.poblacion], props={SOURCE_HINT=null, MODEL_ID=Schema name=SolrSourceModel, nameInSource=null, uuid=mmuuid:d7971658-a7a9-4e17-824f-ce1424921c5b, OUTPUT_COLS=null})
  127. Source(groups=[SolrSourceModel.poblacion])
  128. Access(groups=[Postgresql1SourceModel.hadoop_telefonos], props={SOURCE_HINT=null, MODEL_ID=Schema name=Postgresql1SourceModel, nameInSource=null, uuid=mmuuid:97bc9352-c469-4e16-bd9c-636493334081, OUTPUT_COLS=null})
  129. Source(groups=[Postgresql1SourceModel.hadoop_telefonos])
  130.  
  131.  
  132. ============================================================================
  133. EXECUTING CopyCriteria
  134.  
  135. AFTER:
  136. TupleLimit(groups=[])
  137. Project(groups=[SolrSourceModel.poblacion, Postgresql1SourceModel.hadoop_telefonos])
  138. Join(groups=[SolrSourceModel.poblacion, Postgresql1SourceModel.hadoop_telefonos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SolrSourceModel.poblacion.nombre = Postgresql1SourceModel.hadoop_telefonos.nombre], OUTPUT_COLS=null, IS_COPIED=true})
  139. Access(groups=[SolrSourceModel.poblacion])
  140. Source(groups=[SolrSourceModel.poblacion])
  141. Access(groups=[Postgresql1SourceModel.hadoop_telefonos])
  142. Source(groups=[Postgresql1SourceModel.hadoop_telefonos])
  143.  
  144.  
  145. ============================================================================
  146. EXECUTING CleanCriteria
  147.  
  148. AFTER:
  149. TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1000, OUTPUT_COLS=null})
  150. Project(groups=[SolrSourceModel.poblacion, Postgresql1SourceModel.hadoop_telefonos], props={PROJECT_COLS=[SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref], OUTPUT_COLS=null})
  151. Join(groups=[SolrSourceModel.poblacion, Postgresql1SourceModel.hadoop_telefonos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SolrSourceModel.poblacion.nombre = Postgresql1SourceModel.hadoop_telefonos.nombre], OUTPUT_COLS=null, IS_COPIED=true})
  152. Access(groups=[SolrSourceModel.poblacion], props={SOURCE_HINT=null, MODEL_ID=Schema name=SolrSourceModel, nameInSource=null, uuid=mmuuid:d7971658-a7a9-4e17-824f-ce1424921c5b, OUTPUT_COLS=null})
  153. Source(groups=[SolrSourceModel.poblacion], props={OUTPUT_COLS=null})
  154. Access(groups=[Postgresql1SourceModel.hadoop_telefonos], props={SOURCE_HINT=null, MODEL_ID=Schema name=Postgresql1SourceModel, nameInSource=null, uuid=mmuuid:97bc9352-c469-4e16-bd9c-636493334081, OUTPUT_COLS=null})
  155. Source(groups=[Postgresql1SourceModel.hadoop_telefonos], props={OUTPUT_COLS=null})
  156.  
  157.  
  158. ============================================================================
  159. EXECUTING PlanJoins
  160.  
  161. AFTER:
  162. TupleLimit(groups=[])
  163. Project(groups=[SolrSourceModel.poblacion, Postgresql1SourceModel.hadoop_telefonos], props={PROJECT_COLS=[SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref], OUTPUT_COLS=null})
  164. Select(groups=[Postgresql1SourceModel.hadoop_telefonos, SolrSourceModel.poblacion], props={SELECT_CRITERIA=SolrSourceModel.poblacion.nombre = Postgresql1SourceModel.hadoop_telefonos.nombre, EST_SELECTIVITY=0.12577777})
  165. Join(groups=[SolrSourceModel.poblacion, Postgresql1SourceModel.hadoop_telefonos], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP})
  166. Access(groups=[SolrSourceModel.poblacion], props={SOURCE_HINT=null, MODEL_ID=Schema name=SolrSourceModel, nameInSource=null, uuid=mmuuid:d7971658-a7a9-4e17-824f-ce1424921c5b, OUTPUT_COLS=null, EST_CARDINALITY=-1.0})
  167. Source(groups=[SolrSourceModel.poblacion], props={OUTPUT_COLS=null, EST_COL_STATS={SolrSourceModel.poblacion.id=[0.0, 0.0], SolrSourceModel.poblacion.nombre=[0.0, 0.0], SolrSourceModel.poblacion.apellido1=[0.0, 0.0], SolrSourceModel.poblacion.apellido2=[0.0, 0.0], ...}, EST_CARDINALITY=-1.0})
  168. Access(groups=[Postgresql1SourceModel.hadoop_telefonos], props={SOURCE_HINT=null, MODEL_ID=Schema name=Postgresql1SourceModel, nameInSource=null, uuid=mmuuid:97bc9352-c469-4e16-bd9c-636493334081, OUTPUT_COLS=null, EST_CARDINALITY=-1.0})
  169. Source(groups=[Postgresql1SourceModel.hadoop_telefonos], props={OUTPUT_COLS=null, EST_COL_STATS={Postgresql1SourceModel.hadoop_telefonos.id=[-1.0, -1.0], Postgresql1SourceModel.hadoop_telefonos.nombre=[-1.0, -1.0], Postgresql1SourceModel.hadoop_telefonos.movil=[-1.0, -1.0], Postgresql1SourceModel.hadoop_telefonos.telefono=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0})
  170.  
  171.  
  172. ============================================================================
  173. EXECUTING PushSelectCriteria
  174.  
  175. AFTER:
  176. TupleLimit(groups=[])
  177. Project(groups=[SolrSourceModel.poblacion, Postgresql1SourceModel.hadoop_telefonos], props={PROJECT_COLS=[SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref], OUTPUT_COLS=null})
  178. Join(groups=[SolrSourceModel.poblacion, Postgresql1SourceModel.hadoop_telefonos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SolrSourceModel.poblacion.nombre = Postgresql1SourceModel.hadoop_telefonos.nombre]})
  179. Access(groups=[SolrSourceModel.poblacion])
  180. Source(groups=[SolrSourceModel.poblacion])
  181. Access(groups=[Postgresql1SourceModel.hadoop_telefonos])
  182. Source(groups=[Postgresql1SourceModel.hadoop_telefonos])
  183.  
  184.  
  185. ============================================================================
  186. EXECUTING RaiseAccess
  187.  
  188. AFTER:
  189. TupleLimit(groups=[])
  190. Project(groups=[SolrSourceModel.poblacion, Postgresql1SourceModel.hadoop_telefonos])
  191. Join(groups=[SolrSourceModel.poblacion, Postgresql1SourceModel.hadoop_telefonos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SolrSourceModel.poblacion.nombre = Postgresql1SourceModel.hadoop_telefonos.nombre]})
  192. Access(groups=[SolrSourceModel.poblacion], props={SOURCE_HINT=null, MODEL_ID=Schema name=SolrSourceModel, nameInSource=null, uuid=mmuuid:d7971658-a7a9-4e17-824f-ce1424921c5b, OUTPUT_COLS=null, EST_CARDINALITY=-1.0})
  193. Source(groups=[SolrSourceModel.poblacion])
  194. Access(groups=[Postgresql1SourceModel.hadoop_telefonos], props={SOURCE_HINT=null, MODEL_ID=Schema name=Postgresql1SourceModel, nameInSource=null, uuid=mmuuid:97bc9352-c469-4e16-bd9c-636493334081, OUTPUT_COLS=null, EST_CARDINALITY=-1.0})
  195. Source(groups=[Postgresql1SourceModel.hadoop_telefonos])
  196.  
  197.  
  198. ============================================================================
  199. EXECUTING ChooseJoinStrategy
  200.  
  201. AFTER:
  202. TupleLimit(groups=[])
  203. Project(groups=[SolrSourceModel.poblacion, Postgresql1SourceModel.hadoop_telefonos])
  204. Join(groups=[SolrSourceModel.poblacion, Postgresql1SourceModel.hadoop_telefonos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[SolrSourceModel.poblacion.nombre = Postgresql1SourceModel.hadoop_telefonos.nombre], LEFT_EXPRESSIONS=[SolrSourceModel.poblacion.nombre], RIGHT_EXPRESSIONS=[Postgresql1SourceModel.hadoop_telefonos.nombre], NON_EQUI_JOIN_CRITERIA=[]})
  205. Access(groups=[SolrSourceModel.poblacion])
  206. Source(groups=[SolrSourceModel.poblacion])
  207. Access(groups=[Postgresql1SourceModel.hadoop_telefonos])
  208. Source(groups=[Postgresql1SourceModel.hadoop_telefonos])
  209.  
  210.  
  211. ============================================================================
  212. EXECUTING ChooseDependent
  213.  
  214. AFTER:
  215. TupleLimit(groups=[])
  216. Project(groups=[SolrSourceModel.poblacion, Postgresql1SourceModel.hadoop_telefonos])
  217. Join(groups=[SolrSourceModel.poblacion, Postgresql1SourceModel.hadoop_telefonos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[SolrSourceModel.poblacion.nombre = Postgresql1SourceModel.hadoop_telefonos.nombre], LEFT_EXPRESSIONS=[SolrSourceModel.poblacion.nombre], RIGHT_EXPRESSIONS=[Postgresql1SourceModel.hadoop_telefonos.nombre], NON_EQUI_JOIN_CRITERIA=[], DEPENDENT_VALUE_SOURCE=$dsc/id1})
  218. Access(groups=[SolrSourceModel.poblacion], props={SOURCE_HINT=null, MODEL_ID=Schema name=SolrSourceModel, nameInSource=null, uuid=mmuuid:d7971658-a7a9-4e17-824f-ce1424921c5b, OUTPUT_COLS=null, EST_CARDINALITY=-1.0})
  219. Source(groups=[SolrSourceModel.poblacion], props={OUTPUT_COLS=null, EST_COL_STATS={SolrSourceModel.poblacion.id=[0.0, 0.0], SolrSourceModel.poblacion.nombre=[0.0, 0.0], SolrSourceModel.poblacion.apellido1=[0.0, 0.0], SolrSourceModel.poblacion.apellido2=[0.0, 0.0], ...}, EST_CARDINALITY=-1.0})
  220. Select(groups=[Postgresql1SourceModel.hadoop_telefonos], props={SELECT_CRITERIA=Postgresql1SourceModel.hadoop_telefonos.nombre IN (<dependent values>), IS_DEPENDENT_SET=true})
  221. Access(groups=[Postgresql1SourceModel.hadoop_telefonos], props={SOURCE_HINT=null, MODEL_ID=Schema name=Postgresql1SourceModel, nameInSource=null, uuid=mmuuid:97bc9352-c469-4e16-bd9c-636493334081, OUTPUT_COLS=null, EST_CARDINALITY=-1.0})
  222. Source(groups=[Postgresql1SourceModel.hadoop_telefonos], props={OUTPUT_COLS=null, EST_COL_STATS={Postgresql1SourceModel.hadoop_telefonos.id=[-1.0, -1.0], Postgresql1SourceModel.hadoop_telefonos.nombre=[-1.0, -1.0], Postgresql1SourceModel.hadoop_telefonos.movil=[-1.0, -1.0], Postgresql1SourceModel.hadoop_telefonos.telefono=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0})
  223.  
  224.  
  225. ============================================================================
  226. EXECUTING PushSelectCriteria
  227.  
  228. AFTER:
  229. TupleLimit(groups=[])
  230. Project(groups=[SolrSourceModel.poblacion, Postgresql1SourceModel.hadoop_telefonos])
  231. Join(groups=[SolrSourceModel.poblacion, Postgresql1SourceModel.hadoop_telefonos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[SolrSourceModel.poblacion.nombre = Postgresql1SourceModel.hadoop_telefonos.nombre], LEFT_EXPRESSIONS=[SolrSourceModel.poblacion.nombre], RIGHT_EXPRESSIONS=[Postgresql1SourceModel.hadoop_telefonos.nombre], NON_EQUI_JOIN_CRITERIA=[], DEPENDENT_VALUE_SOURCE=$dsc/id1})
  232. Access(groups=[SolrSourceModel.poblacion])
  233. Source(groups=[SolrSourceModel.poblacion])
  234. Access(groups=[Postgresql1SourceModel.hadoop_telefonos], props={SOURCE_HINT=null, MODEL_ID=Schema name=Postgresql1SourceModel, nameInSource=null, uuid=mmuuid:97bc9352-c469-4e16-bd9c-636493334081, OUTPUT_COLS=null, EST_CARDINALITY=-1.0, IS_DEPENDENT_SET=true})
  235. Select(groups=[Postgresql1SourceModel.hadoop_telefonos], props={SELECT_CRITERIA=Postgresql1SourceModel.hadoop_telefonos.nombre IN (<dependent values>), IS_DEPENDENT_SET=true, IS_PUSHED=true})
  236. Source(groups=[Postgresql1SourceModel.hadoop_telefonos], props={OUTPUT_COLS=null, EST_COL_STATS={Postgresql1SourceModel.hadoop_telefonos.id=[-1.0, -1.0], Postgresql1SourceModel.hadoop_telefonos.nombre=[-1.0, -1.0], Postgresql1SourceModel.hadoop_telefonos.movil=[-1.0, -1.0], Postgresql1SourceModel.hadoop_telefonos.telefono=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0})
  237.  
  238.  
  239. ============================================================================
  240. EXECUTING CleanCriteria
  241.  
  242. AFTER:
  243. TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1000, OUTPUT_COLS=null})
  244. Project(groups=[SolrSourceModel.poblacion, Postgresql1SourceModel.hadoop_telefonos], props={PROJECT_COLS=[SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref], OUTPUT_COLS=null})
  245. Join(groups=[SolrSourceModel.poblacion, Postgresql1SourceModel.hadoop_telefonos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[SolrSourceModel.poblacion.nombre = Postgresql1SourceModel.hadoop_telefonos.nombre], LEFT_EXPRESSIONS=[SolrSourceModel.poblacion.nombre], RIGHT_EXPRESSIONS=[Postgresql1SourceModel.hadoop_telefonos.nombre], NON_EQUI_JOIN_CRITERIA=[], DEPENDENT_VALUE_SOURCE=$dsc/id1, OUTPUT_COLS=null})
  246. Access(groups=[SolrSourceModel.poblacion], props={SOURCE_HINT=null, MODEL_ID=Schema name=SolrSourceModel, nameInSource=null, uuid=mmuuid:d7971658-a7a9-4e17-824f-ce1424921c5b, OUTPUT_COLS=null, EST_CARDINALITY=-1.0})
  247. Source(groups=[SolrSourceModel.poblacion], props={OUTPUT_COLS=null, EST_COL_STATS={SolrSourceModel.poblacion.id=[0.0, 0.0], SolrSourceModel.poblacion.nombre=[0.0, 0.0], SolrSourceModel.poblacion.apellido1=[0.0, 0.0], SolrSourceModel.poblacion.apellido2=[0.0, 0.0], ...}, EST_CARDINALITY=-1.0})
  248. Access(groups=[Postgresql1SourceModel.hadoop_telefonos], props={SOURCE_HINT=null, MODEL_ID=Schema name=Postgresql1SourceModel, nameInSource=null, uuid=mmuuid:97bc9352-c469-4e16-bd9c-636493334081, OUTPUT_COLS=null, EST_CARDINALITY=-1.0, IS_DEPENDENT_SET=true})
  249. Select(groups=[Postgresql1SourceModel.hadoop_telefonos], props={SELECT_CRITERIA=Postgresql1SourceModel.hadoop_telefonos.nombre IN (<dependent values>), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=null})
  250. Source(groups=[Postgresql1SourceModel.hadoop_telefonos], props={OUTPUT_COLS=null, EST_COL_STATS={Postgresql1SourceModel.hadoop_telefonos.id=[-1.0, -1.0], Postgresql1SourceModel.hadoop_telefonos.nombre=[-1.0, -1.0], Postgresql1SourceModel.hadoop_telefonos.movil=[-1.0, -1.0], Postgresql1SourceModel.hadoop_telefonos.telefono=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0})
  251.  
  252.  
  253. ============================================================================
  254. EXECUTING PushLimit
  255.  
  256. AFTER:
  257. Project(groups=[SolrSourceModel.poblacion, Postgresql1SourceModel.hadoop_telefonos], props={PROJECT_COLS=[SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref], OUTPUT_COLS=null, SOURCE_HINT=null})
  258. TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1000, OUTPUT_COLS=null})
  259. Join(groups=[SolrSourceModel.poblacion, Postgresql1SourceModel.hadoop_telefonos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[SolrSourceModel.poblacion.nombre = Postgresql1SourceModel.hadoop_telefonos.nombre], LEFT_EXPRESSIONS=[SolrSourceModel.poblacion.nombre], RIGHT_EXPRESSIONS=[Postgresql1SourceModel.hadoop_telefonos.nombre], NON_EQUI_JOIN_CRITERIA=[], DEPENDENT_VALUE_SOURCE=$dsc/id1, OUTPUT_COLS=null})
  260. Access(groups=[SolrSourceModel.poblacion])
  261. Source(groups=[SolrSourceModel.poblacion])
  262. Access(groups=[Postgresql1SourceModel.hadoop_telefonos])
  263. Select(groups=[Postgresql1SourceModel.hadoop_telefonos])
  264. Source(groups=[Postgresql1SourceModel.hadoop_telefonos])
  265.  
  266.  
  267. ============================================================================
  268. EXECUTING AssignOutputElements
  269.  
  270. AFTER:
  271. Project(groups=[SolrSourceModel.poblacion, Postgresql1SourceModel.hadoop_telefonos], props={PROJECT_COLS=[SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref], OUTPUT_COLS=[SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref], SOURCE_HINT=null})
  272. TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1000, OUTPUT_COLS=[SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref]})
  273. Join(groups=[SolrSourceModel.poblacion, Postgresql1SourceModel.hadoop_telefonos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[SolrSourceModel.poblacion.nombre = Postgresql1SourceModel.hadoop_telefonos.nombre], LEFT_EXPRESSIONS=[SolrSourceModel.poblacion.nombre], RIGHT_EXPRESSIONS=[Postgresql1SourceModel.hadoop_telefonos.nombre], NON_EQUI_JOIN_CRITERIA=[], DEPENDENT_VALUE_SOURCE=$dsc/id1, OUTPUT_COLS=[SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref]})
  274. Access(groups=[SolrSourceModel.poblacion], props={SOURCE_HINT=null, MODEL_ID=Schema name=SolrSourceModel, nameInSource=null, uuid=mmuuid:d7971658-a7a9-4e17-824f-ce1424921c5b, OUTPUT_COLS=[SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo], EST_CARDINALITY=-1.0})
  275. Source(groups=[SolrSourceModel.poblacion], props={OUTPUT_COLS=[SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo], EST_COL_STATS={SolrSourceModel.poblacion.id=[0.0, 0.0], SolrSourceModel.poblacion.nombre=[0.0, 0.0], SolrSourceModel.poblacion.apellido1=[0.0, 0.0], SolrSourceModel.poblacion.apellido2=[0.0, 0.0], ...}, EST_CARDINALITY=-1.0})
  276. Access(groups=[Postgresql1SourceModel.hadoop_telefonos], props={SOURCE_HINT=null, MODEL_ID=Schema name=Postgresql1SourceModel, nameInSource=null, uuid=mmuuid:97bc9352-c469-4e16-bd9c-636493334081, OUTPUT_COLS=[Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref], EST_CARDINALITY=-1.0, IS_DEPENDENT_SET=true})
  277. Select(groups=[Postgresql1SourceModel.hadoop_telefonos], props={SELECT_CRITERIA=Postgresql1SourceModel.hadoop_telefonos.nombre IN (<dependent values>), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=[Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref]})
  278. Source(groups=[Postgresql1SourceModel.hadoop_telefonos], props={OUTPUT_COLS=[Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref], EST_COL_STATS={Postgresql1SourceModel.hadoop_telefonos.id=[-1.0, -1.0], Postgresql1SourceModel.hadoop_telefonos.nombre=[-1.0, -1.0], Postgresql1SourceModel.hadoop_telefonos.movil=[-1.0, -1.0], Postgresql1SourceModel.hadoop_telefonos.telefono=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0})
  279.  
  280.  
  281. ============================================================================
  282. EXECUTING CalculateCost
  283.  
  284. AFTER:
  285. Project(groups=[SolrSourceModel.poblacion, Postgresql1SourceModel.hadoop_telefonos], props={PROJECT_COLS=[SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref], OUTPUT_COLS=[SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref], SOURCE_HINT=null, EST_CARDINALITY=1000.0, EST_COL_STATS={SolrSourceModel.poblacion.id=[1000.0, 1.0], SolrSourceModel.poblacion.nombre=[1000.0, 1.0], SolrSourceModel.poblacion.apellido1=[1000.0, 1.0], SolrSourceModel.poblacion.apellido2=[1000.0, 1.0], ...}})
  286. TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1000, OUTPUT_COLS=[SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref], EST_CARDINALITY=1000.0, EST_COL_STATS={SolrSourceModel.poblacion.id=[1000.0, 0.0], SolrSourceModel.poblacion.nombre=[1000.0, 0.0], SolrSourceModel.poblacion.apellido1=[1000.0, 0.0], SolrSourceModel.poblacion.apellido2=[1000.0, 0.0], ...}})
  287. Join(groups=[SolrSourceModel.poblacion, Postgresql1SourceModel.hadoop_telefonos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[SolrSourceModel.poblacion.nombre = Postgresql1SourceModel.hadoop_telefonos.nombre], LEFT_EXPRESSIONS=[SolrSourceModel.poblacion.nombre], RIGHT_EXPRESSIONS=[Postgresql1SourceModel.hadoop_telefonos.nombre], NON_EQUI_JOIN_CRITERIA=[], DEPENDENT_VALUE_SOURCE=$dsc/id1, OUTPUT_COLS=[SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref], EST_CARDINALITY=-1.0})
  288. Access(groups=[SolrSourceModel.poblacion], props={SOURCE_HINT=null, MODEL_ID=Schema name=SolrSourceModel, nameInSource=null, uuid=mmuuid:d7971658-a7a9-4e17-824f-ce1424921c5b, OUTPUT_COLS=[SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo], EST_CARDINALITY=-1.0})
  289. Source(groups=[SolrSourceModel.poblacion], props={OUTPUT_COLS=[SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo], EST_COL_STATS={SolrSourceModel.poblacion.id=[0.0, 0.0], SolrSourceModel.poblacion.nombre=[0.0, 0.0], SolrSourceModel.poblacion.apellido1=[0.0, 0.0], SolrSourceModel.poblacion.apellido2=[0.0, 0.0], ...}, EST_CARDINALITY=-1.0})
  290. Access(groups=[Postgresql1SourceModel.hadoop_telefonos], props={SOURCE_HINT=null, MODEL_ID=Schema name=Postgresql1SourceModel, nameInSource=null, uuid=mmuuid:97bc9352-c469-4e16-bd9c-636493334081, OUTPUT_COLS=[Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref], EST_CARDINALITY=-1.0, IS_DEPENDENT_SET=true})
  291. Select(groups=[Postgresql1SourceModel.hadoop_telefonos], props={SELECT_CRITERIA=Postgresql1SourceModel.hadoop_telefonos.nombre IN (<dependent values>), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=[Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref], EST_CARDINALITY=-1.0})
  292. Source(groups=[Postgresql1SourceModel.hadoop_telefonos], props={OUTPUT_COLS=[Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref], EST_COL_STATS={Postgresql1SourceModel.hadoop_telefonos.id=[-1.0, -1.0], Postgresql1SourceModel.hadoop_telefonos.nombre=[-1.0, -1.0], Postgresql1SourceModel.hadoop_telefonos.movil=[-1.0, -1.0], Postgresql1SourceModel.hadoop_telefonos.telefono=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0})
  293.  
  294.  
  295. ============================================================================
  296. EXECUTING ImplementJoinStrategy
  297.  
  298. AFTER:
  299. Project(groups=[SolrSourceModel.poblacion, Postgresql1SourceModel.hadoop_telefonos])
  300. TupleLimit(groups=[])
  301. Join(groups=[SolrSourceModel.poblacion, Postgresql1SourceModel.hadoop_telefonos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[SolrSourceModel.poblacion.nombre = Postgresql1SourceModel.hadoop_telefonos.nombre], LEFT_EXPRESSIONS=[SolrSourceModel.poblacion.nombre], RIGHT_EXPRESSIONS=[Postgresql1SourceModel.hadoop_telefonos.nombre], NON_EQUI_JOIN_CRITERIA=[], DEPENDENT_VALUE_SOURCE=$dsc/id1, OUTPUT_COLS=[SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref], EST_CARDINALITY=-1.0})
  302. Access(groups=[SolrSourceModel.poblacion], props={SOURCE_HINT=null, MODEL_ID=Schema name=SolrSourceModel, nameInSource=null, uuid=mmuuid:d7971658-a7a9-4e17-824f-ce1424921c5b, OUTPUT_COLS=[SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo], EST_CARDINALITY=-1.0})
  303. Sort(groups=[], props={SORT_ORDER=ORDER BY SolrSourceModel.poblacion.nombre, OUTPUT_COLS=[SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo]})
  304. Source(groups=[SolrSourceModel.poblacion], props={OUTPUT_COLS=[SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo], EST_COL_STATS={SolrSourceModel.poblacion.id=[0.0, 0.0], SolrSourceModel.poblacion.nombre=[0.0, 0.0], SolrSourceModel.poblacion.apellido1=[0.0, 0.0], SolrSourceModel.poblacion.apellido2=[0.0, 0.0], ...}, EST_CARDINALITY=-1.0})
  305. Access(groups=[Postgresql1SourceModel.hadoop_telefonos], props={SOURCE_HINT=null, MODEL_ID=Schema name=Postgresql1SourceModel, nameInSource=null, uuid=mmuuid:97bc9352-c469-4e16-bd9c-636493334081, OUTPUT_COLS=[Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref], EST_CARDINALITY=-1.0, IS_DEPENDENT_SET=true})
  306. Sort(groups=[], props={SORT_ORDER=ORDER BY Postgresql1SourceModel.hadoop_telefonos.nombre, OUTPUT_COLS=[Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref]})
  307. Select(groups=[Postgresql1SourceModel.hadoop_telefonos], props={SELECT_CRITERIA=Postgresql1SourceModel.hadoop_telefonos.nombre IN (<dependent values>), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=[Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref], EST_CARDINALITY=-1.0})
  308. Source(groups=[Postgresql1SourceModel.hadoop_telefonos], props={OUTPUT_COLS=[Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref], EST_COL_STATS={Postgresql1SourceModel.hadoop_telefonos.id=[-1.0, -1.0], Postgresql1SourceModel.hadoop_telefonos.nombre=[-1.0, -1.0], Postgresql1SourceModel.hadoop_telefonos.movil=[-1.0, -1.0], Postgresql1SourceModel.hadoop_telefonos.telefono=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0})
  309.  
  310.  
  311. ============================================================================
  312. EXECUTING MergeCriteria
  313.  
  314. AFTER:
  315. Project(groups=[SolrSourceModel.poblacion, Postgresql1SourceModel.hadoop_telefonos])
  316. TupleLimit(groups=[])
  317. Join(groups=[SolrSourceModel.poblacion, Postgresql1SourceModel.hadoop_telefonos])
  318. Access(groups=[SolrSourceModel.poblacion])
  319. Sort(groups=[])
  320. Source(groups=[SolrSourceModel.poblacion])
  321. Access(groups=[Postgresql1SourceModel.hadoop_telefonos])
  322. Sort(groups=[])
  323. Select(groups=[Postgresql1SourceModel.hadoop_telefonos])
  324. Source(groups=[Postgresql1SourceModel.hadoop_telefonos])
  325.  
  326.  
  327. ============================================================================
  328. EXECUTING PlanSorts
  329.  
  330. AFTER:
  331. Project(groups=[SolrSourceModel.poblacion, Postgresql1SourceModel.hadoop_telefonos])
  332. TupleLimit(groups=[])
  333. Join(groups=[SolrSourceModel.poblacion, Postgresql1SourceModel.hadoop_telefonos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[SolrSourceModel.poblacion.nombre = Postgresql1SourceModel.hadoop_telefonos.nombre], LEFT_EXPRESSIONS=[SolrSourceModel.poblacion.nombre], RIGHT_EXPRESSIONS=[Postgresql1SourceModel.hadoop_telefonos.nombre], NON_EQUI_JOIN_CRITERIA=[], DEPENDENT_VALUE_SOURCE=$dsc/id1, OUTPUT_COLS=[SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref], EST_CARDINALITY=-1.0})
  334. Access(groups=[SolrSourceModel.poblacion])
  335. Sort(groups=[])
  336. Source(groups=[SolrSourceModel.poblacion])
  337. Access(groups=[Postgresql1SourceModel.hadoop_telefonos])
  338. Sort(groups=[])
  339. Select(groups=[Postgresql1SourceModel.hadoop_telefonos])
  340. Source(groups=[Postgresql1SourceModel.hadoop_telefonos])
  341.  
  342.  
  343. ============================================================================
  344. EXECUTING CollapseSource
  345.  
  346. AFTER:
  347. Project(groups=[SolrSourceModel.poblacion, Postgresql1SourceModel.hadoop_telefonos])
  348. TupleLimit(groups=[])
  349. Join(groups=[SolrSourceModel.poblacion, Postgresql1SourceModel.hadoop_telefonos])
  350. Access(groups=[SolrSourceModel.poblacion], props={SOURCE_HINT=null, MODEL_ID=Schema name=SolrSourceModel, nameInSource=null, uuid=mmuuid:d7971658-a7a9-4e17-824f-ce1424921c5b, OUTPUT_COLS=[SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo], EST_CARDINALITY=-1.0, ATOMIC_REQUEST=SELECT SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo FROM SolrSourceModel.poblacion ORDER BY SolrSourceModel.poblacion.nombre})
  351. Access(groups=[Postgresql1SourceModel.hadoop_telefonos], props={SOURCE_HINT=null, MODEL_ID=Schema name=Postgresql1SourceModel, nameInSource=null, uuid=mmuuid:97bc9352-c469-4e16-bd9c-636493334081, OUTPUT_COLS=[Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref], EST_CARDINALITY=-1.0, IS_DEPENDENT_SET=true, ATOMIC_REQUEST=SELECT Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref FROM Postgresql1SourceModel.hadoop_telefonos WHERE Postgresql1SourceModel.hadoop_telefonos.nombre IN (<dependent values>) ORDER BY Postgresql1SourceModel.hadoop_telefonos.nombre})
  352.  
  353.  
  354. ============================================================================
  355. CONVERTING PLAN TREE TO PROCESS TREE
  356.  
  357. PROCESS PLAN =
  358. ProjectNode(0) output=[SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref] [SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref]
  359. LimitNode(1) output=[SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref] limit 1000
  360. JoinNode(2) [Dependent] [MERGE JOIN (ALREADY_SORTED/ALREADY_SORTED)] [INNER JOIN] criteria=[SolrSourceModel.poblacion.nombre=Postgresql1SourceModel.hadoop_telefonos.nombre] output=[SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref]
  361. AccessNode(3) output=[SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo] SELECT SolrSourceModel.poblacion.nombre AS c_0, SolrSourceModel.poblacion.id AS c_1, SolrSourceModel.poblacion.apellido1 AS c_2, SolrSourceModel.poblacion.apellido2 AS c_3, SolrSourceModel.poblacion.direccion AS c_4, SolrSourceModel.poblacion.sexo AS c_5, SolrSourceModel.poblacion.correo AS c_6 FROM SolrSourceModel.poblacion ORDER BY c_0
  362. DependentAccessNode(4) output=[Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref] SELECT g_0.nombre AS c_0, g_0.id AS c_1, g_0.movil AS c_2, g_0.telefono AS c_3, g_0.id_ref AS c_4 FROM Postgresql1SourceModel.hadoop_telefonos AS g_0 WHERE g_0.nombre IN (<dependent values>) ORDER BY c_0
  363.  
  364. ============================================================================
  365.  
  366. ----------------------------------------------------------------------------
  367. OPTIMIZATION COMPLETE:
  368. PROCESSOR PLAN:
  369. ProjectNode(0) output=[SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref] [SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref]
  370. LimitNode(1) output=[SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref] limit 1000
  371. JoinNode(2) [Dependent] [MERGE JOIN (ALREADY_SORTED/ALREADY_SORTED)] [INNER JOIN] criteria=[SolrSourceModel.poblacion.nombre=Postgresql1SourceModel.hadoop_telefonos.nombre] output=[SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref]
  372. AccessNode(3) output=[SolrSourceModel.poblacion.nombre, SolrSourceModel.poblacion.id, SolrSourceModel.poblacion.apellido1, SolrSourceModel.poblacion.apellido2, SolrSourceModel.poblacion.direccion, SolrSourceModel.poblacion.sexo, SolrSourceModel.poblacion.correo] SELECT SolrSourceModel.poblacion.nombre AS c_0, SolrSourceModel.poblacion.id AS c_1, SolrSourceModel.poblacion.apellido1 AS c_2, SolrSourceModel.poblacion.apellido2 AS c_3, SolrSourceModel.poblacion.direccion AS c_4, SolrSourceModel.poblacion.sexo AS c_5, SolrSourceModel.poblacion.correo AS c_6 FROM SolrSourceModel.poblacion ORDER BY c_0
  373. DependentAccessNode(4) output=[Postgresql1SourceModel.hadoop_telefonos.nombre, Postgresql1SourceModel.hadoop_telefonos.id, Postgresql1SourceModel.hadoop_telefonos.movil, Postgresql1SourceModel.hadoop_telefonos.telefono, Postgresql1SourceModel.hadoop_telefonos.id_ref] SELECT g_0.nombre AS c_0, g_0.id AS c_1, g_0.movil AS c_2, g_0.telefono AS c_3, g_0.id_ref AS c_4 FROM Postgresql1SourceModel.hadoop_telefonos AS g_0 WHERE g_0.nombre IN (<dependent values>) ORDER BY c_0
  374.  
  375. ============================================================================
  376.  
  377. 10:41:37,694 ERROR [org.teiid.CONNECTOR] (Worker46_QueryProcessorQueue2499) Connector worker process failed for atomic-request=WoM5jtq7wPPq.7.3.124: java.lang.NullPointerException
  378. at org.teiid.translator.solr.SolrSQLHierarchyVistor.visit(SolrSQLHierarchyVistor.java:70)
  379. at org.teiid.language.ColumnReference.acceptVisitor(ColumnReference.java:72) [teiid-api-8.7.1.redhat-0.jar:8.7.1.redhat-0]
  380. at org.teiid.language.visitor.AbstractLanguageVisitor.visitNode(AbstractLanguageVisitor.java:51) [teiid-api-8.7.1.redhat-0.jar:8.7.1.redhat-0]
  381. at org.teiid.translator.solr.SolrSQLHierarchyVistor.visit(SolrSQLHierarchyVistor.java:248)
  382. at org.teiid.language.SortSpecification.acceptVisitor(SortSpecification.java:53) [teiid-api-8.7.1.redhat-0.jar:8.7.1.redhat-0]
  383. at org.teiid.language.visitor.AbstractLanguageVisitor.visitNode(AbstractLanguageVisitor.java:51) [teiid-api-8.7.1.redhat-0.jar:8.7.1.redhat-0]
  384. at org.teiid.language.visitor.AbstractLanguageVisitor.visitNodes(AbstractLanguageVisitor.java:63) [teiid-api-8.7.1.redhat-0.jar:8.7.1.redhat-0]
  385. at org.teiid.translator.solr.SolrSQLHierarchyVistor.visit(SolrSQLHierarchyVistor.java:243)
  386. at org.teiid.language.OrderBy.acceptVisitor(OrderBy.java:45) [teiid-api-8.7.1.redhat-0.jar:8.7.1.redhat-0]
  387. at org.teiid.language.visitor.AbstractLanguageVisitor.visitNode(AbstractLanguageVisitor.java:51) [teiid-api-8.7.1.redhat-0.jar:8.7.1.redhat-0]
  388. at org.teiid.language.visitor.HierarchyVisitor.visit(HierarchyVisitor.java:140) [teiid-api-8.7.1.redhat-0.jar:8.7.1.redhat-0]
  389. at org.teiid.language.Select.acceptVisitor(Select.java:103) [teiid-api-8.7.1.redhat-0.jar:8.7.1.redhat-0]
  390. at org.teiid.language.visitor.AbstractLanguageVisitor.visitNode(AbstractLanguageVisitor.java:51) [teiid-api-8.7.1.redhat-0.jar:8.7.1.redhat-0]
  391. at org.teiid.translator.solr.SolrQueryExecution.<init>(SolrQueryExecution.java:61)
  392. at org.teiid.translator.solr.SolrExecutionFactory.createResultSetExecution(SolrExecutionFactory.java:97)
  393. at org.teiid.translator.solr.SolrExecutionFactory.createResultSetExecution(SolrExecutionFactory.java:39)
  394. at org.teiid.translator.ExecutionFactory.createExecution(ExecutionFactory.java:300) [teiid-api-8.7.1.redhat-0.jar:8.7.1.redhat-0]
  395. at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:316) [teiid-engine-8.7.1.redhat-0.jar:8.7.1.redhat-0]
  396. at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:298) [teiid-engine-8.7.1.redhat-0.jar:8.7.1.redhat-0]
  397. at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110) [teiid-engine-8.7.1.redhat-0.jar:8.7.1.redhat-0]
  398. at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107) [teiid-engine-8.7.1.redhat-0.jar:8.7.1.redhat-0]
  399. at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_45]
  400. at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.7.1.redhat-0.jar:8.7.1.redhat-0]
  401. at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.1.redhat-0.jar:8.7.1.redhat-0]
  402. at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.1.redhat-0.jar:8.7.1.redhat-0]
  403. at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.7.1.redhat-0.jar:8.7.1.redhat-0]
  404. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_45]
  405. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_45]
  406. at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_45]
  407.  
  408. 10:41:37,697 ERROR [org.teiid.PROCESSOR] (Worker45_QueryProcessorQueue2500) TEIID30019 Unexpected exception for request WoM5jtq7wPPq.7: java.lang.NullPointerException
  409. at org.teiid.translator.solr.SolrSQLHierarchyVistor.visit(SolrSQLHierarchyVistor.java:70)
  410. at org.teiid.language.ColumnReference.acceptVisitor(ColumnReference.java:72) [teiid-api-8.7.1.redhat-0.jar:8.7.1.redhat-0]
  411. at org.teiid.language.visitor.AbstractLanguageVisitor.visitNode(AbstractLanguageVisitor.java:51) [teiid-api-8.7.1.redhat-0.jar:8.7.1.redhat-0]
  412. at org.teiid.translator.solr.SolrSQLHierarchyVistor.visit(SolrSQLHierarchyVistor.java:248)
  413. at org.teiid.language.SortSpecification.acceptVisitor(SortSpecification.java:53) [teiid-api-8.7.1.redhat-0.jar:8.7.1.redhat-0]
  414. at org.teiid.language.visitor.AbstractLanguageVisitor.visitNode(AbstractLanguageVisitor.java:51) [teiid-api-8.7.1.redhat-0.jar:8.7.1.redhat-0]
  415. at org.teiid.language.visitor.AbstractLanguageVisitor.visitNodes(AbstractLanguageVisitor.java:63) [teiid-api-8.7.1.redhat-0.jar:8.7.1.redhat-0]
  416. at org.teiid.translator.solr.SolrSQLHierarchyVistor.visit(SolrSQLHierarchyVistor.java:243)
  417. at org.teiid.language.OrderBy.acceptVisitor(OrderBy.java:45) [teiid-api-8.7.1.redhat-0.jar:8.7.1.redhat-0]
  418. at org.teiid.language.visitor.AbstractLanguageVisitor.visitNode(AbstractLanguageVisitor.java:51) [teiid-api-8.7.1.redhat-0.jar:8.7.1.redhat-0]
  419. at org.teiid.language.visitor.HierarchyVisitor.visit(HierarchyVisitor.java:140) [teiid-api-8.7.1.redhat-0.jar:8.7.1.redhat-0]
  420. at org.teiid.language.Select.acceptVisitor(Select.java:103) [teiid-api-8.7.1.redhat-0.jar:8.7.1.redhat-0]
  421. at org.teiid.language.visitor.AbstractLanguageVisitor.visitNode(AbstractLanguageVisitor.java:51) [teiid-api-8.7.1.redhat-0.jar:8.7.1.redhat-0]
  422. at org.teiid.translator.solr.SolrQueryExecution.<init>(SolrQueryExecution.java:61)
  423. at org.teiid.translator.solr.SolrExecutionFactory.createResultSetExecution(SolrExecutionFactory.java:97)
  424. at org.teiid.translator.solr.SolrExecutionFactory.createResultSetExecution(SolrExecutionFactory.java:39)
  425. at org.teiid.translator.ExecutionFactory.createExecution(ExecutionFactory.java:300) [teiid-api-8.7.1.redhat-0.jar:8.7.1.redhat-0]
  426. at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:316) [teiid-engine-8.7.1.redhat-0.jar:8.7.1.redhat-0]
  427. at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:298) [teiid-engine-8.7.1.redhat-0.jar:8.7.1.redhat-0]
  428. at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110) [teiid-engine-8.7.1.redhat-0.jar:8.7.1.redhat-0]
  429. at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107) [teiid-engine-8.7.1.redhat-0.jar:8.7.1.redhat-0]
  430. at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_45]
  431. at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.7.1.redhat-0.jar:8.7.1.redhat-0]
  432. at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.1.redhat-0.jar:8.7.1.redhat-0]
  433. at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.1.redhat-0.jar:8.7.1.redhat-0]
  434. at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.7.1.redhat-0.jar:8.7.1.redhat-0]
  435. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_45]
  436. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_45]
  437. at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_45]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!