[jira] [Commented] (TRAFODION-1677) Implement the ROLLUP and CUBE SQL functions in Trafodion
[ https://issues.apache.org/jira/browse/TRAFODION-1677?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15042157#comment-15042157 ] Qifan Chen commented on TRAFODION-1677: --- I checked the work method for hash group by. Looks like it is very specific to a single aggregate expression and would be extra work to alter it for multiple aggregates. So to handle multiple aggregate expressions with the hash group by operator without much code change, we could use threads, each works on one aggregate expression, replying on the existing method. This would be another requirement to support threads in yet another operator. > Implement the ROLLUP and CUBE SQL functions in Trafodion > > > Key: TRAFODION-1677 > URL: https://issues.apache.org/jira/browse/TRAFODION-1677 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-general >Reporter: Qifan Chen > > I am currently working the high level design for 2nd part of the OLAP > function RollUp and Cube. The 1st part (the identification of missing OLAP > window functions in Trafodion and their implementation) is done. > For RollUp and Cube, I believe the key is to handle many more # of > aggregates properly. Note that that number is n for RollUp and 2^n for Cube, > where n is the # of grouping columns. Parallel computation of these > aggregates is the key. > One way to achieve such is to extend the Hash Group By operators so that it > can do multiple aggregates in a single operator. The requires the following: > 1. random partition the data fed into the aggregate operator > 2. force the multiple-level group by > 3. pack multiple pairs of groupping and aggregate expressions (both in > compiler and in executor, and in MapValueIds, GroupByPartialRoot, and > GroupByPartialLeaf). -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (TRAFODION-1642) Release 1.3.0 copyrights and license files are incorrect
[ https://issues.apache.org/jira/browse/TRAFODION-1642?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15042035#comment-15042035 ] ASF GitHub Bot commented on TRAFODION-1642: --- Github user robertamarton closed the pull request at: https://github.com/apache/incubator-trafodion/pull/208 > Release 1.3.0 copyrights and license files are incorrect > > > Key: TRAFODION-1642 > URL: https://issues.apache.org/jira/browse/TRAFODION-1642 > Project: Apache Trafodion > Issue Type: Bug > Components: Build Infrastructure >Reporter: Roberta Marton >Assignee: Roberta Marton > > Apache has very definitive rules about release products which make sure > copyrights, notice, and license files are correct. There are several issues > today that need to be addressed: > - Missing license information in the LICENSE file > - Incorrect information in the LICENSE file > - Multiple copyrights in source files > - Existing Hewlett Packard and Compaq copyrights that should be removed > - Image files missing copyrights -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (TRAFODION-1642) Release 1.3.0 copyrights and license files are incorrect
[ https://issues.apache.org/jira/browse/TRAFODION-1642?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15042034#comment-15042034 ] ASF GitHub Bot commented on TRAFODION-1642: --- GitHub user robertamarton opened a pull request: https://github.com/apache/incubator-trafodion/pull/209 License [TRAFODION-1642] Release 1.3.0 copyrights and license files are incorrect, part 2 You can merge this pull request into a Git repository by running: $ git pull https://github.com/robertamarton/incubator-trafodion license Alternatively you can review and apply these changes as the patch at: https://github.com/apache/incubator-trafodion/pull/209.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 #209 commit d44f32e7a13cd5a916bdef04a0d0e15448e81d1b Author: Roberta Marton Date: 2015-12-04T18:34:11Z TRAFODION-1642: Release 1.3.0 copyrights and license files are incorrect Part 2 of copyright and licensing changes Removed double copyrights in files Updated LICENSE, README, RAT_README to reflect latest changes Added licenses directory to include license text Added .gitattributes to exclude files from the source tar file Changed Hewlett Packard copyright to Apache copyrights in win-odbc commit 30bd43f424ff23ac16329d089522fd38964017ee Author: Roberta Marton Date: 2015-12-04T18:55:11Z Minor update to .rat-excludes file > Release 1.3.0 copyrights and license files are incorrect > > > Key: TRAFODION-1642 > URL: https://issues.apache.org/jira/browse/TRAFODION-1642 > Project: Apache Trafodion > Issue Type: Bug > Components: Build Infrastructure >Reporter: Roberta Marton >Assignee: Roberta Marton > > Apache has very definitive rules about release products which make sure > copyrights, notice, and license files are correct. There are several issues > today that need to be addressed: > - Missing license information in the LICENSE file > - Incorrect information in the LICENSE file > - Multiple copyrights in source files > - Existing Hewlett Packard and Compaq copyrights that should be removed > - Image files missing copyrights -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (TRAFODION-1642) Release 1.3.0 copyrights and license files are incorrect
[ https://issues.apache.org/jira/browse/TRAFODION-1642?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15042002#comment-15042002 ] ASF GitHub Bot commented on TRAFODION-1642: --- GitHub user robertamarton opened a pull request: https://github.com/apache/incubator-trafodion/pull/208 Release1.3 [TRAFODION-1642] Release 1.3.0 copyrights and license files are incorrect You can merge this pull request into a Git repository by running: $ git pull https://github.com/apache/incubator-trafodion release1.3 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/incubator-trafodion/pull/208.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 #208 commit 851f2a5d8aa72114be94727d19e6021af0609b02 Author: Roberta Marton Date: 2015-11-13T00:16:46Z Fix for TRAFODION-1623 commit 1ea3e834b6738617164d2a6ed8b090b3ab497946 Author: Roberta Marton Date: 2015-11-13T16:46:58Z Merge [TRAFODION-1623] PR 171 Installation fails commit 7a085965c36363a3a44f5e85d8cfc5a46280f45f Author: Roberta Marton Date: 2015-11-23T22:59:00Z TRAFODION-1636 & TRAFODION-1642 TRAFODION-1636: wms and dcs directories contain NOTICE and LICENSE FILES TRAFODION-1642: Release 1.3.0 copyrights and license files are incorrect Fixed up copyrights Removed Apache copyrights (should only have one copyright in file) core/sql/common/swscanf.cpp core/sql/common/sqsprintf.cpp core/sql/parser/ulexer.h Removed copyright - deemed to be our code and can safely remove core/conn/jdbc_type4/src/org/trafodion/jdbc/t4/T4DatabaseMetaData.java core/sql/regress/newregr/card/runregr_card.ksh dcs/src/main/java/org/trafodion/dcs/util/ByteBufferUtils.java dcs/src/main/java/org/trafodion/dcs/util/SqlUtils.java Replaced Hewlett Packard copyright with Apache copyright core/sql/regress/seabase/EXPECTED021 core/sql/regress/udr/EXPECTED100.SB docs/client_install/source/Trafodion_Client_Installation_Guide.xml docs/client_install/source/xml-profile.xml docs/command_interface/source/Trafodion_Command_Interface_Guide.xml docs/command_interface/source/xml-profile.xml docs/odb_manual/Trafodion_odb_User_Guide.xml docs/sql_reference/source/Trafodion_SQL_Reference_Manual.xml docs/sql_reference/source/xml-profile.xml wms/build.xml Removed code/files that are not being used that contain invalid copyrights core/sqf/export/lib/Vili/Functions.pm core/sqf/export/lib/Vili/Helper.pm core/sqf/export/lib/Vili/NoDriftTimer.pm core/sql/common/from_GB2312.c core/sql/regress/newregr/mvs/BIG/expectedmv215_RU core/sql/regress/newregr/mvs/EXPECTEDMV500 core/sql/regress/newregr/mvs/EXPECTEDMV500A core/sql/regress/newregr/mvs/EXPECTEDMV500A_LINUX core/sql/regress/newregr/mvs/TPCD/DBGEN_HELP.TXT dcs/src/main/resources/dcs-webapps/master/css/stylesheet.css Removed filters for Hewlett Packard, Tandem, Compaq, and Microsoft. None of test software should returns these values core/sql/regress/tools/regress-filter core/sql/regress-tools/regress-filter-linux Removed LICENSE and NOTICE files from child directories dcs/LICENSE.txt dcs/NOTICE.txt wms/LICENSE.txt wms/NOTICE.txt install/README.rst Reworded comment so Copright would not show up on search core/sql/update/CopyrightCheck.py commit 26031c8a51514ccee3fae58cb644420434f1f416 Author: Roberta Marton Date: 2015-11-24T01:43:47Z updated .rat-excludes and RAT_README.txt to include copyright changes commit f66141834f102e9af39cf9baf3bc3f9c27118133 Author: Roberta Marton Date: 2015-12-01T17:55:29Z Copied pull request 187 to release1.3 branch commit 3b27862e0886625ff1e61b97125cc57d50ca7256 Author: Roberta Marton Date: 2015-12-02T00:18:25Z Merge [TRAFODION-1636] and [TRAFODION-1642] PR-185 Copyrights, License, and Notice file updates > Release 1.3.0 copyrights and license files are incorrect > > > Key: TRAFODION-1642 > URL: https://issues.apache.org/jira/browse/TRAFODION-1642 > Project: Apache Trafodion > Issue Type: Bug > Components: Build Infrastructure >Reporter: Roberta Marton >Assignee: Roberta Marton > > Apache has very definitive rules about release products which make sure > copyrights, notice, and license files are correct. There are several issues > today that need to be addressed: > - Missing license information in the LICENSE file > - Incorrect information in the LICENSE file > - Multiple copyrights in source files >
[jira] [Commented] (TRAFODION-1648) Synchronization issues in TrxRegion* coprocessor code for Region split/balance
[ https://issues.apache.org/jira/browse/TRAFODION-1648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15041903#comment-15041903 ] Trina Krug commented on TRAFODION-1648: --- Will fix/change the following 2 things for this JIRA: 1) Disable all non phase 2 transactional operations earlier in the split/rebalance process. There will be a tiered approach for disabling requests with the goal to minimize transaction outage and to allow the region operation to go as quickly as possible. This piece will address : -- synchronization issues -- the potential of prolonging a split/rebalance indefinitely -- missing a transaction changing state due to timing windows 2) Fix data synchronization issues for the active transaction list, commit pending list and scanners list at split/rebalance time (should be solved by the above, but for completeness sake it will be addressed) > Synchronization issues in TrxRegion* coprocessor code for Region > split/balance > --- > > Key: TRAFODION-1648 > URL: https://issues.apache.org/jira/browse/TRAFODION-1648 > Project: Apache Trafodion > Issue Type: Bug > Components: dtm >Reporter: Trina Krug >Assignee: Trina Krug > > --New transactions become disabled in preClose/preSplit, but other requests > such as commitRequest are allowed to get through after this point. This > poses an issue when gathering/writing transaction state at flush time. A > slight design modification is required. > --In addition, detailed review and possible modification of shared lists > should be done in this region split/balance area, including those affected > above. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (TRAFODION-1668) Cannot upload customer SPJ JARs
[ https://issues.apache.org/jira/browse/TRAFODION-1668?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15041818#comment-15041818 ] ASF GitHub Bot commented on TRAFODION-1668: --- Github user robertamarton commented on a diff in the pull request: https://github.com/apache/incubator-trafodion/pull/203#discussion_r46708044 --- Diff: core/conn/spj_init/src/main/resources/init_spj.sql --- @@ -0,0 +1,156 @@ +#!/bin/bash +# @@@ START COPYRIGHT @@@ +# +# Licensed to the Apache Software Foundation (ASF) under one +# or more contributor license agreements. See the NOTICE file +# distributed with this work for additional information +# regarding copyright ownership. The ASF licenses this file +# to you under the Apache License, Version 2.0 (the +# "License"); you may not use this file except in compliance +# with the License. You may obtain a copy of the License at +# +# http://www.apache.org/licenses/LICENSE-2.0 +# +# Unless required by applicable law or agreed to in writing, +# software distributed under the License is distributed on an +# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY +# KIND, either express or implied. See the License for the +# specific language governing permissions and limitations +# under the License. +# +# @@@ END COPYRIGHT @@@ + +SERVER_JAR=${MY_SQROOT}/export/lib/spj_init.jar +CI_SERVER_LOG=${MY_SQROOT}/ciserver/cislog +SQLCI=${MY_SQROOT}/export/bin32/sqlci +CP=/bin/cp +MANAGEABILITY_CATALOG=TRAFODION +CIS_SCHEMA=DEFAULT_SPJ + + +function dropAndCreateSchema { +echo "Creating Schema for CI Server Component" +sqlci << sqlciEOF + + cqd CAT_IGNORE_ALREADY_EXISTS_ERROR 'on'; + cqd CAT_IGNORE_DOES_NOT_EXIST_ERROR 'on'; + + DROP SCHEMA $MANAGEABILITY_CATALOG.$CIS_SCHEMA CASCADE; + CREATE SCHEMA $MANAGEABILITY_CATALOG.$CIS_SCHEMA; + --- End diff -- This relates to the role comment Hans made below. We could create a role and change the AUTHORIZATION clause to be the role. But this is only valid when authorization is enabled. So you need logic to handle to set the correct authorization clause and code is needed when authorization is enabled and disable to change the schema owner. I would, for simplicity, make DB__ROOT or DB__ROOTROLE the owner and require the user to set privileges to whatever role or user they want to manage privileges. > Cannot upload customer SPJ JARs > --- > > Key: TRAFODION-1668 > URL: https://issues.apache.org/jira/browse/TRAFODION-1668 > Project: Apache Trafodion > Issue Type: Improvement >Reporter: Kevin Xu >Assignee: Kevin Xu > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (TRAFODION-1668) Cannot upload customer SPJ JARs
[ https://issues.apache.org/jira/browse/TRAFODION-1668?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15041808#comment-15041808 ] ASF GitHub Bot commented on TRAFODION-1668: --- Github user robertamarton commented on a diff in the pull request: https://github.com/apache/incubator-trafodion/pull/203#discussion_r46707640 --- Diff: core/conn/spj_init/src/main/resources/init_spj.sql --- @@ -0,0 +1,156 @@ +#!/bin/bash +# @@@ START COPYRIGHT @@@ +# +# Licensed to the Apache Software Foundation (ASF) under one +# or more contributor license agreements. See the NOTICE file +# distributed with this work for additional information +# regarding copyright ownership. The ASF licenses this file +# to you under the Apache License, Version 2.0 (the +# "License"); you may not use this file except in compliance +# with the License. You may obtain a copy of the License at +# +# http://www.apache.org/licenses/LICENSE-2.0 +# +# Unless required by applicable law or agreed to in writing, +# software distributed under the License is distributed on an +# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY +# KIND, either express or implied. See the License for the +# specific language governing permissions and limitations +# under the License. +# +# @@@ END COPYRIGHT @@@ + +SERVER_JAR=${MY_SQROOT}/export/lib/spj_init.jar +CI_SERVER_LOG=${MY_SQROOT}/ciserver/cislog +SQLCI=${MY_SQROOT}/export/bin32/sqlci +CP=/bin/cp +MANAGEABILITY_CATALOG=TRAFODION +CIS_SCHEMA=DEFAULT_SPJ + + +function dropAndCreateSchema { +echo "Creating Schema for CI Server Component" +sqlci << sqlciEOF + + cqd CAT_IGNORE_ALREADY_EXISTS_ERROR 'on'; + cqd CAT_IGNORE_DOES_NOT_EXIST_ERROR 'on'; + + DROP SCHEMA $MANAGEABILITY_CATALOG.$CIS_SCHEMA CASCADE; + CREATE SCHEMA $MANAGEABILITY_CATALOG.$CIS_SCHEMA; + + cqd CAT_IGNORE_ALREADY_EXISTS_ERROR 'off'; + cqd CAT_IGNORE_DOES_NOT_EXIST_ERROR 'off'; + + exit; +sqlciEOF +} + +function createProcedures { + +echo "Creating Procedures in schema '$MANAGEABILITY_CATALOG.$CIS_SCHEMA' " +sqlci << procEOF + + cqd CAT_IGNORE_ALREADY_EXISTS_ERROR 'on'; + cqd CAT_IGNORE_DOES_NOT_EXIST_ERROR 'on'; + + -- Creating Procedures + set schema $MANAGEABILITY_CATALOG.$CIS_SCHEMA; + + DROP LIBRARY SPJMGMT CASCADE; + CREATE LIBRARY SPJMGMT FILE '${SERVER_JAR}'; + + CREATE PROCEDURE HELP ( + INOUT COMMANDNAME VARCHAR(2560) CHARACTER SET ISO88591) + EXTERNAL NAME 'com.traf.mgmt.JarFileMgmt.help (java.lang.String[])' + EXTERNAL SECURITY DEFINER + LIBRARY SPJMGMT + LANGUAGE JAVA + PARAMETER STYLE JAVA + READS SQL DATA + ; + GRANT EXECUTE ON PROCEDURE HELP TO PUBLIC; + + CREATE PROCEDURE PUT ( + IN FILEDATA VARCHAR(102400) CHARACTER SET ISO88591, + IN FILENAME VARCHAR(256) CHARACTER SET ISO88591, + IN CREATEFLAG INTEGER) + EXTERNAL NAME 'com.traf.mgmt.JarFileMgmt.put(java.lang.String,java.lang.String,int)' + EXTERNAL SECURITY DEFINER + LIBRARY SPJMGMT + LANGUAGE JAVA + PARAMETER STYLE JAVA + READS SQL DATA + ; + GRANT EXECUTE ON PROCEDURE PUT TO PUBLIC; + + CREATE PROCEDURE LS ( + IN FILENAME VARCHAR(256) CHARACTER SET ISO88591, + OUT FILENAMES VARCHAR(10240) CHARACTER SET ISO88591) + EXTERNAL NAME 'com.traf.mgmt.JarFileMgmt.ls(java.lang.String,java.lang.String[])' + EXTERNAL SECURITY DEFINER + LIBRARY SPJMGMT + LANGUAGE JAVA + PARAMETER STYLE JAVA + READS SQL DATA + ; + GRANT EXECUTE ON PROCEDURE LS TO PUBLIC; + + CREATE PROCEDURE LSALL ( + OUT FILENAMES VARCHAR(10240) CHARACTER SET ISO88591) + EXTERNAL NAME 'com.traf.mgmt.JarFileMgmt.lsAll(java.lang.String[])' + EXTERNAL SECURITY DEFINER + LIBRARY SPJMGMT + LANGUAGE JAVA + PARAMETER STYLE JAVA + READS SQL DATA + ; + GRANT EXECUTE ON PROCEDURE LSALL TO PUBLIC; + + CREATE PROCEDURE RM ( + IN FILENAME VARCHAR(256) CHARACTER SET ISO88591) + EXTERNAL NAME 'com.traf.mgmt.JarFileMgmt.rm(java.lang.String)' + EXTERNAL SECURITY DEFINER + LIBRARY SPJMGMT + LANGUAGE JAVA + PARAMETER STYLE JAVA + READS SQL DATA + ; + GRANT EXECUTE ON PROCEDURE RM TO PUBLIC; + + CREATE PROCEDURE RMREX ( + IN FILENAME VARCHAR(256) CHARACTER SET ISO88591
[jira] [Commented] (TRAFODION-1668) Cannot upload customer SPJ JARs
[ https://issues.apache.org/jira/browse/TRAFODION-1668?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15041806#comment-15041806 ] ASF GitHub Bot commented on TRAFODION-1668: --- Github user robertamarton commented on a diff in the pull request: https://github.com/apache/incubator-trafodion/pull/203#discussion_r46707402 --- Diff: core/conn/spj_init/src/main/resources/init_spj.sql --- @@ -0,0 +1,156 @@ +#!/bin/bash +# @@@ START COPYRIGHT @@@ +# +# Licensed to the Apache Software Foundation (ASF) under one +# or more contributor license agreements. See the NOTICE file +# distributed with this work for additional information +# regarding copyright ownership. The ASF licenses this file +# to you under the Apache License, Version 2.0 (the +# "License"); you may not use this file except in compliance +# with the License. You may obtain a copy of the License at +# +# http://www.apache.org/licenses/LICENSE-2.0 +# +# Unless required by applicable law or agreed to in writing, +# software distributed under the License is distributed on an +# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY +# KIND, either express or implied. See the License for the +# specific language governing permissions and limitations +# under the License. +# +# @@@ END COPYRIGHT @@@ + +SERVER_JAR=${MY_SQROOT}/export/lib/spj_init.jar +CI_SERVER_LOG=${MY_SQROOT}/ciserver/cislog +SQLCI=${MY_SQROOT}/export/bin32/sqlci +CP=/bin/cp +MANAGEABILITY_CATALOG=TRAFODION +CIS_SCHEMA=DEFAULT_SPJ + + +function dropAndCreateSchema { +echo "Creating Schema for CI Server Component" +sqlci << sqlciEOF + + cqd CAT_IGNORE_ALREADY_EXISTS_ERROR 'on'; + cqd CAT_IGNORE_DOES_NOT_EXIST_ERROR 'on'; + + DROP SCHEMA $MANAGEABILITY_CATALOG.$CIS_SCHEMA CASCADE; + CREATE SCHEMA $MANAGEABILITY_CATALOG.$CIS_SCHEMA; + + cqd CAT_IGNORE_ALREADY_EXISTS_ERROR 'off'; + cqd CAT_IGNORE_DOES_NOT_EXIST_ERROR 'off'; + + exit; +sqlciEOF +} + +function createProcedures { + +echo "Creating Procedures in schema '$MANAGEABILITY_CATALOG.$CIS_SCHEMA' " +sqlci << procEOF + + cqd CAT_IGNORE_ALREADY_EXISTS_ERROR 'on'; + cqd CAT_IGNORE_DOES_NOT_EXIST_ERROR 'on'; + + -- Creating Procedures + set schema $MANAGEABILITY_CATALOG.$CIS_SCHEMA; + + DROP LIBRARY SPJMGMT CASCADE; + CREATE LIBRARY SPJMGMT FILE '${SERVER_JAR}'; + + CREATE PROCEDURE HELP ( + INOUT COMMANDNAME VARCHAR(2560) CHARACTER SET ISO88591) + EXTERNAL NAME 'com.traf.mgmt.JarFileMgmt.help (java.lang.String[])' + EXTERNAL SECURITY DEFINER + LIBRARY SPJMGMT + LANGUAGE JAVA + PARAMETER STYLE JAVA + READS SQL DATA + ; + GRANT EXECUTE ON PROCEDURE HELP TO PUBLIC; + + CREATE PROCEDURE PUT ( + IN FILEDATA VARCHAR(102400) CHARACTER SET ISO88591, + IN FILENAME VARCHAR(256) CHARACTER SET ISO88591, + IN CREATEFLAG INTEGER) + EXTERNAL NAME 'com.traf.mgmt.JarFileMgmt.put(java.lang.String,java.lang.String,int)' + EXTERNAL SECURITY DEFINER + LIBRARY SPJMGMT + LANGUAGE JAVA + PARAMETER STYLE JAVA + READS SQL DATA + ; + GRANT EXECUTE ON PROCEDURE PUT TO PUBLIC; + + CREATE PROCEDURE LS ( + IN FILENAME VARCHAR(256) CHARACTER SET ISO88591, + OUT FILENAMES VARCHAR(10240) CHARACTER SET ISO88591) + EXTERNAL NAME 'com.traf.mgmt.JarFileMgmt.ls(java.lang.String,java.lang.String[])' + EXTERNAL SECURITY DEFINER + LIBRARY SPJMGMT + LANGUAGE JAVA + PARAMETER STYLE JAVA + READS SQL DATA + ; + GRANT EXECUTE ON PROCEDURE LS TO PUBLIC; + + CREATE PROCEDURE LSALL ( + OUT FILENAMES VARCHAR(10240) CHARACTER SET ISO88591) + EXTERNAL NAME 'com.traf.mgmt.JarFileMgmt.lsAll(java.lang.String[])' + EXTERNAL SECURITY DEFINER + LIBRARY SPJMGMT + LANGUAGE JAVA + PARAMETER STYLE JAVA + READS SQL DATA + ; + GRANT EXECUTE ON PROCEDURE LSALL TO PUBLIC; + + CREATE PROCEDURE RM ( + IN FILENAME VARCHAR(256) CHARACTER SET ISO88591) + EXTERNAL NAME 'com.traf.mgmt.JarFileMgmt.rm(java.lang.String)' + EXTERNAL SECURITY DEFINER + LIBRARY SPJMGMT + LANGUAGE JAVA + PARAMETER STYLE JAVA + READS SQL DATA + ; + GRANT EXECUTE ON PROCEDURE RM TO PUBLIC; + + CREATE PROCEDURE RMREX ( + IN FILENAME VARCHAR(256) CHARACTER SET ISO88591
[jira] [Commented] (TRAFODION-1666) Need a script to update the version of windows odbc
[ https://issues.apache.org/jira/browse/TRAFODION-1666?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15041787#comment-15041787 ] ASF GitHub Bot commented on TRAFODION-1666: --- Github user asfgit closed the pull request at: https://github.com/apache/incubator-trafodion/pull/201 > Need a script to update the version of windows odbc > --- > > Key: TRAFODION-1666 > URL: https://issues.apache.org/jira/browse/TRAFODION-1666 > Project: Apache Trafodion > Issue Type: Improvement > Components: client-odbc-windows >Affects Versions: 1.3-incubating >Reporter: Weiqing Xu >Priority: Minor > > There are too many files need to be updated when we update the version number > of windows ODBC Driver. It's better to provider a script to do it. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (TRAFODION-1655) RMS reports incorrect hbase io time and 0 for OperCpuTime for operators hosted in ESP
[ https://issues.apache.org/jira/browse/TRAFODION-1655?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15041777#comment-15041777 ] ASF GitHub Bot commented on TRAFODION-1655: --- Github user asfgit closed the pull request at: https://github.com/apache/incubator-trafodion/pull/205 > RMS reports incorrect hbase io time and 0 for OperCpuTime for operators > hosted in ESP > -- > > Key: TRAFODION-1655 > URL: https://issues.apache.org/jira/browse/TRAFODION-1655 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-exe >Reporter: Selvaganesan Govindarajan > Fix For: 2.0-incubating > > > Breakdown of the time spent in hbase and Trafodion seems to be not correct > for all queries. RMS reports 0 operator cpu time for all the operators hosted > in ESPs. For non-parallel plans RMS reports Operator CPU time correctly. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (TRAFODION-1570) sqvers -u displays as if a UTT is installed even when there is no UTT installed
[ https://issues.apache.org/jira/browse/TRAFODION-1570?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15041772#comment-15041772 ] ASF GitHub Bot commented on TRAFODION-1570: --- Github user asfgit closed the pull request at: https://github.com/apache/incubator-trafodion/pull/204 > sqvers -u displays as if a UTT is installed even when there is no UTT > installed > --- > > Key: TRAFODION-1570 > URL: https://issues.apache.org/jira/browse/TRAFODION-1570 > Project: Apache Trafodion > Issue Type: Bug >Reporter: Selvaganesan Govindarajan >Assignee: Hans Zeller > > The version of the jar files and the executables including .so files differ > and hence sqvers -u displays the jar files as if a UTT is installed. > The jar files have Apache_Trafodion release name missing. > > [gselva@dev02 regress]$ sqvers -u > MY_SQROOT=/mnt/gselva/incubator-trafodion/core/sqf > who@host=gselva@dev02 > JAVA_HOME=/usr/lib/jvm/java-1.7.0-openjdk.x86_64 > linux=2.6.32-504.23.4.el6.x86_64 > redhat=6.7 > NO patches > Most common Apache_Trafodion Release 1.3.0 (Build release [gselva], branch > 2578f51-workspace, date 28Oct15) > UTT count is 1 > [7] Release 1.3.0 (Build release [gselva], branch 2578f51-workspace, date > 28Oct15) > export/lib/hbase-trx-cdh5_3-1.3.0.jar > export/lib/hbase-trx-hbase_98_4-1.3.0.jar > export/lib/hbase-trx-hdp2_2-1.3.0.jar > export/lib/hbase-trx-mapr4_0-1.3.0.jar > export/lib/sqmanvers.jar > export/lib/trafodion-dtm-1.3.0.jar > export/lib/trafodion-sql-1.3.0.jar > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (TRAFODION-1677) Implement the ROLLUP and CUBE SQL functions in Trafodion
Qifan Chen created TRAFODION-1677: - Summary: Implement the ROLLUP and CUBE SQL functions in Trafodion Key: TRAFODION-1677 URL: https://issues.apache.org/jira/browse/TRAFODION-1677 Project: Apache Trafodion Issue Type: Bug Components: sql-general Reporter: Qifan Chen I am currently working the high level design for 2nd part of the OLAP function RollUp and Cube. The 1st part (the identification of missing OLAP window functions in Trafodion and their implementation) is done. For RollUp and Cube, I believe the key is to handle many more # of aggregates properly. Note that that number is n for RollUp and 2^n for Cube, where n is the # of grouping columns. Parallel computation of these aggregates is the key. One way to achieve such is to extend the Hash Group By operators so that it can do multiple aggregates in a single operator. The requires the following: 1. random partition the data fed into the aggregate operator 2. force the multiple-level group by 3. pack multiple pairs of groupping and aggregate expressions (both in compiler and in executor, and in MapValueIds, GroupByPartialRoot, and GroupByPartialLeaf). -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (TRAFODION-1676) support better runtime error message when a SQL function meet fital error
liu ming created TRAFODION-1676: --- Summary: support better runtime error message when a SQL function meet fital error Key: TRAFODION-1676 URL: https://issues.apache.org/jira/browse/TRAFODION-1676 Project: Apache Trafodion Issue Type: Improvement Components: sql-exe Reporter: liu ming Priority: Minor A sql contains some SQL function, for example UPPER(), when the input data of UPPER() contains invalid data, UPPER() will fail. In this case, the whole query abort, and the error message cannot tell which row has invalid data, so it is very hard to fix the problem. It will be good to have row id or the real value of the error row in the error message to help trouble shooting. -- This message was sent by Atlassian JIRA (v6.3.4#6332)