API tools faq
paste
Advertisement
MNMAMI

df.explain(true)

MNMAMI
Mar 24th, 2016
142
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 20.76 KB | None | 0 0
raw download clone embed print report
  1. == Parsed Logical Plan ==
  2. 'Distinct
  3. 'Union
  4. 'Distinct
  5. 'Project [unresolvedalias('p.id),unresolvedalias('p.`www.w3.org/2000/01/rdf-schema#label`),unresolvedalias('p.`www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1`)]
  6. 'Filter (((('p.`type_www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/ProductType2` = 1) && ('p.id = 'p2.id)) && ('p.`www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyNumeric1` > 137)) && ('p4.id = 'p.id))
  7. 'Join Inner, None
  8. 'Join Inner, None
  9. 'UnresolvedRelation [product], Some(p)
  10. 'Subquery p2
  11. 'Distinct
  12. 'Project [unresolvedalias('p1.id)]
  13. 'Filter ('p1.`www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productFeature` = www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/ProductFeature187)
  14. 'UnresolvedRelation [product], Some(p1)
  15. 'Subquery p4
  16. 'Distinct
  17. 'Project [unresolvedalias('p3.id)]
  18. 'Filter ('p3.`www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productFeature` = www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/ProductFeature190)
  19. 'UnresolvedRelation [product], Some(p3)
  20. 'Limit 10
  21. 'Sort ['p.`www.w3.org/2000/01/rdf-schema#label` ASC], true
  22. 'Distinct
  23. 'Project [unresolvedalias('p.id),unresolvedalias('p.`www.w3.org/2000/01/rdf-schema#label`),unresolvedalias('p.`www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1`)]
  24. 'Filter (((('p.`type_www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/ProductType2` = 1) && ('p.id = 'p2.id)) && ('p.`www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyNumeric2` > 93)) && ('p6.id = 'p.id))
  25. 'Join Inner, None
  26. 'Join Inner, None
  27. 'UnresolvedRelation [product], Some(p)
  28. 'Subquery p2
  29. 'Distinct
  30. 'Project [unresolvedalias('p1.id)]
  31. 'Filter ('p1.`www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productFeature` = www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/ProductFeature187)
  32. 'UnresolvedRelation [product], Some(p1)
  33. 'Subquery p6
  34. 'Distinct
  35. 'Project [unresolvedalias('p5.id)]
  36. 'Filter ('p5.`www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productFeature` = www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/ProductFeature195)
  37. 'UnresolvedRelation [product], Some(p5)
  38.  
  39. == Analyzed Logical Plan ==
  40. id: string, www.w3.org/2000/01/rdf-schema#label: string, www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1: string
  41. Distinct
  42. Union
  43. Distinct
  44. Project [id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086]
  45. Filter ((((type_www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/ProductType2#1244 = 1) && (id#240 = id#20541)) && (www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyNumeric1#901 > 137)) && (id#22571 = id#240))
  46. Join Inner, None
  47. Join Inner, None
  48. Subquery p
  49. Subquery product
  50. Relation[...] ParquetRelation[hdfs://xxx:54310/output/Parquets200M/www4.wiwiss.fu@berlin.de__bizer__bsbm__v01__vocabulary__Product]
  51. Subquery p2
  52. Distinct
  53. Project [id#20541]
  54. Filter (www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productFeature#20783 = www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/ProductFeature187)
  55. Subquery p1
  56. Subquery product
  57. Relation[...] ParquetRelation[hdfs://xxx:54310/output/Parquets200M/www4.wiwiss.fu@berlin.de__bizer__bsbm__v01__vocabulary__Product]
  58. Subquery p4
  59. Distinct
  60. Project [id#22571]
  61. Filter (www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productFeature#22813 = www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/ProductFeature190)
  62. Subquery p3
  63. Subquery product
  64. Relation[...] ParquetRelation[hdfs://xxx:54310/output/Parquets200M/www4.wiwiss.fu@berlin.de__bizer__bsbm__v01__vocabulary__Product]
  65. Limit 10
  66. Sort [www.w3.org/2000/01/rdf-schema#label#1618 ASC], true
  67. Distinct
  68. Project [id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086]
  69. Filter ((((type_www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/ProductType2#1244 = 1) && (id#240 = id#24601)) && (www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyNumeric2#578 > 93)) && (id#26631 = id#240))
  70. Join Inner, None
  71. Join Inner, None
  72. Subquery p
  73. Subquery product
  74. Relation[...] ParquetRelation[hdfs://xxx:54310/output/Parquets200M/www4.wiwiss.fu@berlin.de__bizer__bsbm__v01__vocabulary__Product]
  75. Subquery p2
  76. Distinct
  77. Project [id#24601]
  78. Filter (www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productFeature#24843 = www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/ProductFeature187)
  79. Subquery p1
  80. Subquery product
  81. Relation[...] ParquetRelation[hdfs://xxx:54310/output/Parquets200M/www4.wiwiss.fu@berlin.de__bizer__bsbm__v01__vocabulary__Product]
  82. Subquery p6
  83. Distinct
  84. Project [id#26631]
  85. Filter (www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productFeature#26873 = www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/ProductFeature195)
  86. Subquery p5
  87. Subquery product
  88. Relation[...] ParquetRelation[hdfs://xxx:54310/output/Parquets200M/www4.wiwiss.fu@berlin.de__bizer__bsbm__v01__vocabulary__Product]
  89.  
  90. == Optimized Logical Plan ==
  91. Aggregate [id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086], [id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086]
  92. Union
  93. Aggregate [id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086], [id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086]
  94. Project [id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086]
  95. Join Inner, Some((id#22571 = id#240))
  96. Project [id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086]
  97. Join Inner, Some((id#240 = id#20541))
  98. Project [id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086]
  99. Filter ((type_www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/ProductType2#1244 = 1) && (www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyNumeric1#901 > 137))
  100. InMemoryRelation [...]), Some(product)
  101. Aggregate [id#20541], [id#20541]
  102. Project [id#20541]
  103. Filter (www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productFeature#20783 = www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/ProductFeature187)
  104. InMemoryRelation [...]), Some(product)
  105. Aggregate [id#22571], [id#22571]
  106. Project [id#22571]
  107. Filter (www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productFeature#22813 = www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/ProductFeature190)
  108. InMemoryRelation [...]), Some(product)
  109. Limit 10
  110. Sort [www.w3.org/2000/01/rdf-schema#label#1618 ASC], true
  111. Aggregate [id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086], [id#240,www.w3.org/2000/01/rdf-schema#l InMemoryRelation [...]), Some(product)
  112. Aggregate [id#26631], [id#26631]
  113. Project [id#26631]
  114. Filter (www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productFeature#26873 = www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/ProductFeature195)
  115. InMemoryRelation [...]), Some(product)
  116.  
  117. == Physical Plan ==
  118. TungstenAggregate(key=[id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086], functions=[], output=[id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086])
  119. TungstenExchange hashpartitioning(id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086)
  120. TungstenAggregate(key=[id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086], functions=[], output=[id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086])
  121. Union
  122. TungstenAggregate(key=[id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086], functions=[], output=[id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086])
  123. TungstenAggregate(key=[id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086], functions=[], output=[id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086])
  124. TungstenProject [id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086]
  125. SortMergeJoin [id#240], [id#22571]
  126. TungstenProject [id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086]
  127. SortMergeJoin [id#240], [id#20541]
  128. TungstenSort [id#240 ASC], false, 0
  129. TungstenExchange hashpartitioning(id#240)
  130. ConvertToUnsafe
  131. Project [id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086]
  132. Filter ((type_www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/ProductType2#1244 = 1) && (www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyNumeric1#901 > 137))
  133. InMemoryColumnarTableScan [...]), Some(product))
  134. TungstenSort [id#20541 ASC], false, 0
  135. TungstenAggregate(key=[id#20541], functions=[], output=[id#20541])
  136. TungstenExchange hashpartitioning(id#20541)
  137. TungstenAggregate(key=[id#20541], functions=[], output=[id#20541])
  138. Project [id#20541]
  139. Filter (www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productFeature#20783 = www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/ProductFeature187)
  140. InMemoryColumnarTableScan [...]), Some(product))
  141. TungstenSort [id#22571 ASC], false, 0
  142. TungstenAggregate(key=[id#22571], functions=[], output=[id#22571])
  143. TungstenExchange hashpartitioning(id#22571)
  144. TungstenAggregate(key=[id#22571], functions=[], output=[id#22571])
  145. Project [id#22571]
  146. Filter (www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productFeature#22813 = www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/ProductFeature190)
  147. InMemoryColumnarTableScan [...]), Some(product))
  148. ConvertToUnsafe
  149. TakeOrderedAndProject(limit=10, orderBy=[www.w3.org/2000/01/rdf-schema#label#1618 ASC], output=[id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086])
  150. ConvertToSafe
  151. TungstenAggregate(key=[id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086], functions=[], output=[id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086])
  152. TungstenAggregate(key=[id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086], functions=[], output=[id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086])
  153. TungstenProject [id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086]
  154. SortMergeJoin [id#240], [id#26631]
  155. TungstenProject [id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086]
  156. SortMergeJoin [id#240], [id#24601]
  157. TungstenSort [id#240 ASC], false, 0
  158. TungstenExchange hashpartitioning(id#240)
  159. ConvertToUnsafe
  160. Project [id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086]
  161. Filter ((type_www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/ProductType2#1244 = 1) && (www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyNumeric2#578 > 93))
  162. InMemoryColumnarTableScan [...]), Some(product))
  163. TungstenSort [id#26631 ASC], false, 0
  164. TungstenAggregate(key=[id#26631], functions=[], output=[id#26631])
  165. TungstenExchange hashpartitioning(id#26631)
  166. TungstenAggregate(key=[id#26631], functions=[], output=[id#26631])
  167. Project [id#26631]
  168. Filter (www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productFeature#26873 = www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/ProductFeature195)
  169. InMemoryColumnarTableScan [...]), Some(product))
  170.  
  171. Code Generation: trueabel#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086]
  172. Project [id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086]
  173. Join Inner, Some((id#26631 = id#240))
  174. Project [id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086]
  175. Join Inner, Some((id#240 = id#24601))
  176. Project [id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086]
  177. Filter ((type_www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/ProductType2#1244 = 1) && (www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyNumeric2#578 > 93))
  178. InMemoryRelation [...]), Some(product)
  179. Aggregate [id#24601], [id#24601]
  180. Project [id#24601]
  181. Filter (www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productFeature#24843 = www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/ProductFeature187)
  182. InMemoryRelation [...]), Some(product)
  183. Aggregate [id#26631], [id#26631]
  184. Project [id#26631]
  185. Filter (www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productFeature#26873 = www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/ProductFeature195)
  186. InMemoryRelation [...]), Some(product)
  187.  
  188. == Physical Plan ==
  189. TungstenAggregate(key=[id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086], functions=[], output=[id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086])
  190. TungstenExchange hashpartitioning(id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086)
  191. TungstenAggregate(key=[id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086], functions=[], output=[id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086])
  192. Union
  193. TungstenAggregate(key=[id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086], functions=[], output=[id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086])
  194. TungstenAggregate(key=[id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086], functions=[], output=[id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086])
  195. TungstenProject [id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086]
  196. SortMergeJoin [id#240], [id#22571]
  197. TungstenProject [id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086]
  198. SortMergeJoin [id#240], [id#20541]
  199. TungstenSort [id#240 ASC], false, 0
  200. TungstenExchange hashpartitioning(id#240)
  201. ConvertToUnsafe
  202. Project [id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086]
  203. Filter ((type_www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/ProductType2#1244 = 1) && (www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyNumeric1#901 > 137))
  204. InMemoryColumnarTableScan [...]), Some(product))
  205. TungstenSort [id#20541 ASC], false, 0
  206. TungstenAggregate(key=[id#20541], functions=[], output=[id#20541])
  207. TungstenExchange hashpartitioning(id#20541)
  208. TungstenAggregate(key=[id#20541], functions=[], output=[id#20541])
  209. Project [id#20541]
  210. Filter (www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productFeature#20783 = www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/ProductFeature187)
  211. InMemoryColumnarTableScan [...]), Some(product))
  212. TungstenSort [id#22571 ASC], false, 0
  213. TungstenAggregate(key=[id#22571], functions=[], output=[id#22571])
  214. TungstenExchange hashpartitioning(id#22571)
  215. TungstenAggregate(key=[id#22571], functions=[], output=[id#22571])
  216. Project [id#22571]
  217. Filter (www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productFeature#22813 = www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/ProductFeature190)
  218. InMemoryColumnarTableScan [...]), Some(product))
  219. ConvertToUnsafe
  220. TakeOrderedAndProject(limit=10, orderBy=[www.w3.org/2000/01/rdf-schema#label#1618 ASC], output=[id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086])
  221. ConvertToSafe
  222. TungstenAggregate(key=[id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086], functions=[], output=[id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086])
  223. TungstenAggregate(key=[id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086], functions=[], output=[id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086])
  224. TungstenProject [id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086]
  225. SortMergeJoin [id#240], [id#26631]
  226. TungstenProject [id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086]
  227. SortMergeJoin [id#240], [id#24601]
  228. TungstenSort [id#240 ASC], false, 0
  229. TungstenExchange hashpartitioning(id#240)
  230. ConvertToUnsafe
  231. Project [id#240,www.w3.org/2000/01/rdf-schema#label#1618,www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyTextual1#1086]
  232. Filter ((type_www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/ProductType2#1244 = 1) && (www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productPropertyNumeric2#578 > 93))
  233. InMemoryColumnarTableScan [...]), Some(product))
  234. TungstenSort [id#26631 ASC], false, 0
  235. TungstenAggregate(key=[id#26631], functions=[], output=[id#26631])
  236. TungstenExchange hashpartitioning(id#26631)
  237. TungstenAggregate(key=[id#26631], functions=[], output=[id#26631])
  238. Project [id#26631]
  239. Filter (www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/productFeature#26873 = www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/ProductFeature195)
  240. InMemoryColumnarTableScan [...]), Some(product))
  241.  
  242. Code Generation: true
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!