[jira] [Commented] (TRAFODION-3200) Docker files should show correct version
[
https://issues.apache.org/jira/browse/TRAFODION-3200?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16608088#comment-16608088
]
ASF GitHub Bot commented on TRAFODION-3200:
---
Github user svarnau commented on a diff in the pull request:
https://github.com/apache/trafodion/pull/1709#discussion_r216133725
--- Diff: tools/docker/build-base-docker.sh ---
@@ -19,7 +19,7 @@ set -e -x -u
BASE_SCRIPT_DIR=$( cd "$( dirname "${BASH_SOURCE[0]}" )" && pwd )
-export DOCKER_ENV_VERSION="0.1"
+export DOCKER_ENV_VERSION="2.3"
export BASE_IMAGE_NAME="trafodion/base:${DOCKER_ENV_VERSION}"
--- End diff --
Do you want to put this in the release2.3 branch instead of master?
> Docker files should show correct version
>
>
> Key: TRAFODION-3200
> URL: https://issues.apache.org/jira/browse/TRAFODION-3200
> Project: Apache Trafodion
> Issue Type: Improvement
>Affects Versions: 2.3
>Reporter: Pierre Smits
>Assignee: Pierre Smits
>Priority: Major
> Fix For: 2.3
>
>
> Currently files under /tools/docker show have parameters that show incorrect
> values.
> * DOCKER_ENV_VERSION
> * version
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
[jira] [Commented] (TRAFODION-3193) update reference manual about the new CQD
[ https://issues.apache.org/jira/browse/TRAFODION-3193?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16608278#comment-16608278 ] ASF GitHub Bot commented on TRAFODION-3193: --- GitHub user traflm opened a pull request: https://github.com/apache/trafodion/pull/1710 [TRAFODION-3193]update cqd reference manual about the new CQD Add a new CQD which end user will use, so update the manual You can merge this pull request into a Git repository by running: $ git pull https://github.com/traflm/trafodion TRAFODION-3193 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/trafodion/pull/1710.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #1710 commit c499dc009d8e208b4336a6541ca0b02a2263bbac Author: Liu Ming Date: 2018-09-09T02:47:24Z [TRAFODION-3193]update cqd reference manual about the new CQD > update reference manual about the new CQD > - > > Key: TRAFODION-3193 > URL: https://issues.apache.org/jira/browse/TRAFODION-3193 > Project: Apache Trafodion > Issue Type: Sub-task >Reporter: liu ming >Assignee: liu ming >Priority: Major > > TRAFODION-2952 introduce a new CQD -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Closed] (TRAFODION-2136) union all can't work efficiently
[
https://issues.apache.org/jira/browse/TRAFODION-2136?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
liu ming closed TRAFODION-2136.
---
Resolution: Duplicate
duplicated and handled by another task
> union all can't work efficiently
>
>
> Key: TRAFODION-2136
> URL: https://issues.apache.org/jira/browse/TRAFODION-2136
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-exe
>Affects Versions: any
>Reporter: Joshua Liu
>Assignee: liu ming
>Priority: Major
>
> there is one query called a
> the first time we run
> a;
> and get the elapsed time time1
> reconnect the database;
> the second time we run
> a union all a;
> and get another elapsed time.time2
> here time2 ≈ time1*2
> -
> see below for detailed info
> a is
> select count(*)
> from F_INCOME_DAY_RH a left join D_IN_SORTCODE_NEW b
> on (A.INCOMESORTCODE_N = B.CODE1)
> where (((a.BBQ >= date '2014-01-01') AND (a.BBQ <= date '2014-12-31')) AND
> ((a.BUDGETLEVEL = '3') AND
> ((a.TAXORGCODE in ('1', '2', '3', '4', '5'))) AND
> (a.DISTRICT_CO_CODE like 'A%' or
> a.DISTRICT_CO_CODE like 'B%')) AND
> ((a.INCOMESORTCODE_N LIKE 'A%') OR
> (a.INCOMESORTCODE_N LIKE 'B%') OR
> (a.INCOMESORTCODE_N LIKE 'C%') OR
> (a.INCOMESORTCODE_N LIKE 'F%') OR
> (a.INCOMESORTCODE_N LIKE 'G%')))
> group by b.CODE5
> -
> SQL>explain options 'f' s1;
>
> LC RC OP OPERATOR OPT DESCRIPTION CARD
> -
>
> 7.8root 6.00E+000
> 6.7hash_partial_groupby 6.00E+000
> 5.6esp_exchange1:16(hash2) 6.00E+000
> 4.5hash_partial_groupby 6.00E+000
> 324left_hybrid_hash_joi 1.06E+006
> ..3trafodion_scan F_INCOME_DAY_RH 1.06E+006
> 1.2esp_exchange16(rep-b):1 (m) 7.24E+002
> ..1trafodion_scan D_IN_SORTCODE_NEW 7.24E+002
> --- SQL operation complete.
> SQL>set statistics on;
> SQL>execute s1;
> (EXPR)
>
> 977626
>16080
>34817
>53722
> 5573
> --- 5 row(s) selected.
>
> Start Time 2016/07/30 09:47:50.913298
> End Time 2016/07/30 09:48:05.018125
> Elapsed Time 00:00:14.104827
> Compile Time 00:00:05.641437
> Execution Time00:00:14.104827
> ---
> reconnect database and run a union all a;
> SQL>explain options 'f' s1;
>
> LC RC OP OPERATOR OPT DESCRIPTION CARD
> -
>
> 15 .16 root 1.20E+001
> 714 15 merge_union 1.20E+001
> 13 .14 hash_partial_groupby 6.00E+000
> 12 .13 esp_exchange1:16(hash2) 6.00E+000
> 11 .12 hash_partial_groupby 6.00E+000
> 10 911 left_hybrid_hash_joi 1.06E+006
> ..10 trafodion_scan F_INCOME_DAY_RH 1.06E+006
> 8.9esp_exchange16(rep-b):1 (m) 7.24E+002
> ..8trafodion_scan D_IN_SORTCODE_NEW 7.24E+002
> 6.7hash_partial_groupby 6.00E+000
> 5.6esp_exchange1:16(hash2) 6.00E+000
> 4.5hash_partial_groupby 6.00E+000
> 324left_hybrid_hash_joi 1.06E+006
> ..3trafodion_scan F_INCOME_DAY_RH 1.06E+006
> 1.2esp_exchange16(rep-b):1 (m) 7.24E+002
> ..1trafodion_scan D_IN_SORTCODE_NEW 7.24E+002
> --- SQL operation complete.
>
> Start Time 2016/07/30 09:48:28.230061
> End Time 2016/07/30 09:48:45.506429
> Elapsed Time 00:00:17.276368
> Compile Time 00:00:17.276368
> Execution Time00:00:00.00
>
> SQL>execute s1;
> (EXPR)
>
> 977626
>16080
>34817
>53722
>
[jira] [Commented] (TRAFODION-2136) union all can't work efficiently
[
https://issues.apache.org/jira/browse/TRAFODION-2136?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16608281#comment-16608281
]
liu ming commented on TRAFODION-2136:
-
TRAFODION-3192 treat this issue. Thanks Sandhya.
> union all can't work efficiently
>
>
> Key: TRAFODION-2136
> URL: https://issues.apache.org/jira/browse/TRAFODION-2136
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-exe
>Affects Versions: any
>Reporter: Joshua Liu
>Assignee: liu ming
>Priority: Major
>
> there is one query called a
> the first time we run
> a;
> and get the elapsed time time1
> reconnect the database;
> the second time we run
> a union all a;
> and get another elapsed time.time2
> here time2 ≈ time1*2
> -
> see below for detailed info
> a is
> select count(*)
> from F_INCOME_DAY_RH a left join D_IN_SORTCODE_NEW b
> on (A.INCOMESORTCODE_N = B.CODE1)
> where (((a.BBQ >= date '2014-01-01') AND (a.BBQ <= date '2014-12-31')) AND
> ((a.BUDGETLEVEL = '3') AND
> ((a.TAXORGCODE in ('1', '2', '3', '4', '5'))) AND
> (a.DISTRICT_CO_CODE like 'A%' or
> a.DISTRICT_CO_CODE like 'B%')) AND
> ((a.INCOMESORTCODE_N LIKE 'A%') OR
> (a.INCOMESORTCODE_N LIKE 'B%') OR
> (a.INCOMESORTCODE_N LIKE 'C%') OR
> (a.INCOMESORTCODE_N LIKE 'F%') OR
> (a.INCOMESORTCODE_N LIKE 'G%')))
> group by b.CODE5
> -
> SQL>explain options 'f' s1;
>
> LC RC OP OPERATOR OPT DESCRIPTION CARD
> -
>
> 7.8root 6.00E+000
> 6.7hash_partial_groupby 6.00E+000
> 5.6esp_exchange1:16(hash2) 6.00E+000
> 4.5hash_partial_groupby 6.00E+000
> 324left_hybrid_hash_joi 1.06E+006
> ..3trafodion_scan F_INCOME_DAY_RH 1.06E+006
> 1.2esp_exchange16(rep-b):1 (m) 7.24E+002
> ..1trafodion_scan D_IN_SORTCODE_NEW 7.24E+002
> --- SQL operation complete.
> SQL>set statistics on;
> SQL>execute s1;
> (EXPR)
>
> 977626
>16080
>34817
>53722
> 5573
> --- 5 row(s) selected.
>
> Start Time 2016/07/30 09:47:50.913298
> End Time 2016/07/30 09:48:05.018125
> Elapsed Time 00:00:14.104827
> Compile Time 00:00:05.641437
> Execution Time00:00:14.104827
> ---
> reconnect database and run a union all a;
> SQL>explain options 'f' s1;
>
> LC RC OP OPERATOR OPT DESCRIPTION CARD
> -
>
> 15 .16 root 1.20E+001
> 714 15 merge_union 1.20E+001
> 13 .14 hash_partial_groupby 6.00E+000
> 12 .13 esp_exchange1:16(hash2) 6.00E+000
> 11 .12 hash_partial_groupby 6.00E+000
> 10 911 left_hybrid_hash_joi 1.06E+006
> ..10 trafodion_scan F_INCOME_DAY_RH 1.06E+006
> 8.9esp_exchange16(rep-b):1 (m) 7.24E+002
> ..8trafodion_scan D_IN_SORTCODE_NEW 7.24E+002
> 6.7hash_partial_groupby 6.00E+000
> 5.6esp_exchange1:16(hash2) 6.00E+000
> 4.5hash_partial_groupby 6.00E+000
> 324left_hybrid_hash_joi 1.06E+006
> ..3trafodion_scan F_INCOME_DAY_RH 1.06E+006
> 1.2esp_exchange16(rep-b):1 (m) 7.24E+002
> ..1trafodion_scan D_IN_SORTCODE_NEW 7.24E+002
> --- SQL operation complete.
>
> Start Time 2016/07/30 09:48:28.230061
> End Time 2016/07/30 09:48:45.506429
> Elapsed Time 00:00:17.276368
> Compile Time 00:00:17.276368
> Execution Time00:00:00.00
>
> SQL>execute s1;
> (EXPR)
>
> 977626
>16080
>34817
>
[jira] [Commented] (TRAFODION-3200) Docker files should show correct version
[ https://issues.apache.org/jira/browse/TRAFODION-3200?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16607969#comment-16607969 ] ASF GitHub Bot commented on TRAFODION-3200: --- GitHub user PierreSmits opened a pull request: https://github.com/apache/trafodion/pull/1709 [TRAFODION-3200] correct label and version You can merge this pull request into a Git repository by running: $ git pull https://github.com/PierreSmits/trafodion master Alternatively you can review and apply these changes as the patch at: https://github.com/apache/trafodion/pull/1709.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #1709 commit 1b58771d75bcf267574d6588877c8672d64a44d8 Author: Pierre Smits Date: 2018-09-08T09:09:28Z [TRAFODION-3200] correct label and version > Docker files should show correct version > > > Key: TRAFODION-3200 > URL: https://issues.apache.org/jira/browse/TRAFODION-3200 > Project: Apache Trafodion > Issue Type: Improvement >Affects Versions: 2.3 >Reporter: Pierre Smits >Assignee: Pierre Smits >Priority: Major > Fix For: 2.3 > > > Currently files under /tools/docker show have parameters that show incorrect > values. > * DOCKER_ENV_VERSION > * version -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (TRAFODION-3200) Docker files should show correct version
Pierre Smits created TRAFODION-3200: --- Summary: Docker files should show correct version Key: TRAFODION-3200 URL: https://issues.apache.org/jira/browse/TRAFODION-3200 Project: Apache Trafodion Issue Type: Improvement Affects Versions: 2.3 Reporter: Pierre Smits Assignee: Pierre Smits Fix For: 2.3 Currently files under /tools/docker show have parameters that show incorrect values. * DOCKER_ENV_VERSION * version -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Work started] (TRAFODION-3200) Docker files should show correct version
[ https://issues.apache.org/jira/browse/TRAFODION-3200?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-3200 started by Pierre Smits. --- > Docker files should show correct version > > > Key: TRAFODION-3200 > URL: https://issues.apache.org/jira/browse/TRAFODION-3200 > Project: Apache Trafodion > Issue Type: Improvement >Affects Versions: 2.3 >Reporter: Pierre Smits >Assignee: Pierre Smits >Priority: Major > Fix For: 2.3 > > > Currently files under /tools/docker show have parameters that show incorrect > values. > * DOCKER_ENV_VERSION > * version -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Work stopped] (TRAFODION-3200) Docker files should show correct version
[ https://issues.apache.org/jira/browse/TRAFODION-3200?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-3200 stopped by Pierre Smits. --- > Docker files should show correct version > > > Key: TRAFODION-3200 > URL: https://issues.apache.org/jira/browse/TRAFODION-3200 > Project: Apache Trafodion > Issue Type: Improvement >Affects Versions: 2.3 >Reporter: Pierre Smits >Assignee: Pierre Smits >Priority: Major > Fix For: 2.3 > > > Currently files under /tools/docker show have parameters that show incorrect > values. > * DOCKER_ENV_VERSION > * version -- This message was sent by Atlassian JIRA (v7.6.3#76005)
