zhouqingqing/qpmodel issues and pull requests

#93 - Migrate to dotnet core

Issue - State: closed - Opened by dovahcrow almost 5 years ago - 1 comment

#92 - PREPARE statement with codeGen support

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

#91 - CE and cost model todo items

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

#90 - Regression Test to Compare 1G Stat Plan to Expected 1G Stat Plan

Pull Request - State: closed - Opened by TheWanderingMinstrel almost 5 years ago

#89 - Changeset UnitTest TestTpchPlanOnly

Pull Request - State: closed - Opened by TheWanderingMinstrel almost 5 years ago - 1 comment

#88 - support very large join resolver

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

#87 - don't overwrite memo during copyout phase

Issue - State: closed - Opened by zhouqingqing almost 5 years ago - 1 comment

#86 - Cleanup of unit tests to run SQL queries through class TU interface

Pull Request - State: closed - Opened by TheWanderingMinstrel almost 5 years ago

#85 - integrate external estimator like naru

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

#84 - modeling streaming and other extended relational features

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

#83 - tpcds issues

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

#83 - tpcds issues

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

#82 - Changes to qpmodel statistics that allow serialization and deserialization

Pull Request - State: closed - Opened by TheWanderingMinstrel almost 5 years ago

#81 - paralllelize unittest

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

#80 - cte optimization

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

#79 - Changeset for loading and analyzing tpcds table data. The changeset

Pull Request - State: closed - Opened by TheWanderingMinstrel almost 5 years ago

#78 - split into catalog, stats, parser, optimizer, executor components

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

#77 - DataSet features

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

#76 - Changeset contains presto statistics files in JSON format

Pull Request - State: closed - Opened by TheWanderingMinstrel almost 5 years ago

#75 - Statistics tool branch

Pull Request - State: closed - Opened by TheWanderingMinstrel almost 5 years ago - 1 comment

#74 - add index join plan

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

#73 - add a SimpleImplmentationRule

Issue - State: closed - Opened by zhouqingqing almost 5 years ago - 1 comment

#72 - accouting subquery's cost into total cost

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

#71 - improve join resolver performance

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

#70 - add other join resolvers

Issue - State: closed - Opened by zhouqingqing almost 5 years ago - 1 comment

#69 - fix deep correlation

Issue - State: closed - Opened by zhouqingqing almost 5 years ago - 1 comment

#68 - add Visit(parent, childIndex, current) pattern to simplify implmentations

Issue - State: closed - Opened by zhouqingqing almost 5 years ago - 1 comment

#67 - remove extra filters

Issue - State: closed - Opened by zhouqingqing almost 5 years ago - 1 comment

#66 - remove marker from singlejoin

Issue - State: closed - Opened by zhouqingqing almost 5 years ago - 1 comment

#65 - add experimental DataFrame APIs

Issue - State: closed - Opened by zhouqingqing almost 5 years ago - 1 comment

#64 - q05 generate worse plan with cross join enabled

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

#63 - wrap around CE with interface

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

#62 - collect jobench stats, persists and reuse to generate plan

Issue - State: closed - Opened by zhouqingqing about 5 years ago - 3 comments

#61 - clean up sqlite.g4

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

#60 - Card/Cost shall be wrapped within a generic implmentation

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

#59 - added unit test to verify queries against regressions

Pull Request - State: closed - Opened by TheWanderingMinstrel about 5 years ago

#58 - get a clear cut between optimizer and parser

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

#57 - data scanner based on stats/table defs

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

#56 - [test] load tpch/tpcds stats

Issue - State: closed - Opened by zhouqingqing about 5 years ago

#55 - porting to .net core

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

#54 - add sampling based estimation

Issue - State: open - Opened by zhouqingqing about 5 years ago - 2 comments

#53 - NLJ and HJ treat left/right different

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

#52 - setops query generate wrong plan with remove_from and use_memo

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

#51 - duplicates among ColExpr.tabref_, tabrefs_ and tabname

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

#50 - [bug] sql = "select a2*2, count(a1) from a, b, c where a1=b1 and a2=c2 group by a2 order by 1;";

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

#49 - refactor Open() code with codegen

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

#48 - enhance EXPLAIN command

Issue - State: closed - Opened by zhouqingqing about 5 years ago

#47 - q64 takes long optimization time

Issue - State: open - Opened by zhouqingqing about 5 years ago - 1 comment

#46 - stddev_samp() implmentation

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

#45 - SQL requires case insensitive names

Issue - State: closed - Opened by zhouqingqing about 5 years ago

#44 - need expr normalization procedure

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

#43 - CE off: between clause and IN-list

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

#42 - optimizer items

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

#41 - wrong estimation of small distinct values

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

#40 - separate actual rows and loops

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

#39 - [test] add join order benchmark

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

#38 - codegen support

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

#37 - parallel/distributed/federal query support

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

#36 - [test] implement sqlclient for ad-hoc and test automation

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

#35 - [bug] bug collections - bugs before triage sit here

Issue - State: open - Opened by zhouqingqing about 5 years ago - 2 comments

#34 - [Algebrizer/Rewriter] [bug] introduced alias table__# confused table alias matching

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

#33 - filter can't push through FromQuery

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

#32 - analyze stats

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

#31 - [test] prepare tpchds benchmark

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

#30 - [test] integrate CI with github

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

#29 - [test] verify tpch results with postgres

Issue - State: open - Opened by zhouqingqing about 5 years ago - 3 comments

#28 - remove colexpr from colRefedBySubq_ if all references are DeParameter()

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

#27 - limit logically right but physically retrieves more rows than wanted

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

#26 - cache value for non-correlated subquery

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

#25 - tpch issues

Issue - State: closed - Opened by zhouqingqing about 5 years ago

#24 - HAVING bugs

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

#23 - MEMO may have conflicting signature

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

#22 - Q22 mark join wrong plan after memo

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

#21 - needs null support

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

#20 - [bug] sql = "select sum(b1) from b where b3>1000;";

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

#19 - [bug] sql = "select 1+23, 1+2+a1 from a where a1+2+(15+1)>2*3.2 and 1+2=2+1.2;";

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

#18 - [bug] sql = "select c1 as c2, c3 from c join d on c1 = d1 and c2=d1;";

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

#17 - [bug] "select * from (select b1 * 2 from b) a order by 1";

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

#16 - outputName_ shall only be used in ORDER BY|GROUP BY not WHERE|HAVING

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

#15 - use a wrap class to wrap full columname <db><schema><table><col>

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

#14 - add index support

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

#13 - remove special code in PhysicScan to handle internal table

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

#12 - [bug] MEMO resolves columns wrong

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

#11 - tpcds features

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

#10 - OR expression needs process

Issue - State: closed - Opened by zhouqingqing about 5 years ago

#9 - date math not very right

Issue - State: open - Opened by zhouqingqing about 5 years ago - 5 comments

#8 - markjoin implementation shall based on regular joins

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

#7 - markjoin still have outref in filter

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

#6 - eval const eariler

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

#5 - [bug] join side dependency

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

#4 - [bug] parser: between clause

Issue - State: closed - Opened by zhouqingqing about 5 years ago - 3 comments

#3 - FromSubQuery causes troubles

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

#2 - projection/filter push down is not cost based

Issue - State: open - Opened by zhouqingqing about 5 years ago - 1 comment

#1 - sort is bogus

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

GitHub / zhouqingqing/qpmodel issues and pull requests