[GitHub] [incubator-doris] Astralidea commented on issue #4402: doris是否支持表结构导出

2020-08-21 Thread GitBox
Astralidea commented on issue #4402: URL: https://github.com/apache/incubator-doris/issues/4402#issuecomment-678594853 @lambgong 我简单写了个脚本,可以导出一个表的所有建表语句。 https://github.com/Astralidea/doris-tool 脚本也有问题我也可以改改。 This is an

[GitHub] [incubator-doris] chaoyli commented on issue #4426: Wrong answer of boolean type

2020-08-21 Thread GitBox
chaoyli commented on issue #4426: URL: https://github.com/apache/incubator-doris/issues/4426#issuecomment-678583028 ``` INSERT INTO t1 VALUES (true), (false); ``` ``` select c0 from t1 where c0 = 0; +--+ | c0 | +--+ |0 | +--+ ``` ---

[GitHub] [incubator-doris] chaoyli edited a comment on issue #4426: Wrong answer of boolean type

2020-08-21 Thread GitBox
chaoyli edited a comment on issue #4426: URL: https://github.com/apache/incubator-doris/issues/4426#issuecomment-678583028 ``` INSERT INTO t1 VALUES (true), (false); ``` ``` select c0 from t1 where c0 = 0; +--+ | c0 | +--+ |0 | +--+ ```

[GitHub] [incubator-doris] chaoyli commented on issue #4426: Wrong answer of boolean type

2020-08-21 Thread GitBox
chaoyli commented on issue #4426: URL: https://github.com/apache/incubator-doris/issues/4426#issuecomment-678583069 You should set buckets > 2 to reproduce the bug. This is an automated message from the Apache Git Service. T

[GitHub] [incubator-doris] chaoyli opened a new issue #4426: Wrong answer of boolean type

2020-08-21 Thread GitBox
chaoyli opened a new issue #4426: URL: https://github.com/apache/incubator-doris/issues/4426 ``` CREATE TABLE t1 (c0 BOOLEAN NOT NULL ) AGGREGATE KEY (c0) DISTRIBUTED BY HASH (c0) buckets 3 properties("replication_num"="1") ; ``` --

[GitHub] [incubator-doris] ZhangYu0123 opened a new pull request #4425: Support batch delete[part 2]

2020-08-21 Thread GitBox
ZhangYu0123 opened a new pull request #4425: URL: https://github.com/apache/incubator-doris/pull/4425 ## Proposed changes - In base compaction, merge and delete deleted rows #4051. ## Types of changes What types of changes does your code introduce to Doris? _Put an `

[GitHub] [incubator-doris] yangzhg closed issue #4398: Make some readFields method Deprecated

2020-08-21 Thread GitBox
yangzhg closed issue #4398: URL: https://github.com/apache/incubator-doris/issues/4398 This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go

[incubator-doris] branch master updated: make some readFields Deprecated (#4399)

2020-08-21 Thread yangzhg
This is an automated email from the ASF dual-hosted git repository. yangzhg pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/incubator-doris.git The following commit(s) were added to refs/heads/master by this push: new af2b749 make some readFields Deprecat

[GitHub] [incubator-doris] yangzhg merged pull request #4399: Make some readFields methods Deprecated

2020-08-21 Thread GitBox
yangzhg merged pull request #4399: URL: https://github.com/apache/incubator-doris/pull/4399 This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above t

[GitHub] [incubator-doris] morningman merged pull request #4310: Support batch delete [part 1]

2020-08-21 Thread GitBox
morningman merged pull request #4310: URL: https://github.com/apache/incubator-doris/pull/4310 This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL abov

[GitHub] [incubator-doris] kangkaisen commented on a change in pull request #4330: [Feature][Cache] Sql cache and partition cache #2581

2020-08-21 Thread GitBox
kangkaisen commented on a change in pull request #4330: URL: https://github.com/apache/incubator-doris/pull/4330#discussion_r474720148 ## File path: fe/fe-core/src/main/java/org/apache/doris/qe/cache/PartitionCache.java ## @@ -0,0 +1,215 @@ +// Licensed to the Apache Software

[GitHub] [incubator-doris] morningman merged pull request #4389: [ODBC SCAN NODE] 2/4 Add Thrift Interface and Meta of ODBC_Scan_Node

2020-08-21 Thread GitBox
morningman merged pull request #4389: URL: https://github.com/apache/incubator-doris/pull/4389 This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL abov

[incubator-doris] branch master updated: [ODBC SCAN NODE] 2/4 Add Thrift Interface of odbc_scan_node (#4389)

2020-08-21 Thread morningman
This is an automated email from the ASF dual-hosted git repository. morningman pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/incubator-doris.git The following commit(s) were added to refs/heads/master by this push: new 984006a [ODBC SCAN NODE] 2/4 Add T

[incubator-doris] branch master updated (5976395 -> a8fe54b)

2020-08-21 Thread morningman
This is an automated email from the ASF dual-hosted git repository. morningman pushed a change to branch master in repository https://gitbox.apache.org/repos/asf/incubator-doris.git. from 5976395 [BUG] Remove the deduplication of LEFT SEMI/ANTI JOIN with not equal predicate (#4417) ad

[GitHub] [incubator-doris] morningman merged pull request #4377: [ODBC SCAN NODE] 1/4 Add unix odbc library.

2020-08-21 Thread GitBox
morningman merged pull request #4377: URL: https://github.com/apache/incubator-doris/pull/4377 This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL abov

[GitHub] [incubator-doris] chaoyli closed issue #4418: LEFT SEMI/ANTI JOIN wrong answer

2020-08-21 Thread GitBox
chaoyli closed issue #4418: URL: https://github.com/apache/incubator-doris/issues/4418 This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go

[incubator-doris] branch master updated: [BUG] Remove the deduplication of LEFT SEMI/ANTI JOIN with not equal predicate (#4417)

2020-08-21 Thread lichaoyong
This is an automated email from the ASF dual-hosted git repository. lichaoyong pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/incubator-doris.git The following commit(s) were added to refs/heads/master by this push: new 5976395 [BUG] Remove the deduplica

[GitHub] [incubator-doris] chaoyli merged pull request #4417: [BUG] Remove the deduplication of LEFT SEMI/ANTI JOIN with not equal …

2020-08-21 Thread GitBox
chaoyli merged pull request #4417: URL: https://github.com/apache/incubator-doris/pull/4417 This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above t

[GitHub] [incubator-doris] kangkaisen commented on a change in pull request #4424: Fix explicit broadcast join bug

2020-08-21 Thread GitBox
kangkaisen commented on a change in pull request #4424: URL: https://github.com/apache/incubator-doris/pull/4424#discussion_r474634686 ## File path: fe/fe-core/src/main/java/org/apache/doris/planner/DistributedPlanner.java ## @@ -361,13 +361,17 @@ private PlanFragment createHa

[GitHub] [incubator-doris] kangkaisen commented on a change in pull request #4424: Fix explicit broadcast join bug

2020-08-21 Thread GitBox
kangkaisen commented on a change in pull request #4424: URL: https://github.com/apache/incubator-doris/pull/4424#discussion_r474634489 ## File path: fe/fe-core/src/main/java/org/apache/doris/planner/DistributedPlanner.java ## @@ -361,13 +361,17 @@ private PlanFragment createHa

[GitHub] [incubator-doris] wyb opened a new pull request #4424: Fix explicit broadcast join bug

2020-08-21 Thread GitBox
wyb opened a new pull request #4424: URL: https://github.com/apache/incubator-doris/pull/4424 Use broadcast join when users specify explicitly `[BROADCAST]` in queries. This is an automated message from the Apache Git Service

[GitHub] [incubator-doris] ZhangYu0123 opened a new pull request #4423: Update config action check

2020-08-21 Thread GitBox
ZhangYu0123 opened a new pull request #4423: URL: https://github.com/apache/incubator-doris/pull/4423 ## Proposed changes Increase the config verification function in the config update interface. Detail: #4422 ## Types of changes What types of changes does your code intro

[GitHub] [incubator-doris] ZhangYu0123 opened a new issue #4422: Increase the config verification function in the config update interface

2020-08-21 Thread GitBox
ZhangYu0123 opened a new issue #4422: URL: https://github.com/apache/incubator-doris/issues/4422 **Is your feature request related to a problem? Please describe.** In the config update interface, the current implementation in be can not check config when it has been updated. **Des

[GitHub] [incubator-doris] ZhangYu0123 closed issue #4258: [BUG][Compaction] Calc cumulative point error when be restarts and there is delete rowset

2020-08-21 Thread GitBox
ZhangYu0123 closed issue #4258: URL: https://github.com/apache/incubator-doris/issues/4258 This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to

[GitHub] [incubator-doris] HappenLee opened a new pull request #4421: [MemTracker][Bug-Fix] Fix core in DECHECK in memory tracker

2020-08-21 Thread GitBox
HappenLee opened a new pull request #4421: URL: https://github.com/apache/incubator-doris/pull/4421 Fix DECHECK failed in mem_tracker and add some log when DECHECK failed issue #4420 ## Proposed changes Describe the big picture of your changes here to communicate to the mai

[GitHub] [incubator-doris] HappenLee opened a new issue #4420: [Bug] CORE in debug mode Memtracker DECHECK, when use sort node

2020-08-21 Thread GitBox
HappenLee opened a new issue #4420: URL: https://github.com/apache/incubator-doris/issues/4420 **Describe the bug** when we use sort node in DEBUG mode which will lead to core of BE. ![image](https://user-images.githubusercontent.com/10553413/90871169-3a0db880-e3cd-11ea-8db8-41c7202e4

[GitHub] [incubator-doris] db18Zhang opened a new issue #4419: hope to add database of information_schema

2020-08-21 Thread GitBox
db18Zhang opened a new issue #4419: URL: https://github.com/apache/incubator-doris/issues/4419 Because database of information_schema is missing a lot,hope to add detailed information; This is an automated message from the A

[GitHub] [incubator-doris] chaoyli edited a comment on issue #4418: LEFT SEMI/ANTI JOIN wrong answer

2020-08-21 Thread GitBox
chaoyli edited a comment on issue #4418: URL: https://github.com/apache/incubator-doris/issues/4418#issuecomment-678099783 ``` -- query 94 select count(distinct ws_order_number) as "order count" ,sum(ws_ext_ship_cost) as "total shipping cost" ,sum(ws_net_profit) as "to

[GitHub] [incubator-doris] chaoyli edited a comment on issue #4418: LEFT SEMI/ANTI JOIN wrong answer

2020-08-21 Thread GitBox
chaoyli edited a comment on issue #4418: URL: https://github.com/apache/incubator-doris/issues/4418#issuecomment-678099783 The right answer of query94 is ``` +-+-+--+ | order count | total shipping cost | total net profit | +-

[GitHub] [incubator-doris] chaoyli edited a comment on issue #4418: LEFT SEMI/ANTI JOIN wrong answer

2020-08-21 Thread GitBox
chaoyli edited a comment on issue #4418: URL: https://github.com/apache/incubator-doris/issues/4418#issuecomment-678099699 ``` -- query 16 select count(distinct cs_order_number) as "order count" ,sum(cs_ext_ship_cost) as "total shipping cost" ,sum(cs_net_profit) as "to

[GitHub] [incubator-doris] chaoyli edited a comment on issue #4418: LEFT SEMI/ANTI JOIN wrong answer

2020-08-21 Thread GitBox
chaoyli edited a comment on issue #4418: URL: https://github.com/apache/incubator-doris/issues/4418#issuecomment-678099783 -- query 94 ``` select count(distinct ws_order_number) as "order count" ,sum(ws_ext_ship_cost) as "total shipping cost" ,sum(ws_net_profit) as "to

[GitHub] [incubator-doris] chaoyli edited a comment on issue #4418: LEFT SEMI/ANTI JOIN wrong answer

2020-08-21 Thread GitBox
chaoyli edited a comment on issue #4418: URL: https://github.com/apache/incubator-doris/issues/4418#issuecomment-678099699 The right answer of query16 is ``` +-+-+--+ | order count | total shipping cost | total net profit | +--

[GitHub] [incubator-doris] chaoyli commented on issue #4418: LEFT SEMI/ANTI JOIN wrong answer

2020-08-21 Thread GitBox
chaoyli commented on issue #4418: URL: https://github.com/apache/incubator-doris/issues/4418#issuecomment-678099783 ``` order count total shipping cost total net profit --- --- 3364554.35 -3979.35 ``` -

[GitHub] [incubator-doris] chaoyli commented on issue #4418: LEFT SEMI/ANTI JOIN wrong answer

2020-08-21 Thread GitBox
chaoyli commented on issue #4418: URL: https://github.com/apache/incubator-doris/issues/4418#issuecomment-678099699 The right answer of query16 is ``` order count total shipping cost total net profit --- --- 236 1062963.89

[GitHub] [incubator-doris] chaoyli opened a new issue #4418: LEFT SEMI/ANTI JOIN wrong answer

2020-08-21 Thread GitBox
chaoyli opened a new issue #4418: URL: https://github.com/apache/incubator-doris/issues/4418 TPCDS qualification query16 and query94 use LEFT SEMI/ANTI JOIN, but the answer is wrong. This is an automated message from the Apa

[GitHub] [incubator-doris] chaoyli opened a new pull request #4417: [BUG] Remove the deduplication of LEFT SEMI/ANTI JOIN with not equal …

2020-08-21 Thread GitBox
chaoyli opened a new pull request #4417: URL: https://github.com/apache/incubator-doris/pull/4417 …predicate ``` SELECT * FROM (SELECT cs_order_number, cs_warehouse_sk FROM catalog_sales WHERE cs_order_number = 125005 AND cs_warehouse_sk = 4