zhouqingqing/qpmodel issues and pull requests

#311 - Second iteration of new ordinal resolution framework. Add helper data structures to maintain list of column references in the order they appear without duplicates, and required output expressions in the order they appear. Call children to set their outputs, given the current node's outputs.

Pull Request - State: closed - Opened by zhouqingqing almost 4 years ago

#310 - Delete qpmodel_m1.pptx

Pull Request - State: closed - Opened by zhouqingqing almost 4 years ago

#309 - Delete qpmodel_m2.pptx

Pull Request - State: closed - Opened by zhouqingqing almost 4 years ago

#308 - Delete qpmodel_m1.pptx

Pull Request - State: closed - Opened by zhouqingqing almost 4 years ago

#307 - CTE optimization based on CTE producer/consumer model

Pull Request - State: closed - Opened by 9DemonFox about 4 years ago - 1 comment

#306 - add a separate projection node

Issue - State: closed - Opened by zhouqingqing about 4 years ago - 1 comment

#305 - Resolve2

Pull Request - State: closed - Opened by pkommoju about 4 years ago

#304 - year end clean up and happy new year!

Pull Request - State: closed - Opened by zhouqingqing about 4 years ago

#303 - memory fix for native code

Pull Request - State: closed - Opened by pkommoju about 4 years ago

#302 - fix windows build failure

Pull Request - State: closed - Opened by zhouqingqing about 4 years ago

#301 - cleanup code a bit

Pull Request - State: closed - Opened by zhouqingqing about 4 years ago

#300 - join filter with separate input rows instead of merge them first

Issue - State: open - Opened by zhouqingqing about 4 years ago

#299 - accelerate one time big data set query

Issue - State: open - Opened by zhouqingqing about 4 years ago

#298 - windows build is broken

Issue - State: closed - Opened by zhouqingqing about 4 years ago - 2 comments

#297 - Andb parser int

Pull Request - State: closed - Opened by pkommoju about 4 years ago

#296 - Andb parser int

Pull Request - State: closed - Opened by pkommoju about 4 years ago

#295 - Update README.md

Pull Request - State: closed - Opened by zhouqingqing about 4 years ago

#294 - trying to force a build

Pull Request - State: closed - Opened by pkommoju about 4 years ago

#293 - Native parser fix 02

Pull Request - State: closed - Opened by pkommoju about 4 years ago

#292 - Native parser fix

Pull Request - State: closed - Opened by pkommoju about 4 years ago

#291 - New parser int

Pull Request - State: closed - Opened by pkommoju about 4 years ago
Labels: bug

#290 - Andb parser int

Pull Request - State: closed - Opened by pkommoju about 4 years ago - 2 comments

#289 - use formal contract method instead of debug.assert for spec enforcement

Pull Request - State: closed - Opened by zhouqingqing about 4 years ago

#288 - Andb parser int

Pull Request - State: closed - Opened by pkommoju about 4 years ago

#286 - Andb parser int

Pull Request - State: closed - Opened by pkommoju about 4 years ago

#285 - only for disscussion

Pull Request - State: closed - Opened by zhouruiapple about 4 years ago - 1 comment
Labels: question

#284 - Andb parser int

Pull Request - State: closed - Opened by pkommoju about 4 years ago

#283 - Andb parser int

Pull Request - State: closed - Opened by pkommoju about 4 years ago - 1 comment

#282 - compiler compliance fix

Pull Request - State: closed - Opened by zhouqingqing about 4 years ago

#281 - Andb parser int

Pull Request - State: closed - Opened by pkommoju about 4 years ago

#280 - introduce stream concept

Pull Request - State: closed - Opened by zhouqingqing about 4 years ago

#279 - KEY NOTE

Issue - State: closed - Opened by zhouruiapple about 4 years ago
Labels: question

#278 - generate tpcds output files for comparation

Pull Request - State: closed - Opened by 9DemonFox about 4 years ago - 1 comment

#277 - Fix some of Bugs in CTE, include subquery cost, tabel reference

Pull Request - State: closed - Opened by 9DemonFox about 4 years ago - 6 comments

#276 - Questions from design review

Issue - State: closed - Opened by zhouruiapple about 4 years ago
Labels: question

#275 - #issue83 tpcds

Pull Request - State: closed - Opened by 9DemonFox about 4 years ago - 2 comments

#274 - Andb parser int

Pull Request - State: closed - Opened by pkommoju about 4 years ago

#273 - CASE WHEN in WHERE clause fails tpcds q04

Issue - State: open - Opened by 9DemonFox about 4 years ago

#272 - we should realize the MarkJoin as HashJoin

Issue - State: open - Opened by 9DemonFox over 4 years ago - 2 comments

#271 - OR should be handled in scalarToSingleJoin and inToMarkJoin

Issue - State: open - Opened by 9DemonFox over 4 years ago - 6 comments

#270 - enable optimize_.enable_subquery_unnest_ = false

Pull Request - State: closed - Opened by 9DemonFox over 4 years ago - 1 comment

#269 - test option.optimize_.enable_subquery_unnest_

Pull Request - State: closed - Opened by 9DemonFox over 4 years ago - 1 comment

#268 - some correlated subquery SQL will failed after setting optimize_.enable_subquery_unnest_ false

Issue - State: open - Opened by 9DemonFox over 4 years ago

#267 - enhance subquery tests

Pull Request - State: closed - Opened by zhouqingqing over 4 years ago

#266 - fix to keep the original stack trace

Pull Request - State: closed - Opened by zhouqingqing over 4 years ago

#265 - #issue246

Pull Request - State: closed - Opened by 9DemonFox over 4 years ago - 3 comments

#264 - #issue72 account subquery cost of scalarSubquery in SELECT clause to inclusive cost

Pull Request - State: closed - Opened by 9DemonFox over 4 years ago - 6 comments

#263 - tpch FROM subquery bug

Issue - State: closed - Opened by 9DemonFox over 4 years ago - 1 comment

#262 - #issue 246 Fix IN logic in non-corelated subquery and InExpr

Pull Request - State: closed - Opened by 9DemonFox over 4 years ago

#261 - add 3.2 Subquery decorrelation

Pull Request - State: closed - Opened by 9DemonFox over 4 years ago

#260 - Doc#3.2subquery

Pull Request - State: closed - Opened by 9DemonFox over 4 years ago

#259 - Aggregates in subquery where

Pull Request - State: closed - Opened by pkommoju over 4 years ago

#258 - add native experimental porting framework

Pull Request - State: closed - Opened by zhouqingqing over 4 years ago

#257 - fix OR handling in subquery decorrelation

Pull Request - State: closed - Opened by 9DemonFox over 4 years ago - 5 comments

#256 - upload design introduction

Pull Request - State: closed - Opened by zhouruiapple over 4 years ago

#255 - upload design introduction part 01

Pull Request - State: closed - Opened by zhouruiapple over 4 years ago

#254 - upload design introduction

Pull Request - State: closed - Opened by zhouruiapple over 4 years ago

#253 - test ppt

Pull Request - State: closed - Opened by zhouruiapple over 4 years ago

#252 - test new file

Pull Request - State: closed - Opened by zhouruiapple over 4 years ago

#251 - test push

Pull Request - State: closed - Opened by zhouruiapple over 4 years ago

#250 - REMOVE_FROM WORK: stage 5

Pull Request - State: closed - Opened by pkommoju over 4 years ago

#249 - REMOVE_FROM WORK: stage 4

Pull Request - State: closed - Opened by pkommoju over 4 years ago

#248 - REMOVE_FROM WORK: fix setop

Pull Request - State: closed - Opened by pkommoju over 4 years ago

#247 - REMOVE_FROM WORK: stage 2

Pull Request - State: closed - Opened by pkommoju over 4 years ago

#246 - # NOT IN subquery Logic

Issue - State: closed - Opened by 9DemonFox over 4 years ago - 4 comments

#245 - REMOVE_FROM WORK: stage 1

Pull Request - State: closed - Opened by pkommoju over 4 years ago

#244 - slightly cleanup codefactor issues

Pull Request - State: closed - Opened by zhouqingqing over 4 years ago

#243 - Documentation for property enforcement

Pull Request - State: closed - Opened by arzuschen over 4 years ago

#242 - add IN subquery decorrelation support & fix not handle NOT IN bug

Pull Request - State: closed - Opened by 9DemonFox over 4 years ago - 3 comments

#241 - support nestted exist subquery, see TestExistsSubquery

Pull Request - State: closed - Opened by 9DemonFox over 4 years ago - 1 comment

#240 - Issue72 simple selection subquery

Pull Request - State: closed - Opened by 9DemonFox over 4 years ago

#239 - TestStringLike Fixed

Pull Request - State: closed - Opened by 9DemonFox over 4 years ago

#238 - unit test consistancy

Pull Request - State: closed - Opened by 9DemonFox over 4 years ago - 1 comment

#237 - where n_name like "A%" get wrong result

Issue - State: closed - Opened by 9DemonFox over 4 years ago - 1 comment

#236 - #issue72 select subquery fixed & more than one markJoin support

Pull Request - State: closed - Opened by 9DemonFox over 4 years ago - 12 comments

#235 - Remove from 01

Pull Request - State: closed - Opened by pkommoju over 4 years ago - 3 comments

#234 - #issue72 subquery in select

Pull Request - State: closed - Opened by 9DemonFox over 4 years ago

#233 - Fix #issue72 subquery in from clause

Pull Request - State: closed - Opened by 9DemonFox over 4 years ago - 11 comments

#232 - Move aggregate resolution code out of CloneFixColumnOrdinal

Pull Request - State: closed - Opened by pkommoju over 4 years ago

#231 - selecting non existing column returns null instead of error.

Issue - State: closed - Opened by pkommoju over 4 years ago - 5 comments

#230 - what if x.query_.physicPlan_ is null here, it's a bug should be fixed

Issue - State: closed - Opened by 9DemonFox over 4 years ago - 4 comments

#229 - fix normalized group by list was getting lost

Pull Request - State: closed - Opened by pkommoju over 4 years ago

#228 - accouting subquery's cost into total cost #72

Pull Request - State: closed - Opened by 9DemonFox over 4 years ago - 2 comments

#227 - fix AggCountStar conflicting memo signature

Pull Request - State: closed - Opened by zhouqingqing over 4 years ago

#224 - [BUG] Incorrect handling of BETWEEN predicate, EXISTS, NOT EXISTS, IN, NOT IN subqueries

Issue - State: open - Opened by pkommoju over 4 years ago - 4 comments

#220 - add IN correlated subquery support

Issue - State: closed - Opened by zhouqingqing over 4 years ago - 1 comment

#217 - Change cardinality calculation for distributed plan and fix bugs

Pull Request - State: closed - Opened by arzuschen over 4 years ago - 2 comments

#213 - where exists or exists exception

Issue - State: closed - Opened by pkommoju over 4 years ago - 11 comments

#197 - Distributed TPCH incorrect results and sub-optimal plan

Issue - State: open - Opened by arzuschen over 4 years ago - 3 comments

#188 - TPCH distributed test errors (without MEMO)

Issue - State: open - Opened by arzuschen over 4 years ago - 4 comments

#178 - Incorrect result from derived table subquery with aggregations

Issue - State: closed - Opened by pkommoju over 4 years ago - 3 comments

#129 - n-ary join estimation yield different CE for members in the same group

Issue - State: closed - Opened by zhouqingqing over 4 years ago

#113 - [Algebrizer/Rewriter] make OptimizeOption.remove_from_ default to true

Issue - State: open - Opened by zhouqingqing over 4 years ago - 1 comment

#100 - stream aggregation support

Issue - State: closed - Opened by zhouqingqing over 4 years ago - 1 comment

#99 - unittest.RunCodeGen.TestSimpleSlect() may fail because can't find csc.exe

Issue - State: closed - Opened by zhouqingqing over 4 years ago - 2 comments

#98 - Changeset with changes for TPC-H 1G Statistical Data

Pull Request - State: closed - Opened by TheWanderingMinstrel over 4 years ago

#97 - Changeset with changes for TPC-H 1G Statistical Data

Pull Request - State: closed - Opened by TheWanderingMinstrel over 4 years ago - 1 comment

#96 - use execution feedback to improve CE / re-optimization / AQP

Issue - State: open - Opened by zhouqingqing over 4 years ago

#95 - Zero Cardinality Optimization

Issue - State: open - Opened by arzuschen over 4 years ago

#94 - window function support

Issue - State: open - Opened by zhouqingqing almost 5 years ago

GitHub / zhouqingqing/qpmodel issues and pull requests